Video: .MP4, 1280x720 | Audio: AAC, 44100Hz, 2ch | Duration: 10,5h
Genre: eLearning | Language: English + Sub | Size: 1,44 GB

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