UPDATED DECEMBER 2018 with the New Excel Pivot Tables Features For Excel 2013 & Excel 2016!

This is the most comprehensive Excel Pivot Table course ever made which has over 220 short and precise tutorials.

No matter if you are a Beginner or an Advanced user of Excel, you are sure to benefit from this course which goes through every single tool that is available in an Excel Pivot Table.  The course is designed for Excel 2007, 2010, 2013 & 2016. 

In no time you will be able to analyze lots  of data and tell a story in a quick and interactive way, learn how to build stunning Dashboards and get noticed by top management &  prospective employers.  The course is just over 10 hours long so you can become an awesome analyst and advanced Excel user within 1 week!  

There are 16 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Excel skills with extra time saving Tips and real life business Case Studies.  Here are the main topics that we will cover in this course:

CUSTOMIZE   YOUR PIVOT TABLE       

VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

VALUE FIELD SETTINGS > SHOW VALUES AS

GROUPING

SORTING

FILTERING

SLICERS

CALCULATED FIELDS & ITEMS

PIVOT CHARTS

CONDITIONAL FORMATTING

GETPIVOTDATA Formula

MACROS       

DATA MANAGEMENT       

BONUS VIDEOS       

NEW EXCEL 2013 PIVOT TABLE FEATURES       

NEW EXCEL 2016 PIVOT TABLE FEATURES   

What you’ll learn

Become an Excel & Pivot Table ADVANCED user within HOURS which will get noticed by top management & prospective employers!

Personal Excel support from a Professional Excel Trainer with 15+ Years of Excel Training!

Learn Pivot Tables, Slicers, PivotCharts, Filtering, Grouping, Sorting, Conditional Formatting, Macros, Dashboards, Data Analysis, GETPIVOTDATA, Calculated Fields, Formatting plus MORE!

Access 220+ HD quality tutorials with DOWNLOADABLE Excel workbooks!

Access 16 Finance & Accounting real world Case Studies PLUS learn the NEW Excel 2013 & 2016 Pivot Table features!

Get LIFETIME access & Quizzes to test the skills learned!

Are there any course requirements or prerequisites?

Excel for Windows 2007, 2010, 2013, 2016, 2019 and Excel for Mac 2011 and 2016.

Some concepts are not available in Excel for Windows 2007 and Excel for Mac 2011, like Slicers and some Pivot table calculations, but this is highlighted in the Course Outline

This course was recorded using Excel for Windows 2010, 2013 & 2016.

Who this course is for:

New users, beginners, intermediates and advanced Excel users

Excel users who want to learn Excel quickly, increase their Excel level and get noticed by their boss!