Latest Quick Tip
  • Improve Your PivotTable Experience : Convert Your Excel Lists to Tables First!
Excel PivotTables
  • Welcome to Excel Pivot Tables: The Power of Pivot Tables... Made Easy
  • Steps for a Successful PivotTables Course
Creating PivotTables
  • Creating Your 1st PivotTable: Focus on the Data Source & PivotTable Environment
  • Creating PivotTable 2: Focus on Source, PivotTable Fields, and Arranging Fields
  • Exercise: Creating Two PivotTables
  • Creating a PivotTable from a Microsoft Access Database- NEW!
  • Changing Your PivotTable’s Data Source
  • Moving a PivotTable
  • Two Ways to Delete Your PivotTables
Filtering & Sorting PivotTables
  • Applying Filters to PivotTable Fields
  • Report Filters: Filtering the Entire PivotTable
  • Slicers: The User-Friendly Way to Filter Your PivotTable
  • Timelines: Dashboard Filters for Your Date Field
  • Creating a Custom Sort List
Grouping & Formatting Data in Your PivotTables
  • Grouping Records - Quick & Easy
  • Grouping by Date with Just a Few Clicks
  • How Are You Enjoying the Course?
  • Formatting All of the Field Values
  • Using Conditional Formatting to Highlight Important Information
  • Understanding Conditional Formatting Rule Precedence- NEW!
  • Applying Formatting Styles to PivotTables
  • Changing Your PivotTable's Layout
  • Displaying Multiple Field Values in Rows
Calculating Values in PivotTables
  • Summarize Data By…
  • Creating Custom Calculated Fields
  • Displaying Values as Percentages, Difference, and Rank
  • Creating Running Totals in PivotTables
  • Calculating Options for Value Fields Explained
  • Finding the Top or Bottom Values in Your PivotTable
Creating PivotCharts
  • Introduction to PivotCharts
  • Creating a Dashboard with PivotCharts, Slicers, and Timelines
PivotTable Tips & Tricks
  • The Super Easy Steps to Drilling Down on Your PivotTable
  • The Trick to Creating Multiple PivotTables from the Report Filters
  • Clearing Deleted Items from a PivotTable
  • What to do with Error in Your PivotTables?
  • Creating a Frequency Distribution Table
  • Automatic v. Manual Data Updating
  • Thank You!
  • Next Steps for Success
More PivotTable Exercises & Resources
  • Exercise: Products by Country
  • Exercise: Sales by Salesperson Quarter
  • Test Your Skills: Grouping by Month
  • Test Your Skills: Running Totals
  • Test Your Skills: Custom Sort Lists
  • Keyboard Shortcuts
  • eBook: 2013 PivotTables
SNEAK PEAK: Excel Tips: Spotlight on Excel Time Savers
  • Customizing the Ribbon
  • Named Ranges for Navigation
  • Track, Accept, and Reject Changes Made to Your Workbooks
  • Creating Forms Using the Form Command
  • Absolute Reference: Why You Absolutely Need to Know It
  • Creating Drop-Down Lists