Details

Goals

Analyze your data with Pivot Tables.

Prerequisite

Basic knowledge of Excel Functions.

Contents

Introduction

  • Organize your data in a list layout
  • Create a Pivot Table
  • Select data in a pivot table
  • Add data to a pivot table
  • Remove data from a pivot table
  • Update data in a pivot table
  • Recommended Pivot Tables (version 2013 and later)

Views

  • Hide/Show items in a pivot table
  • View details (drill down)
  • View the source data
  • Add/Remove subtotals

Groups

  • Grouping items in a pivot table
  • Automatically group numeric values
  • Automatically group date values
  • Ungroup

Calculations

  • Create calculated fields
  • Use calculated fields
  • Use a pivot table value in a formula

Options

  • General options of PivotTables
  • Change options

Pivot Charts

  • Create a PivotChart
  • Manipulate a PivotChart

Sign up

Next session(s)

Fri. 09 Sep.
13h30-17h00 online

Mon. 19 Sep.
13h30-17h00 online

Fri. 21 Oct.
13h30 17h00 online

Need a custom training?

None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!