pivot tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

resolvedResolved · Low Priority · Version 2003

Kate has attended:
Excel Intermediate course

Pivot Tables

How do i compare data using pivot tables?

RE: Pivot Tables

Hello Kate

Thank you for your question and welcome to the forum.

As pivot tables can be used to present data in numerous ways, it is difficult to be able to answer this question in a way that would help you with the specific data you are using.

If you would like to be able to learn more about pivot tables and how they work, there are a number of pivot table tutorials on the Microsoft web site - within each tutorial there is a Practice option which you can download a practice spreadsheet from and instructions will open in Excel Help that will step you through an exercise.

A complete list of Excel tutorials can be found on the following page (Pivot Tables specifically are listed under number 6):
http://office.microsoft.com/en-gb/excel/HA011161281033.aspx

An example of a page where you can download a practice activity from is below:
http://office.microsoft.com/training/Training.aspx?AssetID=RP010139641033& ;CTT=6&Origin=RC010136191033

I hope this helps.
Amanda

Fri 12 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Counting Blanks

Some times you want to check if there are cells missing data in your range. You can use the COUNTBLANK FUNCTION to acheive this. It is =COUNTBLANK(Range). Note Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

View all Excel hints and tips


Server loaded in 0.09 secs.