Classmill - Pivot your Cube

All the information in this class is used to complement the Excel for Accounts training sessions run by the IT Training team. If you have any questions please emaill it.training@eu.kwm.com. Each module here matches up with a live training session.

All the information in this class is used to complement...

Delete Drag

Preparing the data

Delete Drag

Before you get started you must make sure that your data is set up correctly. With your data broken up into discrete items of data in your columns and complete records in your rows.

Before you get started you must make sure that your...

Delete Drag

Here is a good example of data.

Delete Drag

The Best Way to Prepare Excel Pivot Table Source Data

This article gives you a detailed information on how to set up your data.

The Best Way to Prepare Excel Pivot Table Source Data

Delete Drag

Try the link below to see 4 short training videos by Microsoft. It will take you through the Pivot table basics. Please note that the videos are for Excel 2013 so a couple of features are not availble in Excel 2010 such as the recommended tables.

Try the link below to see 4 short training videos...

Delete Drag

Create a PivotTable and analyze your data - Excel

Link: https://support.office.com/en-gb/article/Create-a-PivotTable-and-analyze-your-data-7810597d-0837-41f7-9699-5911aa282760?ui=en-US&rs=en-GB&ad=GB

Create a PivotTable and analyze your data - Excel

Delete Drag

Pivot table videos

Delete Drag

More detailed learning

If you would like to learn more request a Lynda.com account from the IT Training team you'll then have access to all the Lynda.com courses.

More detailed learning

Delete Drag

lynda.com Training | Excel 2013: Pivot Tables in Depth

Once you have a Lynda.com account from IT Training take a look at the first 3 parts from this Lynda.com course.

lynda.com Training | Excel 2013: Pivot Tables in Depth

Delete Drag