Excel Pivot Tables Training:
In-Person in San Jose or Online Live

A pivot table is a data summarization tool that can automatically sort, group, count, filter, report, and summate data with simple dragging and dropping. AcademyX's hands-on pivot tables training covers these 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:
Jul 23 9am - 4pm day - register
Sep 24 9am - 4pm day - register
Dec 3 6am - 1pm day - register
Excel Pivot Tables Training Reviews:

Rated 4.8/5 based on 123 student reviews.
Enjoyed all topics of this training.
- Martha Toral, SJSU Foundation, San Jose
Excellent, very useful. The practice in setting up our own tables was very important.
- Wendy Arienzo, FujiFilm, Santa Clara
Very interesting.
- Laura Doherty, Dimatrix, Santa Clara
The training was excellent. Very good pace and knowledge of instructor. The course covered the fundamentals that I was looking for.
- Jose Luis Gonzales, Green Tweed, Fremont
Very helpful. Loved the small group.
- Kacey Sunseri, Mark Thomas and Company, San Jose
Excellent!
- Van Nguyen, Juniper Networks, Sunnyvale
Very well done. Great instructor.
- JoAnn Arjo, Synaptics, San Jose
Easy to understand and learn.
- Elaine Wang, First 5 Santa Clara, San Jose