Excel Pivot Tables Tutorials
19 November 2010
Excel Pivot tables are a great way to analyse lots of data. The data you analyse can be in the spreadsheet in which the pivot table resides. It can also be in other spreadsheets, databases, other text files, etc.
You can create pivot tables that automatically update themselves every time you open the spreadsheet. This is a great way to create a simple, cheap dashboard of your company's performance.
For an excellent tutorial on pivot tables, check out the Contextures website which has lots of links and tips for Excel. Their pivot table tutorial starts here.
There is a sister site which is just about pivot tables - see here.
A few more tutorials to get you started:
You can create pivot tables that automatically update themselves every time you open the spreadsheet. This is a great way to create a simple, cheap dashboard of your company's performance.
For an excellent tutorial on pivot tables, check out the Contextures website which has lots of links and tips for Excel. Their pivot table tutorial starts here.
There is a sister site which is just about pivot tables - see here.
A few more tutorials to get you started:
- Chandoo's "What is a pivot table and how to make one"
- "Crunching Data with Pivot Tables in Excel 2003". As this one is using the 2003 version of Excel, some of the issues identified with Excel are no longer issues in the later versions. However, it's still a good tutorial for beginners.
- Peltier's "Using Pivot Tables in Microsoft Excel".
