Book Now

Excel - PivotTables & PivotCharts

Category: Microsoft Office, Microsoft Excel

Module 1

Introduction to Tables and Pivot Tables

Tables

Convert range to table

Table formatting

Table header and total rows with Dynamic SUBTOTAL function

Formulas in Tables using structured references

Analysing data with the Slicer

Pivot Tables Introduction

How to construct a Pivot Table report

Create Pivot Tables from ranges vs Tables

Work with Fields

Adding, Moving, Deleting PivotTable Report Fields

Updating and refreshing Pivot Table data

Expanding Data

Sort and Filters Introduction to Slicer

Module 2

Advanced Pivot Tables, Charts and Slicers for Dashboards

Setting up Multiple Pivot Tables

Working with multiple Pivot Tables

Slicers to control multiple Pivot Tables

Calculations

Calculations in Pivot Tables – Calculating fields and Calculating Items

Functions to summarise and analyse data

Timelines

Creating Pivot table charts and graphs

Pivot Charts to create dashboards controlled with single slicer and timeline commands

GETPIVOTDATA function


Who is this course for?

This course is perfect for existing users of Excel who are looking to transform and enhance the way they work on a day to day basis. You should be already be familiar with everyday Formulas, Sheets and Formatting.

Course Objectives

By harnessing the Power of Tables, Pivot Tables and Pivot Charts you will be able to analyse and report on data quickly and accurately whilst displaying data in a dynamic way.

Covering all aspects of Pivot Tables from our Level 2 Excel and Level 3 Excel training course you will take your data analysis skills from zero to pro.

Course Duration

Course Duration: 3 Hours - Half Day Classroom Training or Online

Course Contents

The subjects listed on the left are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course.

Notes

This online course is delivered with a trainer in real time. Prior to each session, delegates will receive the files and instructions needed to successfully follow and practice the skills and techniques. The LiveLearning classroom will provide delegates with:

The opportunity to ask questions.

Facility to share their screens and to send instant messages/chat. 

Practice time.

Step by step PDF to follow

Follow up exercises will also be provided for consolidation of learning


Course Dates 

View our full course schedule here.

Training Locations

Our open classroom courses are held in Merseyside where we have state of the art training facilities. We also provide in-house training solutions at any office location in the UK or Europe. We frequently deliver training in Liverpool, Wirral, Blackpool, Manchester, London, Chester, Warrington, Leeds, Cardiff, Birmingham, Edinburgh, Bristol, Sheffield, Glasgow, Leatherhead, Aberdeen and Ireland.

Closed courses can also be delivered in European countries such as Austria, Belgium, Denmark, Greece, France, Finland, Hungary, Italy, Ireland, Netherlands, Norway, Portugal, Spain, Poland, Sweden, Switzerland and off shore.... Either in English or local languages.

Software Versions

We offer training solutions for all versions of Excel - 2003, 2007, 2010, 2013 and 2016.

Enquiry Form

* indicates required

Booking

Looking for in-house training that can be customised to you/your businesses exact needs? Contact us below for one of our team to contact you.

Upcoming Courses

Below are a list of upcoming dates and locations where this course is scheduled to take place.

Location Start Date Duration Cost

For more information about any of our courses please call +44 (0)151 650 6907,
email enquiries@squareonetraining.com or complete an enquiry form.

Back to top