Xtreme Pivot Tables

Excel TV Academy
Xtreme Pivot Tables

ONLY FOR MEMBERS

Easy

Video/Text

Data Wrangling

231 Lessons

0% Not started

Go from 0 to Pivot Tables. If you’ve ever wanted to become awesome a Pivot Tables, this course is for you.

Ready?

Xtreme Pivot Tables

Get The Course Files

1 Lesson

ONLY FOR MEMBERS

Download the Course Files

Design & Customize Your Pivot Tables

46 Lessons

ONLY FOR MEMBERS

Tabular Format

ONLY FOR MEMBERS

No Gaps

ONLY FOR MEMBERS

Formatting

ONLY FOR MEMBERS

Tables

ONLY FOR MEMBERS

Clean Your Data Set

ONLY FOR MEMBERS

Inserting a Pivot Table

ONLY FOR MEMBERS

Field List

ONLY FOR MEMBERS

Field List Areas

ONLY FOR MEMBERS

Drill Down to Audit

ONLY FOR MEMBERS

Sort Field List from A to Z

ONLY FOR MEMBERS

Double Click on any Label to Show More Fields

ONLY FOR MEMBERS

Defer Layout Update

ONLY FOR MEMBERS

Pivot Cache

ONLY FOR MEMBERS

Refresh

ONLY FOR MEMBERS

Refresh All

ONLY FOR MEMBERS

Refresh External Data

ONLY FOR MEMBERS

Import from Access Database

ONLY FOR MEMBERS

Change Data Source

ONLY FOR MEMBERS

Clear Filter and Clear Pivot

ONLY FOR MEMBERS

Select and Format

ONLY FOR MEMBERS

Move a Pivot Table

ONLY FOR MEMBERS

Pivot Table Styles

ONLY FOR MEMBERS

Customize Styles

ONLY FOR MEMBERS

Use a Customized Style in Another Workbook

ONLY FOR MEMBERS

Subtotals

ONLY FOR MEMBERS

Grand Totals

ONLY FOR MEMBERS

Report Layout

ONLY FOR MEMBERS

Blank Rows

ONLY FOR MEMBERS

TIPS - Show the Classic Pivot Table Layout

ONLY FOR MEMBERS

Expand and Collapse Buttons

ONLY FOR MEMBERS

Move and Remove Fields and Items

ONLY FOR MEMBERS

Show or Hide Field List

ONLY FOR MEMBERS

Show or Hide Field Field Headers

ONLY FOR MEMBERS

Change Count Of to Sum Of

ONLY FOR MEMBERS

Number Formatting

ONLY FOR MEMBERS

Field Name Formatting

ONLY FOR MEMBERS

Predetermined Number Formatting

ONLY FOR MEMBERS

TIPS - Change SUM Views in Label Areas

ONLY FOR MEMBERS

Indent Rows in Compact Layouts

ONLY FOR MEMBERS

Change Layout of a Report Filter

ONLY FOR MEMBERS

Format Error Values

ONLY FOR MEMBERS

Format Empty Cells

ONLY FOR MEMBERS

Keep Column Widths Upon Refresh

ONLY FOR MEMBERS

Automatically Refresh a Pivot Table

ONLY FOR MEMBERS

TIPS - Printing a Pivot Table on Two Pages

ONLY FOR MEMBERS

TIPS - Show Report Filters on Multiple Pages

Value Field Settings > Summarize Values By

13 Lessons

ONLY FOR MEMBERS

Create Multiple Subtotals

ONLY FOR MEMBERS

Count

ONLY FOR MEMBERS

Average

ONLY FOR MEMBERS

Maximum

ONLY FOR MEMBERS

MINimum

ONLY FOR MEMBERS

Product

ONLY FOR MEMBERS

Count Numbers

ONLY FOR MEMBERS

StdDevp

ONLY FOR MEMBERS

VarP

ONLY FOR MEMBERS

Show Various Grand Totals

ONLY FOR MEMBERS

Shortcuts to Value Field Settings

ONLY FOR MEMBERS

See All Pivot Items

ONLY FOR MEMBERS

Show a Unique Count

Value Field Settings > Show Values As

17 Lessons

ONLY FOR MEMBERS

Percentage of Grand Total

ONLY FOR MEMBERS

Percentage of Column Total

ONLY FOR MEMBERS

Percentage of Row Total

ONLY FOR MEMBERS

Percentage Of

ONLY FOR MEMBERS

Percentage of Parent Row Total

ONLY FOR MEMBERS

Percentage of Parent Column Total

ONLY FOR MEMBERS

Percentage of Parent Total

ONLY FOR MEMBERS

Difference From

ONLY FOR MEMBERS

Percentage Difference From

ONLY FOR MEMBERS

Running Total In

ONLY FOR MEMBERS

Percentage Running Total In

ONLY FOR MEMBERS

Rank Smallest to Largest

ONLY FOR MEMBERS

Rank Largest to Smallest

ONLY FOR MEMBERS

Index

ONLY FOR MEMBERS

Shortcuts to Show Values As

ONLY FOR MEMBERS

Percentage of Revenue

ONLY FOR MEMBERS

Actual v Plan Variation

Grouping

17 Lessons

ONLY FOR MEMBERS

Group by Date

ONLY FOR MEMBERS

Grouping by Months

ONLY FOR MEMBERS

Grouping by Quarters and Years

ONLY FOR MEMBERS

Group by Sales Ranges

ONLY FOR MEMBERS

Group by Text Fields

ONLY FOR MEMBERS

Group by Time

ONLY FOR MEMBERS

Shortcuts to Grouping

ONLY FOR MEMBERS

Grouping by Half Years

ONLY FOR MEMBERS

Grouping by a Date that starts on a Monday

ONLY FOR MEMBERS

Grouping by a Custom Date

ONLY FOR MEMBERS

Grouping by a Fiscal Year and Quarter

ONLY FOR MEMBERS

Errors when Grouping by Dates

ONLY FOR MEMBERS

Group Two Pivot Tables in the Same Workbook

ONLY FOR MEMBERS

Fixing the Problem of Counting Grouped Sales

ONLY FOR MEMBERS

Display Dates that Have No Data

ONLY FOR MEMBERS

Quarterly Comparative Report

ONLY FOR MEMBERS

FINANCIAL Min and Max Bank Balance

Sort

9 Lessons

ONLY FOR MEMBERS

Sorting by Largest or Smallest

ONLY FOR MEMBERS

Sort an Item Row

ONLY FOR MEMBERS

Sort Manually

ONLY FOR MEMBERS

Sort using a Custom List

ONLY FOR MEMBERS

Override a Custom List Sort

ONLY FOR MEMBERS

Sort rows from A to Z and values by Z to A

ONLY FOR MEMBERS

Sort New Items Added to Your Data Source

ONLY FOR MEMBERS

TIPS Clear a Sort

ONLY FOR MEMBERS

TIPS Sort Largest to Smallest Grand Totals

Filter

19 Lessons

ONLY FOR MEMBERS

Filter by Dates

ONLY FOR MEMBERS

Filter by Labels - Text

ONLY FOR MEMBERS

Filter by Labels - Numerical Text

ONLY FOR MEMBERS

Filter by Values

ONLY FOR MEMBERS

Filter by Values - Top or Bottom 10 Items

ONLY FOR MEMBERS

Filter by Values - Top or Bottom Percent

ONLY FOR MEMBERS

Filter by Values - Top or Bottom Sum

ONLY FOR MEMBERS

Filter by Report Filter

ONLY FOR MEMBERS

Shortcuts to Filter

ONLY FOR MEMBERS

Keep or Hide Selected Items

ONLY FOR MEMBERS

Filter by Text Wildcards

ONLY FOR MEMBERS

TIPS Filter by Multiple Fields

ONLY FOR MEMBERS

Apply Multiple Filters

ONLY FOR MEMBERS

TIPS Filter by Multiple Values

ONLY FOR MEMBERS

Include New Items in Manual Filter

ONLY FOR MEMBERS

Clear Filters with One Click

ONLY FOR MEMBERS

TIPS Add a Filter for the Column Items

ONLY FOR MEMBERS

Top 5 Expense Report

ONLY FOR MEMBERS

Top 25 percent of Channel Partners

Slicers (New in Excel 2010)

13 Lessons

ONLY FOR MEMBERS

Insert a Slicer

ONLY FOR MEMBERS

Slicer Styles

ONLY FOR MEMBERS

Creating a Custom Style

ONLY FOR MEMBERS

Copying a Custom Style in to a New Workbook

ONLY FOR MEMBERS

Slicer Settings

ONLY FOR MEMBERS

Slicer Size and Properties

ONLY FOR MEMBERS

Slicer Connections for Multiple Pivot Tables

ONLY FOR MEMBERS

Different ways to Filter a Slicer

ONLY FOR MEMBERS

Use One Slicer for Two Pivot Tables

ONLY FOR MEMBERS

Lock the Workbook but not the Slicer

ONLY FOR MEMBERS

Interactive Employee Photos with Slicers

ONLY FOR MEMBERS

Select a Monthly PnL Report with a Slicer

ONLY FOR MEMBERS

Base, Best and Worst Case Forecast

Calculated Fields & Items

16 Lessons

ONLY FOR MEMBERS

Creating a Calculated Field

ONLY FOR MEMBERS

Use an Existing Calculated Field

ONLY FOR MEMBERS

Editing a Calculated Field

ONLY FOR MEMBERS

Excel formulas and Calculated Fields

ONLY FOR MEMBERS

Creating a Calculated Item

ONLY FOR MEMBERS

Use an Existing Calculated Item

ONLY FOR MEMBERS

Editing a Calculated Item

ONLY FOR MEMBERS

Excel Formulas and Calculated Items

ONLY FOR MEMBERS

Calculated Item on Column Labels

ONLY FOR MEMBERS

Shortcomings of Calculated Items

ONLY FOR MEMBERS

Solve Order for Calculated Items

ONLY FOR MEMBERS

List Formulas

ONLY FOR MEMBERS

Remove a Calculated Field temporarily

ONLY FOR MEMBERS

Order of Operations

ONLY FOR MEMBERS

Creating a PnL Pivot Table Report

ONLY FOR MEMBERS

Actual v Plan with Calculated Fields

Pivot Charts

21 Lessons

ONLY FOR MEMBERS

Insert a Pivot Chart

ONLY FOR MEMBERS

Insert a Slicer with a Pivot Chart

ONLY FOR MEMBERS

Pivot Chart Designs

ONLY FOR MEMBERS

Pivot Chart Layouts

ONLY FOR MEMBERS

Pivot Chart Formats

ONLY FOR MEMBERS

Limitations of Pivot Charts and Workarounds

ONLY FOR MEMBERS

Saving a Pivot Chart Template

ONLY FOR MEMBERS

Shortcuts to formatting a Pivot Chart

ONLY FOR MEMBERS

TIPS Link Chart Title To a Pivot Cell

ONLY FOR MEMBERS

Copying a Second Chart

ONLY FOR MEMBERS

Put a Chart on a Separate Page with F11

ONLY FOR MEMBERS

Insert Pivot Chart Straight from the Data Source

ONLY FOR MEMBERS

Paste Pivot Chart to your Email as a Picture

ONLY FOR MEMBERS

TIPS Paste Pivot Chart to Powerpoint

ONLY FOR MEMBERS

TIPS Printing a Pivot Chart

ONLY FOR MEMBERS

Include a Sparkline with Your Pivot Table

ONLY FOR MEMBERS

Chart Do's and Dont's

ONLY FOR MEMBERS

FUN Use Slicers to Change Chart Types

ONLY FOR MEMBERS

Workaround to creating a Scatter Graph

ONLY FOR MEMBERS

PnL Pivot table report with Graphs

ONLY FOR MEMBERS

Pivot Table Slicer and Chart Dashboard

Conditional Formatting of Pivot Tables

17 Lessons

ONLY FOR MEMBERS

Intro to Conditional Formatting

ONLY FOR MEMBERS

Highlight Cell Rules based on Values

ONLY FOR MEMBERS

Highlight Cell Rules based on Text Labels

ONLY FOR MEMBERS

Highlight Cell Rules based on Date Labels

ONLY FOR MEMBERS

Top and Bottom Rules

ONLY FOR MEMBERS

Data Bars, Color Scales and Icon Sets

ONLY FOR MEMBERS

Format cells that contain - For Bonuses

ONLY FOR MEMBERS

Format Top Ranked Values

ONLY FOR MEMBERS

Format Values Above the Average

ONLY FOR MEMBERS

Use a Formula to Determine Which Cells to Format

ONLY FOR MEMBERS

TIPS Use Selected Cells to Format Multiple Fields

ONLY FOR MEMBERS

All Cells Showing Values

ONLY FOR MEMBERS

Control Conditional Formatting with Slicers

ONLY FOR MEMBERS

TIP Show text in the Pivot Table Values Area

ONLY FOR MEMBERS

Conditionally Formatting Blank Cells

ONLY FOR MEMBERS

Accounts Receivable Ageing Report Matrix

ONLY FOR MEMBERS

Conditionally Format your sales results

GETPIVOTDATA Formula

8 Lessons

ONLY FOR MEMBERS

Intro to GET PIVOT DATA

ONLY FOR MEMBERS

Create a custom report with GET PIVOT DATA

ONLY FOR MEMBERS

Reference Dates with GET PIVOT DATA

ONLY FOR MEMBERS

Data validation with GET PIVOT DATA

ONLY FOR MEMBERS

Shortfalls of GET PIVOT DATA

ONLY FOR MEMBERS

Grand Totals to the left of the pivot table

ONLY FOR MEMBERS

Live forecasting with GET PIVOT DATA

ONLY FOR MEMBERS

Channel analysis with GET PIVOT DATA

Macros

6 Lessons

ONLY FOR MEMBERS

Adding the Developer tab

ONLY FOR MEMBERS

Record a simple macro to Refresh a Pivot Table

ONLY FOR MEMBERS

Date filter macro

ONLY FOR MEMBERS

Different Pivot Table Views Macro

ONLY FOR MEMBERS

Top 10 macro

ONLY FOR MEMBERS

Add macro to quick access toolbar

Data Management

6 Lessons

ONLY FOR MEMBERS

Reducing File Memory by Copying Existing Pivot Table

ONLY FOR MEMBERS

Reducing File Memory by Deleting the Data Source

ONLY FOR MEMBERS

Reducing file memory by saving file as XLSB

ONLY FOR MEMBERS

Reducing file memory by keeping data in Access

ONLY FOR MEMBERS

Compatibility Issues with Excel 2007 and Excel 2010

ONLY FOR MEMBERS

Sharing a Pivot Table via OneDrive

Bonus Videos

8 Lessons

ONLY FOR MEMBERS

Sales Forecasting with Calculated Fields

ONLY FOR MEMBERS

Consolidate with a Pivot Table

ONLY FOR MEMBERS

Frequency Distribution with a Pivot Table

ONLY FOR MEMBERS

Break Even Model with a Pivot Table

ONLY FOR MEMBERS

Several slicer custom styles for you to use

ONLY FOR MEMBERS

Interactive Balance Sheet Pivot Table

ONLY FOR MEMBERS

Monthly Sales Manager Performance

ONLY FOR MEMBERS

Reconciling customer payments

New Excel 2013 Pivot Table Features

5 Lessons

ONLY FOR MEMBERS

Cosmetic Changes

ONLY FOR MEMBERS

Recommended Pivot Tables

ONLY FOR MEMBERS

Distinct Count

ONLY FOR MEMBERS

Timeline Slicer

ONLY FOR MEMBERS

Data Model

New Excel 2013 Pivot Table Features

4 Lessons

ONLY FOR MEMBERS

Group Periods

ONLY FOR MEMBERS

Multiselect Slicers

ONLY FOR MEMBERS

Pivot Chart Expand and Collapse

ONLY FOR MEMBERS

3D Maps

New Excel 2019 & Office 365 Pivot Table Features

5 Lessons

ONLY FOR MEMBERS

Which Excel Version

ONLY FOR MEMBERS

Personalize the default Pivot Table layout

ONLY FOR MEMBERS

Automatic relationship detection

ONLY FOR MEMBERS

Automatic time grouping

ONLY FOR MEMBERS

Search in the Pivot Table

Follow

About the teacher

John Michaloudis

John is an Excel MVP and is the owner at MyExcelOnlone.com. John is the author of several Excel books including '101 Ready To Use Microsoft Excel Macros' and 'The 101 Most Popular Excel Formulas'