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:


4.5/5 review stars

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

► More reviews...