This week I went live once again on YouTube (becoming a bit of a habit this!), delivering a session called “Excel Pivot Tables for Beginners”

If you’re a Pivot Table Newbie or just need to brush up on your skills you can catch up on the recording via the links below.

If you don’t even know what a Pivot Table is and whether you need to know, let me just say that in my opinion, knowing how to create Pivot Tables is a must-have skill for Excel users who need to analyse data and build reports.

It doesn’t matter whether you’re a Data Analyst building an Excel-based dashboard, a small business owner who has to make some serious decisions or a home user who needs to summarize data for a personal project, Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) toolkit.

The training will provide you with a solid foundation that you can use to build your own pivot tables and reports.

With just a few clicks of the mouse (and no complicated formulas!) you can quickly and easily build the reports, dashboards and charts that help you to summarize, analyze, interpret and understand your data which in turn helps you to spot trends and get answers to the important questions on which you base your key decisions.

Pivot Tables have a reputation for being complicated and scary but by watching this training, you’ll be pleasantly surprised at how easy it is to use and create them.

Links to the video and individual sections below…

What is a Pivot Table (and Why Do You Need to Know?)

Create a Basic Pivot Table

Prevent Column Widths Changing on Refresh

Calculating Percentages

Sort a Pivot Table

Filtering a Pivot Table


Create a Chart from a Pivot Table

Refresh the Pivot Table and How to Change the Data Source

Introduction to The Data Model