Objectives
To teach you to leverage Excel’s powerful features and adopt best practices that maximize efficiency, improve security and boost productivity.
Schedule
Excel offers so many features, functions and options that it is easy to overlook some of the most useful and fundamental features. As examples — templates, Flash Fill, Conditional Formatting, Data Consolidate, collaboration options, data protection tools, and Highlight Changes — are all great examples of Excel features that sometimes do not get the attention they deserve. In this session, you will learn about many of Excel’s overlooked tools — tools that can help you and your team to create effective Excel spreadsheets quickly and easily. If you’re looking to ensure that your spreadsheets take advantage of Excel’s best fundamental tools, make plans today to participate in this session!
Credit: Computer Software and Applications - 2
Unlock the full potential of Excel with this deep dive into some of its most powerful and time-saving features. Explore the advantages of using modern tools like Office Scripts over legacy VBA macros, and discover how Power Pivot can supercharge your PivotTable capabilities. Learn how Dynamic Arrays can simplify complex formulas, get introduced to the Inquire add-in for workbook analysis and auditing, and walk away with five new Excel functions that will instantly boost your productivity. Whether you're a casual user or an Excel power user, this session will equip you with practical insights to work smarter and more efficiently.
Credit: Computer Software and Applications - 2
Take your Excel skills to the next level with powerful tools that streamline reporting, automate data workflows and transform raw information into business-ready insights. This session dives deep into Excel Tables and Power Query — two essential tools for professionals managing large volumes of data. Learn how to create automated reporting systems using table features and formulas, reduce manual entry errors, and build dynamic data models for efficient analysis. You’ll also gain hands-on techniques for using Power Query to clean, reshape and integrate data from multiple sources, including workbooks, databases and APIs. Whether you’re looking to simplify daily tasks or enhance large-scale information management, this session will equip you with practical strategies to boost accuracy, consistency and productivity.
Credit: Computer Software and Applications - 2
Take your PivotTable skills to the next level by exploring advanced tools and techniques that make data analysis more flexible and insightful. This session covers traditional PivotTable creation methods while introducing powerful enhancements like user-defined calculations, Power Query integration, and the game-changing new functions PIVOTBY and GROUPBY. You’ll learn when to use these new tools, how to overcome common PivotChart limitations, and where Power Query can streamline your workflow. Perfect for users ready to move beyond the basics, this session will help you unlock more dynamic and efficient ways to work with your data.
Credit: Computer Software and Applications - 2
Attend this on-demand ethics course on your schedule at no additional charge.
The rapid evolution of artificial intelligence (AI) is reshaping industries, including accounting, with profound implications for professionals and firms. This Virginia Board of Accountancy-approved ethics course on responsible AI for the accounting profession explores the integration of AI in accounting, emphasizing ethical principles like transparency, accountability, privacy and fairness. The course offers a comprehensive overview of AI technologies, their applications in streamlining processes, and improving decision-making within the profession. It also addresses the challenges of regulatory compliance, data privacy and mitigating risks such as bias and security breaches. Through real-world case studies, you will gain insights into resolving ethical dilemmas, ensuring responsible AI usage, and fostering trust with clients and stakeholders.
By completing this course, you will develop strategies to navigate the complexities of AI governance and regulation, create robust frameworks for ethical decision-making, and adopt sustainable practices to balance innovation with responsibility. Designed for accounting professionals at all levels, this course equips learners with the tools to harness AI's potential while upholding the profession's ethical standards, ensuring compliance with legal obligations, and contributing to a more inclusive and accountable AI future.
Credit: Regulatory Ethics — 2
Attend this on-demand ethics course on your schedule at no additional charge.
The CPA profession in Virginia, like in many other states, is governed by a complex framework of laws, regulations and ethical standards. As a CPA, you are expected to adhere to these guidelines, maintain the highest level of professional integrity, and act in the public interest.
This Virginia Board of Accountancy (VBOA)-approved ethics course is designed to provide you with a comprehensive understanding of the regulatory and ethical landscape of the accounting profession in Virginia. We will explore the key principles of professional ethics, the role of the VBOA, and the specific regulations that govern the practice of public accounting in the state.
Credit: Regulatory Ethics — 2
Attend this on-demand ethics course on your schedule at no additional charge.
This Virginia Board of Accountancy-approved ethics course provides a thorough exploration of ethical principles, challenges and best practices essential to the accounting profession. You will gain a deep understanding of the AICPA Code of Professional Conduct, including its guiding principles of integrity, objectivity and independence. The course highlights key ethical frameworks, such as managing conflicts of interest, safeguarding client confidentiality, and responding to noncompliance with laws and regulations (NOCLAR). Explore real-world scenarios and case studies that illustrate common ethical dilemmas accountants face, and obtain practical strategies for navigating these situations while upholding professional standards.
You will also learn how to apply professional skepticism, maintain independence when providing non-attest services, and manage risks associated with ethical conflicts. The course emphasizes the importance of fostering a culture of ethics within firms and explores updates to tax standards and reporting requirements. By the end of the course, you will be equipped with the knowledge and tools to address ethical challenges effectively, ensuring your practice aligns with professional expectations and public trust.
Credit: Regulatory Ethics — 2
Speakers
Advanced Preparation
None
Vendor
The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.
For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.