8:00 AM - 4:00 PM Central
Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you!
In this dynamic and engaging session, you'll master how to:
• Build PivotTables from scratch
• Group data inside PivotTables, including options for fiscal periods
• Create user-defined calculations in your PivotTables
We start with the fundamentals and quickly move to advanced techniques, including:
• Building PivotTables that consolidate data from multiple ranges
• Connecting PivotTables dynamically to external databases and financial accounting systems
• Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot
This seminar is a must for anyone eager to enhance their Excel skills and transform their workflow. With guidance and coaching from your K2 instructor, you'll be ready to use PivotTables to analyze and report on extensive data sets in a fraction of the time you spend completing such tasks.
Speakers:
Thomas G. Stephens Jr., CPA.CITP, CGMA