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

Product information

  • Title: Excel PivotTables, PowerPivot, Power View, and GeoFlow with MrExcel LiveLessons (Video Training)
  • Author(s):
  • Release date: March 2013
  • Publisher(s): Pearson
  • ISBN: 0133476723