Spreadsheets

Excel 2016/2013 Working With PivotTables (Other Versions Upon Request)

This course explores tools in Excel used to effectively summarize data. Ease worksheet readability by sorting and filtering data, using slicers, summarize and group large worksheets using PivotTables.

Dates & Times

CourseDate & TimeLocationCost
Excel 2016/2013 Working With PivotTables (Other Versions Upon Request)January 31 - 1:00 - 4:30LathamRegister

Course Outline

Excel’s PivotTable feature is used to sort and summarize large amounts of data. The benefit of a PivotTable is the ability to view data in a variety of ways quickly and easily. This includes showing only summary information or filtered information as needed.

Includes:
Excel quick reference card
Follow-up support by email or phone for an unlimited period

Lesson 1: Creating Tables

  • Converting a range into a table
  • Creating table formulas using structured referencing
  • Adding new data to tables

Lesson 2: Working with PivotTables

  • Creating PivotTables
  • Understanding PivotTable benefits
  • Filtering data using Row and Column filters
  • Filtering data using Report filters
  • Filtering data using Slicers

Lesson 3: Creating PivotTable Presentations

  • Changing summary functions
  • Formatting PivotTable elements
  • Create Report Filter pages
  • Adding calculated fields
  • Grouping data using group selection
  • Creating PivotCharts