Excel 2013: PivotTables & PivotCharts


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Analyze data efficiently using Excel 2013. Discover how to work with PivotTables, including formatting, sorting, filtering, grouping, and using slicers. In addition, explore how to insert, modify, and analyze using PivotCharts.



Expected Duration (hours)
1.3

Lesson Objectives

Excel 2013: PivotTables & PivotCharts

  • Creating a PivotTable
  • Creating a PivotTable with multiple data tables
  • Editing your PivotTable
  • Formatting your PivotTable
  • Copying & reusing your PivotTable
  • Inserting a calculation in your PivotTable
  • Sorting & filtering data in your PivotTable
  • Grouping data in your PivotTable
  • Inserting a slicer in your PivotTable
  • Customizing your slicer
  • Comparing values in a PivotTable
  • Inserting a PivotChart
  • Modifying your PivotChart
  • Analyzing your database tables in a PivotChart
  • Course Number:
    ds_msex2013_13_enus

    Expertise Level
    Intermediate