Mastering Excel Pivot Tables
COURSE
Topic Area
Course Length
6 hoursCourse Level
Course Preview
Audience
Course Objectives
By the end of this one-day course, participants will have mastered the art of Excel Pivot Tables, empowering them to efficiently analyse, summarise, and present data for more informed decision-making.
Course Content
- Introduction to Pivot Tables
- Understanding the purpose and benefits of Pivot Tables
- Navigating the Pivot Table interface in Excel
- Data Preparation for Pivot Tables
- Importing and organising data for Pivot Table analysis
- Cleaning and transforming data for optimal use
- Creating Pivot Tables
- Building Pivot Tables from scratch
- Using recommended Pivot Tables and layouts
- Configuring Pivot Table Fields
- Understanding rows, columns, values, and filters
- Organising and customising fields for desired analysis
- Data Analysis with Pivot Tables
- Utilising Pivot Tables for summarising and aggregating data
Course Outline
Learning Outcomes
Enquire About This Course
Tell us a little about your requirements and we’ll tailor the right solution for you.
Speak to a Training Advisor
Speak directly with a training advisor for quick guidance and recommendations.
Trusted by organisations across the UK and Beyond
Capital Training is an LPI Gold Standard Accredited Learning Provider, recognised for delivering high-quality, impactful training. With over 30 years’ experience, we support organisations across the UK and beyond with trusted, professional development solutions.
Share This Course
Know someone who would benefit from this course? Share it with your network or colleagues.
Access the full course outline
Just a few details and you’ll get instant access to the full course outline — completely free.
Download the full course outline for detailed information on objectives, session content, and learning outcomes.
Enhancing Decision Making Skills in the Workplace
Make faster, clearer, better-judged calls at work. You will leave with practical frameworks to cut through bias, weigh options confidently and justify every decision you make.
Driving Successful Changes
Gain the mindset, confidence and practical tools to lead your team through change — engaging people, overcoming resistance, and embedding new ways of working that last.
Developing a Coaching Approach
Shift from directing to enabling. Learn core coaching skills and models that empower your people to take ownership, solve problems and grow in confidence.
Critical Thinking and Creative Problem Solving
Sharpen how you think — combine structured analysis with creative techniques to tackle complex problems, make confident decisions and generate practical solutions you can apply straight away.
Creative Problem Solving
Master a structured six-step approach to creative problem solving and decision making, giving you the tools and confidence to crack problems quickly and choose the best solution.
Creating Psychologically Safe Working Environments
Learn how to build trust, encourage open communication and create a team culture where people feel safe to speak up, challenge and grow.
Delegation Techniques
Gain the confidence and practical tools to delegate effectively, freeing your time, developing your people and driving stronger team performance and organisational growth.
Stakeholder Management: Influence, Engagement and Control
Develop advanced stakeholder management skills to navigate complex environments, influence without authority, and sustain effective engagement across the full project or change lifecycle.
Stakeholder Management Essentials
Build the skills to identify, analyse, and engage stakeholders effectively, driving better outcomes across projects, change initiatives, and operational delivery.
How to be Assertive
Develop the confidence to communicate clearly, set boundaries, and handle challenging interactions professionally while maintaining empathy and positive relationships.
