Books & Videos

Table of Contents

Chapter: Introduction

Introduction to Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons

01m 14s

Chapter: Lesson 1: Basics

Learning objectives

00m 23s

Use a Pivot Table to Summarize Detailed Data

06m 53s

Your Manager Wants Your Report Changed

02m 14s

Add or Remove Fields from an Existing Pivot Table

02m 31s

Summarize Pivot Table Data by Three Fields

03m 15s

Why Does the Pivot Table Field List Dialog Keep Disappearing?

04m 19s

Move or Change Part of a Pivot Table

04m 11s

Update Data Behind a Pivot Table

04m 0s

Why Does This Look Different from Excel 2003? Return to the Classic Pivot Table Layout

02m 57s

Chapter: Lesson 2: Formatting

Learning objectives

00m 21s

Compare Four Ways to Show Two Values Fields in a Pivot Table

02m 21s

Kill Compact View

03m 59s

Eliminate Blanks in the Outline Format of a Pivot Table

04m 16s

Suppress Grand Totals in a Pivot Table

01m 58s

Replace Blanks in a Pivot Table with Zeros

02m 45s

Specify a Number Format for a Pivot Table Field

03m 32s

Format Pivot Tables with the Gallery

03m 53s

Add a Format to Gallery

03m 58s

Selecting Parts for Formatting

02m 11s

Icon Set in a Pivot Table

03m 3s

Chapter: Lesson 3: Calculations

Learning objectives

00m 27s

Create a Report That Shows Count, Min, Max, Average, Etc

03m 42s

Percent of Parent, Rank, Running Total In

07m 32s

Calculated Fields in a Pivot Table

04m 41s

Add a Calculated Item for Budget - Actuals

05m 13s

Instead of Using Calculated Items Group Text Fields

04m 56s

Present a Pivot Table in High-to-Low Order by Revenue

03m 8s

Chapter: Lesson 4: Sort & Filter

Learning objectives

00m 34s

Manually Re-sequence the Order of Data in a Pivot Table

03m 27s

Limit a Pivot Report to Show Just the Top 12 Customers

06m 46s

Filtering a Pivot Table

05m 26s

Add Visual Filters to a Pivot Table with Slicers

04m 51s

Timelines vs Multiple Slicers

03m 32s

Chapter: Lesson 5: Features

Learning objectives

00m 24s

See Detail Behind One Number in a Pivot Table

02m 1s

Group Daily Dates by Month in a Pivot Table

03m 17s

Create a Year-over-Year Analysis

03m 43s

Stop GetPivotData from Appearing

02m 11s

Group by Week in a Pivot Table

02m 11s

Group Numbers to Create Frequency Chart

04m 42s

Grouping one pivot table groups all pivot tables; new Cache

03m 20s

Chapter: Lesson 6: Uses

Learning objectives

00m 38s

Create a Unique List of Customers with a Pivot Table

01m 58s

Use a Pivot Table to Compare Two Lists

03m 37s

Fixing Customer Name problems Using a Pivot Table

04m 13s

Show Text Fields for a Pareto Chart

03m 50s

Chapter: Lesson 7: Tips

Learning objectives

00m 33s

Base your pivot table on a Table When New Data Might Be Added

04m 13s

Show Yes/No As the Values in a Pivot Table

03m 45s

Create Perfectly Formatted Pivot Tables Using GETPIVOTDATA

08m 49s

Create a Worksheet for Every Customer Using Show Report Filter Pages

06m 3s

Controlling Multiple Pivot Tables with One Set of Slicers

04m 58s

Reduce Pivot Table Workbook Size by 50% Before Sending

02m 42s

Create a Pivot Table from Access Data

02m 23s

Create a chart from a pivot table with Pivot Charts

04m 26s

Chapter: Lesson 8: Troubleshooting

Learning objectives

00m 32s

Compatibility between versions

03m 12s

Force Missing Months to Show in a Pivot Table

02m 49s

Whatever Happened to Multiple Consolidation Ranges in Pivot Tables?

04m 26s

Cleaning up bad data before creating a pivot table

05m 5s

Pivot Data Where the Source Data Has Dates Stretching Across the Columns

04m 7s

Chapter: Lesson 9: PowerPivot

Learning objectives

00m 54s

Using the Data Model in Excel 2013 to Join Two Tables

04m 23s

Distinct Count in Excel 2013

02m 5s

True Top Five in Excel 2013

01m 36s

Using Named Sets for Asymmetric Reports

04m 19s

Getting PowerPivot

05m 31s

Load Data into PowerPivot

06m 3s

Define Relationships in the PowerPivot Window or Diagram View

06m 30s

Creating the Pivot Table - Compare Choices

05m 57s

Changing the Calculation from Sum & Other Differences

04m 57s

Chapter: Lesson 10: DAX Calculated Fields

Learning objectives

00m 40s

DAX Measures

10m 7s

Use DAX Measures to Calculate a Range

05m 23s

Use DAX Measures to un-apply a Filter

14m 0s

Using a Calendar Table for Time Intelligence

04m 52s

Time Intelligence Functions

06m 56s

Disconnected Parameter Tables with FILTER()

08m 56s

Actuals vs Budget

09m 28s

Using IF(VALUES in a Measure

12m 33s

Build Slicers on Lookup Tables

02m 9s

First Initial Slicer (and turning off cross-slicer filtering)

04m 58s

Convert the Pivot Table to Cube Formulas

01m 53s

Chapter: Lesson 11: Power View

Learning objectives

00m 46s

Preparing your data for PowerView

03m 54s

Adding a Power View Worksheet

06m 4s

Adding a Dashboard Element as a Table

03m 30s

Converting Table to a Chart

03m 22s

Explicit and Implicit Slicers

03m 43s

Understanding the Filter Pane

04m 59s

Using Tile Boxes

03m 18s

Replicating Charts Using Multiples

02m 41s

Showing Data on a Map

05m 29s

Showing Images in Table or Card View

02m 26s

Formatting Power View

03m 26s

Animating a Scatter Chart over Time

03m 28s

Chapter: Lesson 12: GeoFlow

Learning objectives

00m 42s

Adding data to GeoFlow

03m 57s

Flying through the map

04m 25s

Animating GeoFlow

04m 24s

Building a tour in GeoFlow

05m 29s

Chapter: Summary

Summary of Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons

00m 43s