Excel PivotTable

STL
4.0
2 reviews
  • The mentor (Jens) was excellent and his energy infectious. In any case, I felt there was a lot of material to be canvassed in one day and maybe it ought to have been a 2 day course.
    ← | →
  • In the event that you have constrained or no involvement with Pivot tables, then this will appear like a session for cutting edge individuals since it is an entire day and there is a ton of data to take in. Having said that, the coach was tolerant, useful and cheerful to clarify things more than once. I have already and would keep on using Best STL. They appear to constantly offer mentors who are specialists in their field. I would exceedingly prescribe them and have done as such to different partners.
    ← | →

Course

In London

£ 201-500

The best Excel courses

See all

See all

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

Our Microsoft Excel Pivot Tables course is suitable for those with a basic working knowledge of Pivot Tables who want a greater understanding of the more sophisticated functions and features available.

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables.


You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts.

Prior use of Pivot Tables or our Excel Advanced course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.0
  • The mentor (Jens) was excellent and his energy infectious. In any case, I felt there was a lot of material to be canvassed in one day and maybe it ought to have been a 2 day course.
    ← | →
  • In the event that you have constrained or no involvement with Pivot tables, then this will appear like a session for cutting edge individuals since it is an entire day and there is a ton of data to take in. Having said that, the coach was tolerant, useful and cheerful to clarify things more than once. I have already and would keep on using Best STL. They appear to constantly offer mentors who are specialists in their field. I would exceedingly prescribe them and have done as such to different partners.
    ← | →
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Heather

5.0
11/04/2015
What I would highlight: The mentor (Jens) was excellent and his energy infectious. In any case, I felt there was a lot of material to be canvassed in one day and maybe it ought to have been a 2 day course.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Shalini

3.0
10/04/2015
What I would highlight: In the event that you have constrained or no involvement with Pivot tables, then this will appear like a session for cutting edge individuals since it is an entire day and there is a ton of data to take in. Having said that, the coach was tolerant, useful and cheerful to clarify things more than once. I have already and would keep on using Best STL. They appear to constantly offer mentors who are specialists in their field. I would exceedingly prescribe them and have done as such to different partners.
What could be improved: No negative aspects.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • MS Excel
  • Excel
  • Pivot Table Fundamentals
  • Basic Pivot Tables
  • Tabular Layout
  • Eliminating Gaps
  • Type Formatting
  • Pivot Table Views
  • Slicers
  • Pivot charts
  • Pivot Chart Rules
  • Data sources

Course programme

Pivot Table Fundamentals

What is a Pivot Table?
When and why use a Pivot Table?
Anatomy of a Pivot Table
Limitations of Pivot Tables

Creating Basic Pivot Tables

Preparing your data
· Tabular Layout
· Removing Section Headings
· Removing Repeated Column Groups
· Eliminating Gaps
· Type Formatting
Creating Pivot Tables
· Adding Fields
· Adding Layers
· Altering Structure
· Report Filters
Managing Changes in Your Source Data
· Dynamic Named Ranges
· Dealing with Zeroes
Subtotals
Summary Calculations
· Running totals
· Differences (year on year, month on month)
· Percentages of Rows, Columns, Totals and other fields
Running Totals and Top 10 reports
Pivot Table Tools
· Layout Updates
· Refreshing & Restarting
· Moving Pivot Tables

Pivot Table Views

Conditional formatting
Sorting, Filtering and Re-ordering
· Slicers (2010 / 2013 only)
Saving Custom Views

Pivot Table Calculations

Calculated Fields and Items
Managing & maintaining Pivot Table calculations

Pivot Charts

What is a Pivot Chart?
Creating a Pivot Chart
Pivot Chart Rules
· Managing the underlying data
· Adding Layers
· Altering Structure
Pivot Chart Alternatives
· Dynamic Charts
· Transition tables

Working with Data Sources

Consolidating multiple sheets or ranges of data
Using external data sources (Access)

Automating Pivot Tables with Macros

Introducing Macros
Recording Pivot Table macros
Tidying and refining recorded macros
The Power Pivot add-in (2010 / 2013 only)

Summary

Frequent Pivot Table Questions and Answers
Solutions to common problems



Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

See related categories

Excel PivotTable

£ 201-500

The best Excel courses

See all

See all