Practical Excel Pivot Tables: 1 Hour, Fast, Focused & Instructor-Led

Practical Excel Pivot Tables: Fast, Focused & Instructor-Led

EXCEL PIVOT TABLES IN 45 MINUTES COURSE

Excel Pivot tables are surprisingly easy to create, yet incredibly powerful. In this focused, practical session, you’ll learn how to turn raw data into clear, valuable business insights in just minutes.

This short, instructor-led workshop shows you how to use Excel Pivot tables creatively and confidently to analyse data, spot trends, and answer real business questions fast. You’ll gain hands-on techniques you can apply immediately at work.

The session runs every Friday morning, 45 minutes only, and is designed to fit neatly into your schedule: powerful learning with minimal disruption to your working day.

Course Outline:

• Create an Excel Pivot Table in 10 Minutes
• Changing a Pivot Table
• Formatting a Pivot Table
• Creating additional formulae
• Sorting values and categories
• Grouping dates
• Filter an Excel Pivot Table
• Adding slicers as interactive filters
• Create a Pivot Charts
• Changing a Pivot Table and more...

WHAT IS INCLUDED:

• Questions during the session is welcome, to ensure interactivity and maximise your benefit of the time
• Certificate on completion
• Sample spreadsheets with Pivot Tables
• After the course, 1 free online revision / questions session
• Max group size is 4.