FREE EXCEL PIVOT TABLE RESOURCES
  • Downloadable Excel Workbooks
  • BONUS INFOGRAPHIC: 5 Speedy Steps To Creating a Pivot Table
  • BONUS CHEAT SHEET: Excel Pivot Tables
  • BONUS EXCEL RESOURCES!
EXCEL PIVOT TABLES
  • Introduction
  • Why Most People Don´t Know How To Use Excel Pivot Tables?
  • Tabular Format & Excel Tables
  • Creating an Excel Pivot Table
  • Formatting an Excel Pivot Table
  • Summarize Values By
  • Show Values As
  • Grouping
  • Slicers
  • Excel Pivot Charts
  • Creating an Interactive Excel Dashboard with Slicers & Pivot Charts
  • BONUS: Pivot Table Tips & Tricks!
  • Course Review
BONUS VIDEOS
  • DOWNLOADABLE EXCEL WORKBOOKS
  • Show the Classic Pivot Table Layout
  • Show various Grand Totals
  • Actual v Plan Variance Report
  • Group two pivot tables independently
  • Sort manually
  • Filter by Text wildcards * and ?
  • Different ways to filter a Slicer
  • Excel formulas & Calculated Fields
  • Data Bars, Color Scales & Icon Sets
  • Create a custom report with GETPIVOTDATA
  • Different pivot table views macro
EXCEL BUSINESS CASE STUDIES
  • CASE STUDY #1: Sales Actuals v Plan with Calculated Fields
  • CASE STUDY #2: Slicer & Pivot Chart Excel DASHBOARD
  • CASE STUDY #3: Interactive Balance Sheet Excel Pivot Table
QUIZZES & PRACTICE ACTIVITIES!
  • Recognize which button is used to update a Pivot Table
  • Recall the way to change a "Count Of" to a "Sum Of"
  • Identify the steps to showing the values as a Year to Date
  • State which command is used to group a PivotTable report by weeks
  • Recall the way to connect a Slicers to Pivot Tables
  • HOMEWORK: CREATE A PIVOT TABLE
  • HOMEWORK: SUMMARIZE VALUES BY
  • HOMEWORK: SHOW VALUES AS
  • HOMEWORK: GROUPING
  • HOMEWORK: SLICERS
  • Create a Pivot Table Dashboard
BONUS: THE MYEXCELONLINE ACADEMY!
  • Thank You & Course Review!
  • Get our other 5 TOP RATED Udemy courses at a HUGE DISCOUNT!
  • Microsoft Excel E-Books