Microsoft Excel - The Xtreme Excel Pivot Tables Course
4.4 (947 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
26,902 students enrolled

Microsoft Excel - The Xtreme Excel Pivot Tables Course

Excel with this A-Z Microsoft Excel Pivot Table Course. Microsoft Excel 2010, Excel 2013, Excel 2016, Excel 2019
4.4 (947 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
26,902 students enrolled
Created by John Michaloudis
Last updated 12/2018
English
English, Italian [Auto-generated]
Current price: $11.99 Original price: $199.99 Discount: 94% off
2 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 10.5 hours on-demand video
  • 22 articles
  • 22 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
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!
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.
Description

***** THE MOST VIDEO TUTORIALS IN ANY OF THE UDEMY EXCEL COURSES *****

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

----------

Listen to a few of our satisfied students who have taken this course and advanced their Excel skills in days:

          "This course is tremendously comprehensive. The best part is that the  course is served in small bite-sized pieces that are easily digested.  A teaching course that  doubles as a reference guide. Definitely worth your time and money" - James

           "I thought I was good in Excel before starting this course, but this course showed me how much more I can do in Excel. I used most of the techniques taught in the course to create a Dashboard at work. John's teaching style is perfect. Unlike other courses, he used real examples to explain the concepts. I highly recommend this course" - Sumit

           "I would highly recommend this course for anyone who is keen to learn all  features of Pivot Tables. The practical examples i.e. Interactive Balance Sheet Pivot table, Top 10 macro are just a few of the great  examples. Tutor also helped by promptly answering questions when I stuck. All in all, a highly recommended course!" - A.R.
----------

If you want to get better at Excel and stand out from the crowd to get the promotions or pay-rises that you deserve, then you are in the right place!

This is the most comprehensive Excel Pivot Table online 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 & 2019.

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:

  1. CUSTOMIZE   YOUR PIVOT TABLE       

  2. VALUE FIELD SETTINGS > SUMMARIZE VALUES BY

  3. VALUE FIELD SETTINGS > SHOW VALUES AS

  4. GROUPING

  5. SORTING

  6. FILTERING

  7. SLICERS

  8. CALCULATED FIELDS & ITEMS

  9. PIVOT CHARTS

  10. CONDITIONAL FORMATTING

  11. GETPIVOTDATA Formula

  12. MACROS       

  13. DATA MANAGEMENT       

  14. BONUS VIDEOS       

  15. NEW EXCEL 2013 PIVOT TABLE FEATURES       

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

*** Get LIFETIME Course access including over 220 downloadable Excel workbooks, Quizzes, 1-on-1 instructor SUPPORT and  a 100% money-back guarantee! *** 

*** Watch our PROMO VIDEO above and a few of our FREE VIDEO TUTORIALS to see for yourself just how beneficial this course is and how you too can become better at Excel ***

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!
Course content
Expand all 252 lectures 10:44:40
+ INTRODUCTION
9 lectures 02:51

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!  

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.  

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.  

You can then follow along as I go through the instructions in each tutorial.  

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!  


Thank You,  

John Michaloudis

Chief Inspirational Officer

www.MyExcelOnline.com 

EXCEL WORKBOOKS - IMPORTANT INSTRUCTIONS (PLEASE READ)
00:30
BONUS #2: PIVOT TABLE CHEAT SHEET
12 pages

Bonus Cheat Sheet

BONUS #3: 5 SPEEDY STEPS TO AN EXCEL PIVOT TABLE INFORGRAPHIC
00:00

Visit my brand new Excel blog where I have short 1 minute tutorials & downloadable free example workbooks from all topics like Formulas, Pivot Tables, Data Analysis, Charts, Macros & Shortcuts.

Also don't forget to subscribe so you can receive the Free Weekly Excel Lesson Plans!

Here is the link >>> http://www.myexcelonline.com/blog

Preview 1 page
+ CUSTOMIZING YOUR EXCEL PIVOT TABLE
47 lectures 01:28:34

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!

Thank You,


JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:02

Customize your Excel Pivot Table - Tabular Format

Preview 02:25

Customize your Excel Pivot Table - No Gaps

ARRANGING YOUR DATA SET ~ No Gaps
02:30

Customize your Excel Pivot Table - Formatting

ARRANGING YOUR DATA SET ~ Formatting
01:27

Customize your Excel Pivot Table - Excel Tables

ARRANGING YOUR DATA SET ~ Tables
02:46

Customize your Excel Pivot Table - Clean Your Data Set

ARRANGING YOUR DATA SET ~ TIP: Clean Your Data Set
02:18

Customize your Excel Pivot Table - Insert a Pivot Table

Preview 03:22

Customize your Excel Pivot Table - Field List, Activate, Move

CREATING A PIVOT TABLE ~ Field List - Activate, move, resize & layout
01:40

Customize your Excel Pivot Table - Field List & Areas

CREATING A PIVOT TABLE ~ Field List & Areas
05:26

Customize your Excel Pivot Table - Drill down to audit

Preview 01:42

Customize your Excel Pivot Table - Sort Field List

CREATING A PIVOT TABLE ~ Sort Field List from A to Z
00:45

Customize your Excel Pivot Table - Double click on a label

CREATING A PIVOT TABLE ~ TIP: Double click on any labels to show more Fields
00:53

Customize your Excel Pivot Table - Defer layout update 

CREATING A PIVOT TABLE ~ TIP: Defer Layout Update
00:55

Customize your Excel Pivot Table - Pivot Cache

OPTIONS > DATA ~ Pivot Cache explained
01:01

Customize your Excel Pivot Table - Refresh

OPTIONS > DATA ~ Refresh
01:20

Customize your Excel Pivot Table - Refresh All

OPTIONS > DATA ~ Refresh All
02:17

Customize your Excel Pivot Table - Refresh External Data

OPTIONS > DATA ~ Refresh External Data
04:59

Customize your Excel Pivot Table - Import from Access

OPTIONS > DATA ~ Import from Access database
02:27

Customize your Microsoft Excel Pivot Table - Change Data Source

OPTIONS > DATA ~ Change Data Source
03:10

Customize your Microsoft Excel Pivot Table - Clear Filters & Pivot

OPTIONS > ACTIONS ~ Clear Filters & Clear Pivot
01:17

Customize your Microsoft Excel Pivot Table - Select & Format

OPTIONS > ACTIONS ~ Select & format
03:15

Customize your Microsoft Excel Pivot Table - Move a Pivot Table

OPTIONS > ACTIONS ~ Move a Pivot Table
01:01

Customize your Microsoft Excel Pivot Table - Pivot Table Styles

DESIGN > STYLES ~ Pivot Table Styles
03:43

Customize your Microsoft Excel Pivot Table - Customizing a Pivot Table

DESIGN > STYLES ~ Customising a Pivot Table Style
04:13

Customize your Microsoft Excel Pivot Table - Customized Pivot Table Styles

DESIGN > STYLES ~ Use a customised style in another workbook
01:27

Customize your Microsoft Excel Pivot Table - Subtotals

DESIGN > LAYOUT ~ Subtotals
00:55

Customize your Microsoft Excel Pivot Table - Grand Totals

DESIGN > LAYOUT ~ Grand Totals
01:01

Customize your Microsoft Excel Pivot Table - Report Layouts

DESIGN > LAYOUT ~ Report Layouts
02:48

Customize your Microsoft Excel Pivot Table - Blank Rows

DESIGN > LAYOUT ~ Blank Rows
00:40

Customize your Microsoft Excel Pivot Table - Classic Pivot Table Layout

DESIGN > LAYOUT ~ TIP: Show the Classic Pivot Table Layout
01:08

Customize your Microsoft Excel Pivot Table - Expand & Collapse buttons

OPTIONS > SHOW ~ Expand & Collapse buttons
04:26

Customize your Microsoft Excel Pivot Table - Move & Remove Field Items

OPTIONS > SHOW ~ Move & Remove Fields and Items
02:39

Customize your Microsoft Excel Pivot Table - Show & Hide Field List

OPTIONS > SHOW ~ Show/Hide Field List
00:27

Customize your Microsoft Excel Pivot Table - Show & Hide Field Headers

OPTIONS > SHOW ~ Show/Hide Field Headers
00:27

Customize your Microsoft Excel Pivot Table - Change from Count to Sum

CUSTOMISATION ~ Change "Count of" to "Sum of"
01:10

Customize your Microsoft Excel Pivot Table - Number Formatting

CUSTOMISATION ~ Number formatting
01:42

Customize your Microsoft Excel Pivot Table - Field Name formatting

CUSTOMISATION ~ Field name formatting
02:16

Customize your Microsoft Excel Pivot Table - Predetermined number formatting

CUSTOMISATION ~ TIP: Predetermined number formatting
01:29

Customize your Microsoft Excel Pivot Table - Change Sum values

CUSTOMISATION ~ TIP: Change Sum views in Label areas
00:52

Customize your Microsoft Excel Pivot Table - Indent Rows

LAYOUT & FORMAT ~ Indent rows in compact layout
01:00

Customize your Microsoft Excel Pivot Table - Change Report Filter layout

LAYOUT & FORMAT ~ Change the layout of a report filter
01:25

Customize your Microsoft Excel Pivot Table - Format error values

LAYOUT & FORMAT ~ Format error values
00:49

Customize your Microsoft Excel Pivot Table - Format empty cells

LAYOUT & FORMAT ~ Format empty cells
01:27

Customize your Microsoft Excel Pivot Table - Fix column widths

LAYOUT & FORMAT ~ Keep column widths upon refresh
00:53

Customize your Microsoft Excel Pivot Table - Automatic Pivot Table Refresh

LAYOUT & FORMAT ~ TIP: Automatic Refresh a Pivot Table
00:56

Customize your Microsoft Excel Pivot Table - Print a Pivot Table 

LAYOUT & FORMAT ~ TIP: Printing a pivot table on two pages
01:20

Customize your Microsoft Excel Pivot Table - Show Report Filter items on multiple sheets

Preview 02:23
CUSTOMIZE YOUR PIVOT TABLE
3 questions
+ VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
14 lectures 40:45

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Summarize your Microsoft Excel Pivot Table - Multiple Subtotals

Preview 01:44

Summarize your Microsoft Excel Pivot Table - Count

Count
02:27

Summarize your Microsoft Excel Pivot Table - Average

Average
02:43

Summarize your Microsoft Excel Pivot Table - Maximum

Maximum
02:03

Summarize your Microsoft Excel Pivot Table - Minimum

Minimum
01:26

Summarize your Microsoft Excel Pivot Table - Product

Product
03:39

Summarize your Microsoft Excel Pivot Table - Count Numbers

Count Numbers
02:26

Summarize your Microsoft Excel Pivot Table - Standard Deviation

Std Dev
07:07

Summarize your Microsoft Excel Pivot Table - Variance Population

Varp
03:36

Summarize your Microsoft Excel Pivot Table - Show various Grand Totals

TIP: Show various Grand Totals
02:36

Summarize your Microsoft Excel Pivot Table - Shortcuts

TIP: Shortcuts to Field & Value Field Settings
02:19

Summarize your Microsoft Excel Pivot Table - See all Pivot Table items

TIP: See all pivot Items
06:00

Summarize your Microsoft Excel Pivot Table - Show a unique count

TIP: Show a unique count
02:36
VALUE FIELD SETTINGS > SUMMARIZE VALUES BY
3 questions
+ VALUE FIELD SETTINGS > SHOW VALUES AS
18 lectures 50:26

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Summarize your Microsoft Excel Pivot Table - % of Grand Total

% of Grand Total
02:09

% of Column Total

% of Column Total
02:15

Summarize your Microsoft Excel Pivot Table - % of Row Total

% of Row Total
01:55

Summarize your Microsoft Excel Pivot Table - % Of

% Of
04:03

Summarize your Microsoft Excel Pivot Table - % of Parent Row Total (New in Excel 2013, Excel 2013 & Excel 2016)

% of Parent Row Total (NEW IN EXCEL 2010)
03:19

Summarize your Microsoft Excel Pivot Table - % of Parent Column Total (New in Excel 2013, Excel 2013 & Excel 2016)

% of Parent Column Total (NEW IN EXCEL 2010)
02:23

Summarize your Microsoft Excel Pivot Table - % of Parent Total (New in Excel 2010, Excel 2013 & Excel 2016)

% of Parent Total (NEW IN EXCEL 2010)
02:52

Summarize your Microsoft Excel Pivot Table - Difference From

Preview 04:54

Summarize your Microsoft Excel Pivot Table - % Difference From

% Difference From
04:18

Summarize your Microsoft Excel Pivot Table - Running Total In

Running Total in
02:20

Summarize your Microsoft Excel Pivot Table - % Running Total In (New in Excel 2010, Excel 2013 & Excel 2016)

% Running Total in (NEW IN EXCEL 2010)
02:58

Summarize your Microsoft Excel Pivot Table - Rank Smallest to Largest (New in Excel 2010, Excel 2013 & Excel 2016)

Rank Smallest to Largest (NEW IN EXCEL 2010)
02:14

Summarize your Microsoft Excel Pivot Table - Rank Largest to Smallest (New in Excel 2010, Excel 2013 & Excel 2016)

Rank Largest to Smallest (NEW IN EXCEL 2010)
02:21

Summarize your Microsoft Excel Pivot Table - Index

Index
03:45

Summarize your Microsoft Excel Pivot Table - Shortcuts

TIP: Shortcuts to Show Values As
01:16

Summarize your Microsoft Excel Pivot Table - % of Revenue Margins 

CASE STUDY ~ ACCOUNTING: % of Revenue Margins
02:38

Summarize your Microsoft Excel Pivot Table - Actual v Plan variance report

CASE STUDY ~ FINANCIAL: Actual v Plan Variance Report
04:43
VALUE FIELD SETTINGS > SHOW VALUES AS
3 questions
+ GROUPING
18 lectures 47:46

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Group your Microsoft Excel Pivot Table - by Date

Group by Date
02:45

Group your Microsoft Excel Pivot Table - by Months

Group by Months
01:51

Group your Microsoft Excel Pivot Table - by Quarters & Years

Group by Quarters & Years
01:48

Group your Microsoft Excel Pivot Table - by Sales ranges

Preview 03:19

Group your Microsoft Excel Pivot Table - by Text fields

Group by Text fields
02:16

Group your Microsoft Excel Pivot Table - by Time

Group by Time
01:45

Group your Microsoft Excel Pivot Table - Shortcuts

TIP: Shortcuts to Grouping
01:40

Group your Microsoft Excel Pivot Table - by Half Years

TIP: Grouping by Half Years
01:55

Group your Microsoft Excel Pivot Table - Dates that start on a Monday

TIP: Group by a Date that starts on a Monday
02:00

Group your Microsoft Excel Pivot Table - by Custom Dates

TIP: Grouping by a custom date
01:49

Group your Microsoft Excel Pivot Table - by Fiscal years & Quarters

TIP: Group by fiscal years & quarters
06:36

Group your Microsoft Excel Pivot Table - Errors

TIP: Errors when grouping by dates
02:54

Group your Microsoft Excel Pivot Table - by 2 Pivot Tables

TIP: Group two pivot tables independently
03:53

Group your Microsoft Excel Pivot Table - Fixing problems

TIP: Fixing the problem of counting grouped sales
00:46

Group your Microsoft Excel Pivot Table - Display Dates

TIP: Display dates that have no data
00:59

Group your Microsoft Excel Pivot Table - Quarterly Comparative Report

CASE STUDY ~ ACCOUNTING: Quarterly Comparative Report
06:45

Group your Microsoft Excel Pivot Table - Minimum & Maximum Bank Balance

CASE STUDY ~ FINANCIAL: Min & Max Bank Balance
04:42
GROUPING
3 questions
+ SORTING
10 lectures 13:57

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Sort your Microsoft Excel Pivot Table - Largest to Smallest

Sorting by Largest or Smallest
01:59

Sort your Microsoft Excel Pivot Table - Left to Right

Sort an Item Row (Left to Right)
01:31

Sort your Microsoft Excel Pivot Table - Manually

Sort manually (drag, write, right click)
02:01

Sort your Microsoft Excel Pivot Table - Custom List

Preview 03:20

Sort your Microsoft Excel Pivot Table - Override a Custom List

Override a Custom List sort
01:27

Sort your Microsoft Excel Pivot Table - From A-Z

Sort row from A-Z and sales from Z-A
01:23

Sort your Microsoft Excel Pivot Table - New items

TIP: Sort new items added to your data source
01:19

Sort your Microsoft Excel Pivot Table - Clear a Sort

TIP: Clear a sort
00:28

Sort your Microsoft Excel Pivot Table - Largest to Smallest Grand Totals

TIP: Sort Largest to Smallest Grand Totals
00:26
SORTING
3 questions
+ FILTERING
20 lectures 45:13

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Filter your Microsoft Excel Pivot Table - Dates

Filter by Dates
06:48

Filter your Microsoft Excel Pivot Table - Text

Filter by Labels - Text
02:43

Filter your Microsoft Excel Pivot Table - Numeric Text

Filter by Labels - Numerical Text
02:52

Filter your Microsoft Excel Pivot Table - Values

Filter by Values
03:58

Filter your Microsoft Excel Pivot Table - Top or Bottom X Items

Filter by Values - Top or Bottom 10 Items
02:13

Filter your Microsoft Excel Pivot Table - Top or Bottom %

Preview 01:46

Filter your Microsoft Excel Pivot Table - Top or Bottom Sum

Filter by Values - Top or Bottom Sum
01:49

Filter your Microsoft Excel Pivot Table - Report Filter

Filter by Report Filter
03:38

Filter your Microsoft Excel Pivot Table - Shortcuts

TIP: Shortcuts to filters
01:43

Filter your Microsoft Excel Pivot Table - Keep or Hide selected items

TIP: Keep or hide selected items
00:57

Filter your Microsoft Excel Pivot Table - Wildcards

TIP: Filter by Text wildcards * and ?
03:27

Filter your Microsoft Excel Pivot Table - Multiple Fields

TIP: Filter by multiple fields
01:07

Filter your Microsoft Excel Pivot Table - Apply multiple filters

TIP: Apply multiple filters
01:52

Filter your Microsoft Excel Pivot Table - Multiple values

TIP: Filter by multiple values
01:14

Filter your Microsoft Excel Pivot Table - Include new Items

TIP: Include new items in manual filter
01:58

Filter your Microsoft Excel Pivot Table - Clear Filters

TIP: Clear filters with one click
01:37

Filter your Microsoft Excel Pivot Table - Add a filter in the Column Items

TIP: Add a filter for the column items
00:40

Filter your Microsoft Excel Pivot Table - Top 5 Expense Report

CASE STUDY ~ ACCOUNTING: Top 5 Expenses report
02:30

Filter your Microsoft Excel Pivot Table - Top 25% of Channel Partners

CASE STUDY ~ FINANCIAL: Top 25% of Channel Partners
02:18
FILTERING
3 questions
+ SLICERS (NEW IN EXCEL 2010)
14 lectures 48:25

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Slicer your Microsoft Excel Pivot Table - Insert a Slicer

Preview 04:01

Slicer your Microsoft Excel Pivot Table - Styles

Slicer Styles
02:26

Slicer your Microsoft Excel Pivot Table - Custom Styles

Creating a custom style
05:38

Slicer your Microsoft Excel Pivot Table - Custom Styles in new workbooks

Copy a custom style into a new workbook
01:40

Slicer your Microsoft Excel Pivot Table - Settings

Slicer Settings
04:50

Slicer your Microsoft Excel Pivot Table - Size & Properties

Slicer Size & Properties
03:03

Slicer your Microsoft Excel Pivot Table - Slicer Connections for multiple Pivot Tables

Preview 03:24

Slicer your Microsoft Excel Pivot Table - Different ways to Filter a Slicer

TIP: Different ways to filter a Slicer
01:23

Slicer your Microsoft Excel Pivot Table - Use one Slicer for 2 Pivot Tables

TIP: Use one slicer for two pivot tables
01:26

Slicer your Microsoft Excel Pivot Table - Lock the workbook but not the Slicer

TIP: Lock the workbook but not the slicer
01:33

Slicer your Microsoft Excel Pivot Table - Interactive employee photos

TIP: Interactive employee photos with Slicers! FUN!
09:28

Slicer your Microsoft Excel Pivot Table - Select a Monthly Profit & Loss Report

CASE STUDY ~ ACCOUNTING: Select a Monthly P&L report with a Slicer
04:20

Slicer your Microsoft Excel Pivot Table - Base, Best & Worst case forecasts

CASE STUDY ~ FINANCIAL: Base, Best & Worst case Forecast
05:10
SLICERS
3 questions
+ CALCULATED FIELDS & ITEMS
17 lectures 49:40

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Insert a Calculated Field in your Microsoft Excel Pivot Table - Create a Calculated Field

Creating a Calculated Field
04:06

Insert a Calculated Field in your Microsoft Excel Pivot Table - New Calculations

Use an existing Calculated Field in a new calculation
02:24

Insert a Calculated Field in your Microsoft Excel Pivot Table - Editing

Editing a Calculated Field
02:03

Insert a Calculated Field in your Microsoft Excel Pivot Table - Excel Formulas allowed

Excel formulas & Calculated Fields
03:07

Insert a Calculated Item in your Microsoft Excel Pivot Table - Creating

Creating a Calculated Item
04:12

Insert a Calculated Item in your Microsoft Excel Pivot Table - New calculation

Use an existing Calculated Item in a new calculation
01:43

Insert a Calculated Item in your Microsoft Excel Pivot Table - Editing

Editing a Calculated Item
02:26

Insert a Calculated Item in your Microsoft Excel Pivot Table - Excel Formulas

Excel formulas & Calculated Items
01:58

Insert a Calculated Item in your Microsoft Excel Pivot Table - Column Labels

Calculated Item on Column Labels
02:14

Insert a Calculated Item in your Microsoft Excel Pivot Table - Shortcomings 

Shortcomings of Calculated Items
02:04

Insert a Calculated Item in your Microsoft Excel Pivot Table - Solve Order

TIP: Solve Order for Calculated Items
04:11

Insert a Calculated Field in your Microsoft Excel Pivot Table - Lists

TIP: List Calculated Field & Item formulas
01:12

Insert a Calculated Field in your Microsoft Excel Pivot Table - Remove

TIP: Remove a Calculated Field temporarily
01:00

Insert a Calculated Field in your Microsoft Excel Pivot Table - Order of Operations

TIP: Order of operations
01:56

Insert a Calculated Field in your Microsoft Excel Pivot Table - Create a Profit & Loss Pivot Table report

Preview 08:25

Insert a Calculated Field in your Microsoft Excel Pivot Table - Actual v Plan report

CASE STUDY ~ FINANCIAL: Actuals v Plan with Calculated Fields
06:36
CALCULATED FIELDS & ITEMS
3 questions
+ PIVOT CHARTS
22 lectures 01:12:19

Dear Student,

Each tutorial comes with an Excel workbook which you can download at the start of each chapter and keep on your desktop to practice forever!

These workbooks are in a finished form with the Pivot Table already created for you, as I show you during the video.

It is recommended that you follow along by creating a new Pivot Table simply by clicking in the data within the Data_Table sheet of each workbook and going to Insert > Pivot Table > New Worksheet.

You can then follow along as I go through the instructions in each tutorial.

By re-creating the Pivot Table from the beginning, this is the best way to learn and enhance your Excel knowledge!


Thank You,

JOHN MICHALOUDIS

YOUR PIVOT TABLE INSTRUCTOR

WORKBOOKS
00:03

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Insert

Preview 03:24

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Slicers & Pivot Charts

Insert a Slicer with a Pivot Chart
02:00

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Designs

Pivot Chart Designs
03:55

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Layouts

Pivot Chart Layouts
05:04

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Formats

Pivot Chart Formats
05:57

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Limitations

Limitations of Pivot Charts & workarounds
02:02

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Saving a template

Saving a Pivot Chart template
01:36

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Shortcuts

TIP: Shortcuts to formatting a Pivot Chart
01:23

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Link Chart Title

TIP: Link chart title to a pivot cell
01:05

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Chart copy

TIP: Copying a second chart
00:51

Insert a Pivot Chart in your Microsoft Excel Pivot Table - F11 Chart creator

TIP: Put a chart on a separate page with F11
00:47

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Straight from your data source

TIP: Insert Pivot Chart straight from the data source
00:59

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Paste as a picture

TIP: Paste Pivot Chart to your email as a picture
01:12

Insert a Pivot Chart in your Microsoft Excel Pivot Table - PowerPoint tips

TIP: Paste Pivot Chart to PowerPoint & make live updates
01:34

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Printing

TIP: Printing a Pivot Chart
01:27

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Include a Sparkline

TIP: Include a Sparkline with your pivot table
01:24

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Chart Do's & Don'ts

TIP: Charts Do´s & Don'ts
02:45

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Change Chart type with Slicers

TIP: Change Chart Type with Slicers! FUN!!!
08:08

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Interactive Scatter Chart

TIP: Workaround to creating an interactive Scatter graph
02:27

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Profit & Loss Pivot Table with Charts

CASE STUDY ~ ACCOUNTING: P&L Pivot Table report with Graphs
08:21

Insert a Pivot Chart in your Microsoft Excel Pivot Table - Slicer & Chart Excel Sales Dashboard

Preview 15:55
PIVOT CHARTS
3 questions