Free Video - 1 of 4

View and Setup Data

Hi, I’m Kelly, and you’re very welcome to this 1st video in a series of 4 free videos on creating a basic PivotTable.

Each video builds on the previous video, adding something new to the PivotTable that I create.

As an Excel training instructor, I’ve found that regardless of whether I’m training at an Introductory level or an Advanced level, PivotTables are the most sought after feature. This can place great pressure on employees especially if they don’t feel confidant using Excel.

Does that sound like you? Well if it does, then you’re in the right place because I’m here to ease that pressure!

It’s important to know that data to be used in a PivotTable needs to be structured in a way that Excel understands, or it just won’t work properly.

So, this video contains an explanation of the best way to set up that data, so that you can maximise the potential of a PivotTable.

I’ll also explain why it might be to your benefit, to set up the data as a Table, before creating a PivotTable.

Enjoy!