Excel Pivot Tables
- 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.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
Choose between 52 start dates
Upcoming start dates
Suitability - Who should attend?
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.
You may also wish to consider our soft skills training workshops.
Training Course Content
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 and Restarting
· Moving Pivot Tables
Pivot Table Views
Conditional formattingSorting, Filtering and Re-ordering
· Slicers (2010 / 2013 only)
Saving Custom Views
Pivot Table Calculations
Calculated Fields and ItemsManaging and 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 dataUsing external data sources (Access)
Automating Pivot Tables with Macros
Introducing MacrosRecording Pivot Table macros
Tidying and refining recorded macros
The Power Pivot add-in (2010 / 2013 only)
Summary
Frequent Pivot Table Questions and AnswersSolutions to common problems
Expenses
List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.8
Based on 368 reviews.
Write a review!
Reviews are published according to our review policy.
Adam
5/5
07 May 2024
Kirsty
5/5
24 Apr 2024
Thank you Jens; I really enjoyed the course and feel what I have learnt will benefit me in my role.
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads
Excellent throughout - however speed seemed to increase and Power Query left me scratching my head a little; high complexity in limited time it felt