In this lesson we cover one of the most requested topics in Excel. Pivot Tables.
What are Pivot Tables?
How do they work?
We walk you through all the steps to create a pivot table, how to work with pivot charts, using Excel tables effectively with Pivot Tables, how to create calculations in Pivot Tables, and more.
As always, we work through all the steps in plain English. Our lessons are geared towards the average Excel user that just wants to improve their skill set without having to suffer through hours of technical, confusing instruction.
Included in the book is a link to download a free workbook so readers can follow along with the exercises at their own pace.
The material for this book is for Excel 2010 for Windows. You can use Excel 2007 but there will be some differences between the text and Excel 2007.
What are Pivot Tables?
How do they work?
We walk you through all the steps to create a pivot table, how to work with pivot charts, using Excel tables effectively with Pivot Tables, how to create calculations in Pivot Tables, and more.
As always, we work through all the steps in plain English. Our lessons are geared towards the average Excel user that just wants to improve their skill set without having to suffer through hours of technical, confusing instruction.
Included in the book is a link to download a free workbook so readers can follow along with the exercises at their own pace.
The material for this book is for Excel 2010 for Windows. You can use Excel 2007 but there will be some differences between the text and Excel 2007.