Course Details

Previous Page


PivotTable Filters, Calculations, and PowerPivot


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
PivotTables are a handy tool for summarizing large amounts of data efficiently and making it more manageable. Sometimes, though, it's useful to be able to filter the data in a PivotTable, and Excel 2010 provides filtering functionality for this specific purpose. For those people who require a more visual representation of data, Excel 2010 provides a new feature called a Slicer, which is basically a graphical representation of a PivotTable filter. Excel also provides a number of ways in which you can apply calculations to the data in PivotTables in the form of summary functions and custom calculations. All of these useful features of Excel 2010 are introduced and described in this course.

Target Audience
End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
1.0

Lesson Objectives

PivotTable Filters, Calculations, and PowerPivot

  • use calculations in PivotTable reports
  • filter data in PivotTable reports
  • create and use slicers
  • identify the functions of elements of the PowerPivot interface
  • identify the features of PowerPivot for Excel add-in
  • change functions in PivotTable reports
  • create your own formula in a PivotTable report
  • enable multiple filters and apply a Report filter
  • use slicers to filter data in a PivotTable report
  • Course Number:
    mo_aexl_a08_dt_enus