Learn Excel Pivot Tables in Under 2 Hours

For Beginners, Intermediates and Advanced Excel users
Course Created by MyExcelOnline | John Michaloudis
I am the founder of MyExcelOnline and long time lover of Excel.

I hold a bachelors degree in Commerce (Major in Accounting) from La Trobe University in Melbourne, Australia and speak English, Greek and Spanish.

My journey in to Excel began after I graduated and have since helped many of my colleagues around the world understand this underutilised but powerful tool. Now its my turn to teach the rest of the world!

I am currently living in the North of Spain and I´m married and have one cheeky boy.
You could describe me as a football lover, wine & beer drinker, food indulger and occasional gym goer.

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)

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.

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.

There are 14 different chapters which include 38 short tutorials so you can work on your weaknesses and enhance your strengths whenever you have a spare moment. Each chapter was designed to improve your Pivot Table skills with extra time saving Tips and real life business Case Studies.

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

Course Objectives

  • Analyze thousands of rows of data in to a simple one page table
  • Build interactive Dashboards with Slicers & Charts
  • Inform your business management of key financial trends & metrics

Who Is This For?

  • New users, beginners, intermediates and advanced Excel users
  • Financial Analysts, Business Controllers, Accountants, Auditors, Sales Managers, Administrative Assistants

Course Outline

Chapter 1: CUSTOMISE YOUR PIVOT TABLE

  • Lesson 1
    Tabular Format
    02:26
  • Lesson 2
    Inserting a Pivot Table
    03:23
  • Lesson 3
    Drill down to audit
    01:43
  • Lesson 4
    Sort Field List from A to Z
    00:46
  • Lesson 5
    Refresh
    01:21
  • Lesson 6
    Customising a Pivot Table S…
    04:14
  • Lesson 7
    Change Sum views in Label a…
    00:53
  • Lesson 8
    Show report filter on multi…
    02:24

Chapter 2: VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

  • Lesson 9
    Create multiple subtotals
    01:45
  • Lesson 10
    Show various Grand Totals
    02:37

Chapter 3: VALUE FIELD SETTINGS > SHOW VALUES AS

  • Lesson 11
    % Of
    04:04
  • Lesson 12
    Difference From
    04:55
  • Lesson 13
    Running Total in
    02:21

Chapter 4: GROUPING

  • Lesson 14
    Group by Sales ranges
    03:20
  • Lesson 15
    Group by Text fields
    02:17
  • Lesson 16
    Grouping by a custom date
    01:50

Chapter 5: SORTING

  • Lesson 17
    Sort manually (drag, write,…
    02:02
  • Lesson 18
    Sort using a Custom List
    03:21

Chapter 6: FILTERING

  • Lesson 19
    Filter by Dates
    06:49
  • Lesson 20
    Filter by Labels - Text
    02:44
  • Lesson 21
    Filter by Values - Top or B…
    01:47

Chapter 7: SLICERS (NEW IN EXCEL 2010)

  • Lesson 22
    Insert a Slicer
    04:02
  • Lesson 23
    Slicer Connections for mult…
    03:25
  • Lesson 24
    CASE STUDY: Select a Monthl…
    04:21

Chapter 8: CALCULATED FIELDS & ITEMS

  • Lesson 25
    Creating a Calculated Field
    04:07
  • Lesson 26
    Creating a Calculated Item
    04:13

Chapter 9: PIVOT CHARTS

  • Lesson 27
    Insert a Pivot Chart
    03:25
  • Lesson 28
    Saving a Pivot Chart template
    01:37
  • Lesson 29
    CASE STUDY: Pivot Table Sli…
    15:56

Chapter 10: CONDITIONAL FORMATTING PIVOT TABLES

  • Lesson 30
    Intro to Conditional Format…
    02:44
  • Lesson 31
    Data Bars, Color Scales & I…
    05:50

Chapter 11: GETPIVOTDATA Formula

  • Lesson 32
    Intro to GETPIVOTDATA
    05:00
  • Lesson 33
    Create a custom report with…
    05:25

Chapter 12: MACROS & PIVOT TABLES

  • Lesson 34
    Different pivot table views…
    04:44

Chapter 13: DATA MANAGEMENT

  • Lesson 35
    Compatibility Issues with E…
    01:20
  • Lesson 36
    Sharing a Pivot Table via O…
    02:50

Chapter 14: BONUS VIDEOS

  • Lesson 37
    Consolidate with a Pivot Table
    04:47
  • Lesson 38
    Break Even Model
    03:05

  •   Lifetime access to all lessons!
  •   30 days money back guarantee!
  •   Accessible via iPhone, iPad and Android (soon!)