O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training)

Video Description

Explore the most popular and some of the lesser known features of Excel – PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel as your guide!

  • Start-to-finish personal training on Excel 2013: just watch and learn!
  • Simple, quick video walkthroughs of the tasks you perform most often!
  • Great personalized training at a fraction of the cost...for everyone who doesn't have time to read a book!

These video lessons will ensure that you can harness the power of Excel faster and more easily than ever before! In 89 quick video lessons, Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel shows how to increase your productivity and optimize Excel's best tools and features. Expert Bill Jelen simplifies powerful features including Formatting, Calculations, Sort & Filter, DAX Calculated Fields, Troubleshooting, Animation and more! Truly harness the power built into Excel! Just watch: You’ll master high-powered skills at your own pace–and get specific answers and solutions immediately, whenever you need them! For anyone who wants to master Microsoft Excel 2013 fast–from novices to experienced power users.

About the Author:

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on "Call for Help with Leo Laporte" and has produced more than 1,200 episodes of his daily video podcast, "Learn Excel from MrExcel." He is the author of 30 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine. You will most frequently find Bill taking his show on the road, doing half-day Power Excel seminars wherever he can find a room full of accountants or Excellers. Before founding MrExcel.com, Jelen spent 12 years in the trenches working as a financial analyst for finance, marketing, accounting, and operations departments of a $500 million public company.

Table of Contents

  1. Introduction
    1. Introduction to Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons 00:01:14
  2. Lesson 1: Basics
    1. Learning objectives 00:00:23
    2. Use a Pivot Table to Summarize Detailed Data 00:06:54
    3. Your Manager Wants Your Report Changed 00:02:15
    4. Add or Remove Fields from an Existing Pivot Table 00:02:31
    5. Summarize Pivot Table Data by Three Fields 00:03:16
    6. Why Does the Pivot Table Field List Dialog Keep Disappearing? 00:04:20
    7. Move or Change Part of a Pivot Table 00:04:11
    8. Update Data Behind a Pivot Table 00:04:00
    9. Why Does This Look Different from Excel 2003? Return to the Classic Pivot Table Layout 00:02:57
  3. Lesson 2: Formatting
    1. Learning objectives 00:00:21
    2. Compare Four Ways to Show Two Values Fields in a Pivot Table 00:02:21
    3. Kill Compact View 00:04:00
    4. Eliminate Blanks in the Outline Format of a Pivot Table 00:04:16
    5. Suppress Grand Totals in a Pivot Table 00:01:58
    6. Replace Blanks in a Pivot Table with Zeros 00:02:45
    7. Specify a Number Format for a Pivot Table Field 00:03:33
    8. Format Pivot Tables with the Gallery 00:03:54
    9. Add a Format to Gallery 00:03:58
    10. Selecting Parts for Formatting 00:02:11
    11. Icon Set in a Pivot Table 00:03:03
  4. Lesson 3: Calculations
    1. Learning objectives 00:00:27
    2. Create a Report That Shows Count, Min, Max, Average, Etc 00:03:42
    3. Percent of Parent, Rank, Running Total In 00:07:32
    4. Calculated Fields in a Pivot Table 00:04:42
    5. Add a Calculated Item for Budget - Actuals 00:05:14
    6. Instead of Using Calculated Items Group Text Fields 00:04:56
    7. Present a Pivot Table in High-to-Low Order by Revenue 00:03:09
  5. Lesson 4: Sort & Filter
    1. Learning objectives 00:00:34
    2. Manually Re-sequence the Order of Data in a Pivot Table 00:03:28
    3. Limit a Pivot Report to Show Just the Top 12 Customers 00:06:46
    4. Filtering a Pivot Table 00:05:26
    5. Add Visual Filters to a Pivot Table with Slicers 00:04:52
    6. Timelines vs Multiple Slicers 00:03:32
  6. Lesson 5: Features
    1. Learning objectives 00:00:24
    2. See Detail Behind One Number in a Pivot Table 00:02:02
    3. Group Daily Dates by Month in a Pivot Table 00:03:18
    4. Create a Year-over-Year Analysis 00:03:44
    5. Stop GetPivotData from Appearing 00:02:12
    6. Group by Week in a Pivot Table 00:02:11
    7. Group Numbers to Create Frequency Chart 00:04:43
    8. Grouping one pivot table groups all pivot tables; new Cache 00:03:21
  7. Lesson 6: Uses
    1. Learning objectives 00:00:38
    2. Create a Unique List of Customers with a Pivot Table 00:01:59
    3. Use a Pivot Table to Compare Two Lists 00:03:37
    4. Fixing Customer Name problems Using a Pivot Table 00:04:14
    5. Show Text Fields for a Pareto Chart 00:03:51
  8. Lesson 7: Tips
    1. Learning objectives 00:00:33
    2. Base your pivot table on a Table When New Data Might Be Added 00:04:13
    3. Show Yes/No As the Values in a Pivot Table 00:03:46
    4. Create Perfectly Formatted Pivot Tables Using GETPIVOTDATA 00:08:50
    5. Create a Worksheet for Every Customer Using Show Report Filter Pages 00:06:03
    6. Controlling Multiple Pivot Tables with One Set of Slicers 00:04:58
    7. Reduce Pivot Table Workbook Size by 50% Before Sending 00:02:43
    8. Create a Pivot Table from Access Data 00:02:24
    9. Create a chart from a pivot table with Pivot Charts 00:04:26
  9. Lesson 8: Troubleshooting
    1. Learning objectives 00:00:32
    2. Compatibility between versions 00:03:13
    3. Force Missing Months to Show in a Pivot Table 00:02:49
    4. Whatever Happened to Multiple Consolidation Ranges in Pivot Tables? 00:04:27
    5. Cleaning up bad data before creating a pivot table 00:05:05
    6. Pivot Data Where the Source Data Has Dates Stretching Across the Columns 00:04:07
  10. Lesson 9: PowerPivot
    1. Learning objectives 00:00:54
    2. Using the Data Model in Excel 2013 to Join Two Tables 00:04:24
    3. Distinct Count in Excel 2013 00:02:05
    4. True Top Five in Excel 2013 00:01:37
    5. Using Named Sets for Asymmetric Reports 00:04:20
    6. Getting PowerPivot 00:05:32
    7. Load Data into PowerPivot 00:06:04
    8. Define Relationships in the PowerPivot Window or Diagram View 00:06:30
    9. Creating the Pivot Table - Compare Choices 00:05:57
    10. Changing the Calculation from Sum & Other Differences 00:04:58
  11. Lesson 10: DAX Calculated Fields
    1. Learning objectives 00:00:40
    2. DAX Measures 00:10:07
    3. Use DAX Measures to Calculate a Range 00:05:23
    4. Use DAX Measures to un-apply a Filter 00:14:01
    5. Using a Calendar Table for Time Intelligence 00:04:53
    6. Time Intelligence Functions 00:06:56
    7. Disconnected Parameter Tables with FILTER() 00:08:56
    8. Actuals vs Budget 00:09:28
    9. Using IF(VALUES in a Measure 00:12:33
    10. Build Slicers on Lookup Tables 00:02:09
    11. First Initial Slicer (and turning off cross-slicer filtering) 00:04:58
    12. Convert the Pivot Table to Cube Formulas 00:01:54
  12. Lesson 11: Power View
    1. Learning objectives 00:00:46
    2. Preparing your data for PowerView 00:03:54
    3. Adding a Power View Worksheet 00:06:05
    4. Adding a Dashboard Element as a Table 00:03:30
    5. Converting Table to a Chart 00:03:23
    6. Explicit and Implicit Slicers 00:03:44
    7. Understanding the Filter Pane 00:05:00
    8. Using Tile Boxes 00:03:18
    9. Replicating Charts Using Multiples 00:02:42
    10. Showing Data on a Map 00:05:29
    11. Showing Images in Table or Card View 00:02:27
    12. Formatting Power View 00:03:26
    13. Animating a Scatter Chart over Time 00:03:29
  13. Lesson 12: GeoFlow
    1. Learning objectives 00:00:42
    2. Adding data to GeoFlow 00:03:57
    3. Flying through the map 00:04:25
    4. Animating GeoFlow 00:04:25
    5. Building a tour in GeoFlow 00:05:30
  14. Summary
    1. Summary of Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons 00:00:43