Pivot Tables Training
Attend in Sacramento or Online
AcademyX's pivot tables class will enhance your ability to manipulate, analyze, interpret, and present large quantities of data. With hands-on training, our learn-by-doing curriculum 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:
Jan 26 9am - 3pm day - register
Mar 13 9am - 3pm day - register
Apr 29 9am - 3pm day - register
Jun 17 9am - 3pm day - register
Pivot Tables Class Reviews:
Rated 4.6/5 based on 149 student reviews.
Very good. He kept the class moving and touched on the main points.
- Darren Williams, Sacramento County, Sacramento
Very good. The instructor really knew his subject matter, and customized it to our wants/needs and questions. We are power users of Excel and we all learned a great deal today.
- Sheila Brush, Sacramento
Excellent. I really appreciated the instructor's energy!
- Laura Schwartz, El Dorado County, Placerville
Enjoyed the training it was very informative, I learned a lot.
- Brandon Rodriguez, Delta Dental of California, Rancho Cordova
The course had some informative information- may have been too much of a beginner's course for my level.
- Marissa Marcum, Extreme Engineering, Penryn
Great information - what was expected.
- Kelly Rae Harrell, Barco, Rancho Cordova
It was good, just a lot of info to take in.
- Lindsey English, Olam, Williams
The training was really good. I learned a lot of different options that I did not know existed.
- Kim Picou, Nestle, Sacramento