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
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.