PivotTables

Resolved · Low Priority · Version Standard

PivotTables

Victoria has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Victoria [14 posts] (2008 Mar 31 Mon, 12:12) Reply

Hello Best Training,

How would you describe the purpose of a PivotTable?

Thanks,

Vicky

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 27 Thu	Bloomsbury	3	book now	£240	£245
2003	2008 Nov 28 Fri	Southwark	1	book now	£235	£240
2003	2008 Dec 3 Wed	Bloomsbury	0	FULL
2003	2008 Dec 5 Fri	Bayswater	5	book now	£195	£205
2002/XP	2008 Dec 10 Wed	Tooting	0	FULL
2003	2008 Dec 10 Wed	Bloomsbury	0	FULL
Full Schedule: See all 98 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: PivotTables

by - trainer Pete platinum contributer [799 posts] (2008 Mar 31 Mon, 15:38) Reply

Hi Victoria, Thank you for your post, in answer and to keep it brief; A Pivot table is an interactive worksheet table that quickly summarises large amounts of data using the format and calculation methods that you choose. It is called a pivot table because you can rotate its row and column headings around the core data to give you different views of the source data. As the source data changes, you can update a pivot table. Because it resides on a worksheet, you can integrate a pivot table into a large worksheet model using standard formulas. You can also create a PivotChart based on the underlying pivot table to view the data graphically. I hope that answers your question, if it does please click the Resolved button, if not please come back, best regards Pete

· Excel and Inventory Management
· Advanced level training: Microsoft Excel and the Web
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips
· Prepare for your MOS Certification with MS Excel Courses
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

Please browse our web site to find out more about
excel vba courses and other Microsoft training courses.

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant´s name as 'VAT' (no spaces allowed) in the 'Names in Workbook' line.

Enter the constant value of '0.175' in the 'Refers To' text box - making sure any other text has been deleted.

Click OK.

In Excel you may have cell 'B10' as containing an amount and in 'C10' you want to work out the VAT on the amount in 'B10'.

The formula would be

=B10*VAT

This formula will generate the amount of VAT only.