Better than Pivot Tables?
For advanced pivot table users, there’s an interesting article over at PC World about a tool by Tableau Software. Its a little pricey, but according to the author for some users it can be worth it. Check it out at the link below.
Visualize Your Data in Whole New Ways
Tableau’s visual representations of data are easier [...]
Excel Pivot Tables Explained
For some good tips on how to create a pivot table check out Stephen Well’s article from Personal Computer World.
Explore how Excel’s Pivot Table can help you to make sense of your data
Whether you call it a table, list or flat-file database, a series of records all neatly split into the same fields forces a [...]
Excel Pivot Tables - Dynamic Data Source
Excel pivot tables are usually created based on a data source that doesn’t change. So how do you deal with a data source that gets updated regularly? The article linked to below shows one way to handle this situation using Excel’s OFFSET and COUNTA formulas.
Use [...]
Pivot Table Date Grouping Problem
Have you ever tried to group dates in a pivot table and been told that you can’t group that selection? It’s very frustrating because you have no way of knowing what’s causing the pivot table error. There’s a great article that explains what causes this problem and how to fix it. Check [...]
How to Create a Pivot Table With Totals at the Top
Have you ever wanted to show the grand totals of a pivot table at the top of the column? There’s no easy way to do it. The following pivot table tutorial shows how to create a pivot table with the totals at the top. Very Clever. Check it out.
Show [...]
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 [...]
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 [...]
What Is a Pivot Table
For an excellent review of how and why you can use a pivot table, Matthew MacDonald’s Missing Manual series is a great resource.
What Is a Pivot Table
by Matthew MacDonald, author of Excel: The Missing Manual
08/12/2005
Pivot Table
The Pivot Tables tool is one of the most powerful yet intimidating features in Excel. Pivot tables allow you to [...]
Pivot Tables With Colors
Jazz up the presentation of your pivot tables with colors.
Format Pivot Table with Colors
Do you know that you can format pivot table with colours to faciliate viewing or presentation? I have always thought that pivot table is only a good analytical tool but not a good report presentation tool. This is because the results displayed [...]
