Realdolmen Education

Details

Excel PivotTables

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

0.5 day(s)

MS Excel: Using Pivot tables to analyze data

Duration

0,5 day

Audience

This course is aimed at users who already have a thorough knowledge of MS Excel and who want to increase their knowledge of pivot tables.

Prerequisites

A good knowledge of the basic principles of MS Excel is required.

Objectives

Learn to work with pivot tables

Methods

An interactive hands-on classroom-based training.

Description

The Pivot Table is one of the most powerful and most dynamic tools of MS Excel. It can be used to analyze figures and numbers fast and efficiently.

This module covers the creation of pivot tables based on data stored in Excel or in external sources. We’ll also see the new way of creating dynamic tables.

Afterwards, we’ll go over the different ways of editing pivot tables in function of the desired outcome: adding or removing elements, showing or hiding elements, editing the properties of a field.

We’ll see how to group data and show or hide details. We’ll learn how to perform operations based on extra fields and/or elements and go over the sort and filter options.

Pivot tables can interact with charts and conditional formatting. This will also be covered. We’ll end with some useful options that can be used for pivot tables.

Contents

  • Conditions for a data source
  • Convert a list into a dynamic table
  • Create a pivot table
    • Based on Excel data
    • Based on external data
  • Add and remove fields
  • Edit fields properties
  • Sort a pivot table
  • Use filters, slicers and timelines in a pivot table
  • refresh data of the database
  • Show or hide elements
  • Group elements
  • Show or hide details
  • Calculate fields
  • Calculate elements
  • Create a pivot chart
  • The layout of a pivot table
  • Use conditional formatting in pivot tables
  • Pivot tables options