Microsoft Excel PivotTables

In the Microsoft Excel PivotTables class, you will learn the right ways to easily analyze large amounts of data in just a few clicks.  Instead of wasting valuable time with standard Excel look-up features, PivotTables allow you to do quick, easy grouping, summarizing, and filtering of data.  If you are looking to add high demand career skills to your resume or to improve your Excel productivity, this Excel PivotTables training is right for you.

In this Microsoft Excel PivotTables class, you will master both PivotTables and PivotCharts, starting with the basics. You will leave this excel class confident in creating an advanced PivotTable and performing advanced data analysis in a short amount of time. Extend your Excel training to be more productive at work and save time today.

As you work through the sessions of Microsoft Excel PivotTables, each class will be a hands-on and intensive workshop, designed to help make difficult topics easier to understand. Your instructor, a Microsoft expert, will work with you closely to make sure that you avoid common mistakes in Excel PivotTables and apply best practices when possible.

Still have questions?  Visit our FAQ page for more help.

• 6 hours of classroom training | Additional assignments outside of class
• Professional Textbook
• Download materials with practice data files
• One month of technical support
• One year for a free re-take (for attended students of public classes only)
• Certificate of Completion

Upon successful completion of the Microsoft Excel PivotTables class, students will be able to:

• Analyze large amounts of data using PivotTables and PivotCharts
• Create a basic Excel PivotTable
• Group and summarize your data in creative ways
• File and sort your PivotTable
• Use advanced features of PivotTables
• Format PivotTables easily
• Use conditional formatting within PivotTables

• Basic digital literacy including file management is required.
• Microsoft Excel Beginners (Level 1) or equivalent knowledge is required.
• It is required you install the latest Microsoft Office software before starting class.

Talk to a student advisor to ensure you have the right pre-requisites for each class or program.