Just Pivot Tables Posts Summary

POSTED BY Pivot Table Guy on Jun 30 under post summary

Check out these recent Just Pivot Tables Posts
Building a Pivot Table in Excel 2007
What Is a Pivot Table
Format Pivot Tables With Colors
Excel 2007: Your Guide to Effective Pivot Tables

Bookmark It

Building a Pivot Table in Excel 2007

POSTED BY Pivot Table Guy on Jun 26 under excel tutorial, video

For those of you that prefer video training, the following pivot table tutorial for excel 2007 from “The Missing Manuals” series will be of interest.

Bookmark It

What Is a Pivot Table

POSTED BY Pivot Table Guy on Jun 25 under Google Docs, article

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

POSTED BY Pivot Table Guy on Jun 21 under article

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 [...]

Excel 2007: Your Guide to Effective Pivot Tables

POSTED BY Pivot Table Guy on Jun 19 under excel training

The folks over at Train Signal Training have put together an excellent excel 2007 pivot table training tutorial by Kasia Grabowska. Check it out.
Posted on January 4th, 2008 by Kasia Grabowska

Pivot tables are not new to Excel 2007; in fact they’re included in all versions of the program. But surprisingly not a lot of [...]

Introduction to Excel 2003 Pivot tables

POSTED BY Pivot Table Guy on Jun 15 under excel tutorial

If you are interested in a well done tutorial on how to use excel pivot tables the pdf file linked to below from Duke University is what you are looking for.
Introduction to excel 2003 Pivot Tables

Bookmark It

How to Use Pivot Tables to show values and percentages side by side

POSTED BY Pivot Table Guy on Jun 12 under excel tutorial, video

I came across this very well done video of how to set up a pivot table in Excel 2007 to show the value and percent for the same item. This is a little used but valuable feature in Excel that will help you to easily show the relative importance of the various items.
Rikki’s Hints [...]

OpenOffice.org Calc’s answer to Excel pivot tables

POSTED BY Pivot Table Guy on Jun 9 under article

Just in case you thought that Excel pivot tables were the only game in town. You can check out the link below for some information on OpenOffice’s pivot table otherwise known as the data pilot.
Using the data pilot: OpenOffice.org Calc’s answer to pivot tables
Solveig Haugland

With the right statistics, you can prove anything. [...]

How to Create Pivot Tables

POSTED BY Pivot Table Guy on Jun 5 under excel tutorial

How to Create Pivot Tables in Excel
from wikiHow - The How to Manual That You Can Edit
PivotTables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. One advantage of this feature in Excel is that it allows [...]

How To Create A Pivot Table In Excel 2003

POSTED BY Pivot Table Guy on Jun 3 under excel tutorial

How To Create A Pivot Table In Excel 2003 - video powered by Metacafe

Bookmark It

Next Page »

Copyright Just Pivot Tables | Powered by WordPress | Using the GreenTech Theme