Microsoft Excel Team Blog Pivot Table Posts
One of the great things about the web is that it has allowed developers to have a conversation with end users. Over at the Microsoft Excel team blog there are a number of posts with the pivot table tag. Some of these posts discuss OLAP analysis and SQL lookups that I’m [...]
Excel 2003 Pivot Table Tutorial
If you have ever been confused by the terminology that is used to describe pivot tables, then this video will help. It does a good job of explaining what the various parts of the pivot table and pivot table data are called. It covers items such as source data, data items, and fields.
Excel 2003 Pivot [...]
Microsoft Excel Pivot Tables
From the Microsoft Website an excellent Excel Pivot Table tutorial.
A Business Software Tip by J. Carlton Collins, CPA
Accountants have long known the value of PivotTables. But they’re a great data analysis tool for management, too. PivotTables allow you to create multidimensional data views by dragging and dropping column headings to move data around. J. Carlton [...]
Excel Pivot Table Tip - Show Pages
Ever want to create multiple pivot tables on separate tabs from one original pivot table? David Carter’s Show Pages tip shows you how to do it.
Tip #3 - Use the Show Pages command to generate pivot tables for Page fields automatically
If you use Page fields in a pivot table, you can use the Show Pages [...]
Basic Excel Pivot Table Set Up
Michael Kan’s Tip of the Week blog has a good tutorial on setting up a basic Excel pivot table. Included in the tutorial is a nice clean description of how to use the pivot table wizard and the layout dialog box.
As demonstrated in Michael’s excel tutorial, I’ve found that using the pivot table wizard and [...]
Google Spreadsheet Analytics and Pivot Tables Gadgets
If you are using or trying out pivot tables with Google Spreadsheets you may want to check out this article.
Panorama and Alchemex spearhead ‘analytics as a service’ push
The recent addition of a pivot table gadget for Google Spreadsheets signalled the beginnings of an online attack on Microsoft Excel’s hold over business analysis. John Stokdyk reports
Google’s [...]
A Critical Pivot Table Skill - Removing Subtotals
If there is one thing that you need to learn about creating pivot tables, this is it. Removing subtotals is a simple but critical step in getting a better view of your data. Take it from someone that uses pivot tables every day, you need to learn this skill. Once removed, subtotals can always be [...]
