Description:
Description
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
———-
Look, if you are really serious about…
…Getting better at Excel and advancing your Excel level & skills…
…Saving hours each day, days each week and weeks each year…
…If you want to improve your professional development to achieve greater opportunities like promotions, a higher salary and knowledge that you can take to another job…
…All whilst impressing your boss and standing out from your colleagues and peers…
THEN THE XTREME EXCEL PIVOT TABLE COURSE IS FOR YOU!
Now you have the opportunity to join your fellow professionals who are taking this course and enhancing their Excel skills daily!
To enroll, click the BUY NOW button below (risk-free for 30 days or your money back)…
…Because every hour you delay only delays your personal and professional progress…
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!
Requirements
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.
Last updated 12/2018 |
-