3-day Virtual Seminar

Microsoft Excel - PivotTables

Overview

Did you know you can easily summarize and analyze large datasets without writing formulas? Summing, averaging, counting, grouping, filtering, and sorting can all be done by simply learning the magic of PivotTables. By the end of this webinar, you will be able to create a simple interactive reports and charts.  This course is ideal for Excel users who work with lists, budgets, sales, attendance and a whole lot more.

Areas Covered in the Session

• The Basics
  
  • What is a PivotTable?
    
  • How do you create a PivotTable?
    
  • How do you "Pivot" within a PivotTable
    
  • How do you change a PivotTable's value calculation?
    
  • How do you convert the PivotTable into a PivotChart?
    
  • How do you refresh a PivotTable?
    
• Sorting
  
  • How do you sort the rows of my PivotTable?
    
  • How do you sort the columns of my PivotTable?
    
  • How do you manually rearrange columns in a PivotTable?
    
• Filtering
  
  • How do filter data with a report filter?
    
  • How do you filter via a row or column label?
    
  • How do generate Report Filter Pages?
    
  • How do you filter with a slicer?
    
  • How do you format slicers?
    
• Totals
  
  • How do you add / remove Grand Totals to / from your PivotTable?
    
  • How do you add / remove Subtotals?
    
  • How do you move the subtotals to the top or bottom of the group?

Who Will Benefit

• Office Workers
  
• Clerical Staff
  
• Small Business Owners  
  
• Teachers 
  
• Administrative Professionals 
  
• Data Analysts 
  
• Managers of All Levels