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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

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

Pivot Tables

ResolvedVersion 2003

Wed 25 Feb 2009, 15:20 Delegate Laura said...

Laura has attended:
Excel Intermediate course

Pivot Tables

What are pivot tables as I have heard people mention they are useful?

Fri 27 Feb 2009, 14:58 Trainer Carlos said...

RE: Pivot Tables

Hi Laura

Pivot tables allow you to look at data in several dimensions. For example, sales by region, sales by sales rep, sales by product.

To create a Pivot table:

Select a cell in the target table

Click Data / Pivot table and Pivot chart report

Follow the steps in the Wizard

Hope this helps

Carlos

Thu 5 Mar 2009: Automatically marked as resolved.

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Bracketed negative numbers