advanced excel ms training

advanced excel ms training - Pivot table

Resolved · Low Priority · Version Standard

Pivot table

Nora has attended:
Excel Introduction course

by - delegate Nora [1 post] (2007 Apr 2 Mon, 09:49) Reply

What is a pivot table?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	3	book now	£475	£495
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	4	book now	£499	£530
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	8	book now	£345	£425
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
Full Schedule: See all 34 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Pivot table

by - trainer Tracy platinum contributer [586 posts] (2007 Apr 2 Mon, 09:55) Reply

Hi Nora

Thanks for your question.

The idea behind a pivot table is to take information that is stored in a series of columns in Excel (a list) and turn it into a summarised table format.

The pivot table allows you to collate/summarise individual values that are stored in a column, by for example, summing them, averaging them, displaying percentages of totals and so on.

The major advantages of a pivot table are that you can rearrange the items you put into the table quickly and easily by dragging and dropping; and you can create a chart from it by clicking a button.

Tracy

· Crazy Things People Have Done With Excel
· MS Excel: Excel At Making The Most Of Your Christmas
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Training Budgets In A Bad Economy
· Microsoft Excel Features and Functions for Accountants

Excel tip:

Checking if a calculation adheres to Order of Precedence

When writing formulas you must make sure that results will be calculated as you intended.

Excel adheres to the standard order of precedence for calculations. It calculates percentages, exponents, multiplication, and division in this order before calculating addition and subtraction.

For example, =7+5*3 results in an answer of 22, not 36.

To force a calculation to be completed before another calculations, place the section in parentheses: =(7+5)*3 will result in 36.

To check how excel is evaluating a formula, click on the cell and select the 'Tools' menu, select 'Formula Auditing' and click 'Evaluate Formula'

In the dialog box click on 'Evaluate' to watch as each part of the formula is successively calculated.

View all Excel hints and tips

Rate this page: