Excel Pivot Tables Training:
In-Person in San Francisco
or Online Live
AcademyX's Excel Pivot Tables class will train you how to analyze and summarize data with Pivot Tables and Charts. Hands-on(interactive) training on the following topics:
- Organizing Data: Ensure your spreadsheet is ready for pivot table creation.
- Inserting Pivot Tables: Quickly turn raw data into a dynamic pivot table.
- Data Categories and Normalizing: Manage data types and clean data for consistent results.
- List Design Guidelines: Structure your data lists for seamless pivoting.
- Common Data Mining Techniques: Discover insights using advanced data methods.
- VLOOKUP for Related Data: Add and connect related data to your pivot tables.
- Managing Pivot Tables: Rename, refresh, and modify pivot tables without errors.
- Layering Fields: Add multiple fields to view complex data relationships.
- Filtering, Slicing, and Aggregate Functions: Focus on key data, apply totals, averages, and other calculations.
- Creating Pivot Charts: Visualize your pivoted data with dynamic charts.
- Advanced Layouts and Styles: Design custom reports with professional formats.
- Power Pivot and Data Modeling: Handle large datasets and create relationships.
- Preview of Power Query & Power BI: Explore advanced data import and analysis.
REGISTER:
Price: $350 for 6 hours.
In-Person Training:
No classes scheduled. Get a quote for private training.
Online Live Training:
Dec 4 6am - 1pm day - register
Excel Pivot Tables Training Reviews:
Rated 4.9/5 based on 110 student reviews.
Eye opening! I heard about the magic Pivot Tables could do, but I underestimated how amazed I would be when the instructor taught me how to use it. I learned many ways to save time in managing my data. This was invaluable.
- Maria, Kumon North America, Inc, Burlingame
Very organized and thorough! Instructor K is a patient and enthusiastic instructor - he made the class enjoyable and we learned quite a lot on Pivot Tables.
- Amy Pradhan, UCSF
Really fantastic experience with great insight. Instructor is clear and concise in the teaching of Excel Pivot Tables! Definitely would recommend to anyone looking for an Excel refresh or improvement.
- Elizabeth Duval, Adobe
It was absolutely useful. The Material was informative and can be a good source. The teacher was knowledgeable.
- Farzad Moshfegh, Golden Gate University
I was amazed at how much I learned in a short period of time! Such a great instructor. He's so easy to follow, and he's very engaging.
- Glenn Deleon, City & County of San Francisco
Very informative, great pace and usable skills that will help me throughout my Excel use.
- Gregory Biddle
This was a superior class led and taught by an incredible instructor. The day just flew by and I learned so much! Thank you!
- Margaret McKelvie
Very informative and helpful course that runs at a smooth and understanding pace.
- Matthew Stevenson, Yingli Solar, South San Francisco
* Note: This class description is for our Excel Pivot Tables online San Francisco course. We also offer this Excel course online in Los Angeles, online in Sacramento, and online in San Jose.