Prerequisite: Microsoft Excel Advanced Pivot Tables Workshop or equivalent experience.
This virtual half-day instructor-led workshop combines live instruction, guided practice, and collaborative exercises to help you master advanced Pivot-table techniques from anywhere.
Take your Pivot-table skills to the next level in this advanced, hands-on workshop tailored for users who already understand the basics and want to dive deeper into advanced techniques.
You'll gain confidence in tackling complex data scenarios and building interactive analytical tools.
Key topics covered:
- Connecting and analyzing data from multiple related tables using the Data Model
- Creating powerful custom calculations and measures with DAX formulas
- Building dynamic dashboards with connected slicers, timelines, and Pivot Charts
- Applying advanced formatting, conditional highlighting, and custom styles
- Cleaning and transforming data with Power Query for error-free Pivot-tables
This session emphasizes hands-on learning and real-world application, you'll spend most of the class building, experimenting, and discovering the full capabilities of Pivot-tables in an interactive, collaborative setting. Whether you're looking to enhance your analytical tools or solve complex data challenges, this workshop will empower you to master the full potential of Pivot-tables.
Mac Users: Please note that certain advanced Excel features such as the Data Model, DAX measures, and full Power Query functionality are not fully supported in Excel for Mac. You will still benefit from most of the class content, but some hands-on exercises may differ on Mac.
Cost: Free to attend. During registration, you will be asked to provide your department’s chart of accounts. A $75 fee will apply only if you cancel your registration within 7 days of the workshop or fail to attend. If you are unsure of your department’s chart of accounts, please check with your supervisor or department budget administrator.
Register in the UC Learning Center
(MyAccess login required)