• expired

$39 (50% OFF) Excel Pivot Table Course with 200+ Downloadable Videos

00
OZBARGAIN50%

This is the ultimate Excel Pivot Table course which has more than 200 short and precise tutorials. You can call it the "Encyclopedia of Excel Pivot Tables"!

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 or 2013.

There are 14 different chapters so you can work on your weaknesses and enhance your strengths. Each chapter was designed to improve your Pivot Table skills with extra time saving Tips and real life business Case Studies.

On 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.

In this course there are downloadable Excel workbooks for each tutorial, a BONUS Pivot Table Cheat Sheet, an Excel Tutorial Tracker and my Top 20 Excel Shortcuts in an animated gif format.

So go ahead and learn from the following in depth Pivot table subjects:
1 CUSTOMISE YOUR PIVOT TABLE
2 VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
3 VALUE FIELD SETTINGS > SHOW VALUES AS
4 GROUPING
5 SORT
6 FILTER
7 SLICERS (NEW IN EXCEL 2010)
8 CALCULATED FIELDS & ITEMS
9 PIVOT CHARTS
10 CONDITIONAL FORMATTING PIVOT TABLES
11 GETPIVOTDATA formula
12 MACROS
13 DATA MANAGEMENT
14 BONUS VIDEOS

Related Stores

myexcelonline.com
myexcelonline.com

closed Comments

  • If it was free, it would be a bargain…

  • i'm pretty sure I have a kindle ebook on this somewhere…

  • +1

    I'm sure I enrolled in a udemy course about this the other day…
    https://www.ozbargain.com.au/node/115376

    • +1

      Don't you mean "the other year"?

      • I swear it felt like the other day… I guess time flies when you spend your life on ozbargain -_-

  • I used to do a lot of pivot tabling now I just use Tableau.

    • +1

      I used to do a lot of pivot tabling

      at the Spearmint Rhino ?

      • blue oyster bar and now this. you are a cultured gentleman.

Login or Join to leave a comment