MS Excel – Creating Pivot Tables – An Introduction

Start Dates: TBC

https://www.ifsskillnet.ie Book Now

Programme overview

A pivot table is a reporting tool that produces 3D reports from spread sheet data. This session will explain the core concepts of a Pivot table, how to create and manage a table.

Please contact info@ifsskillnet.ie for more information on course fees for this course.

Learning outcomes
This session will explain the core concepts of a Pivot table, how to create and manage a table.

Who is the course for?
Participants who want to learn how to create and manage Pivot tables.

Modules

• Steps in creating a Pivot Table

• Select the required fields for the Pivot Table

• Filter the pivot table

• Format the value fields in the pivot table

• Update and refresh a pivot table

• Drill Down to view the background data

• Add a value field and change the calculation method

• Show multiple totals across columns

• Group fields for data analysis

• Create a Pivot Chart

Trainer Profile