microsoft excel training

microsoft excel training - Pivat tables

Resolved · Low Priority · Version Standard

Pivat tables

Carly has attended:
Excel Advanced course

by - delegate Carly [1 post] (2008 Jan 25 Fri, 13:59) Reply

How to do a pivat table?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu	Bayswater	2	book now	£195	£205
2007	2008 Dec 8 Mon	Bayswater	2	book now	£224	£224
2007	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 9 Tue	Tooting	0	FULL
2003	2008 Dec 11 Thu	Southwark	7	book now	£188	£215
2007	2008 Dec 16 Tue	Bayswater	6	book now	£207	£215
Full Schedule: See all 109 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Pivat tables

by - trainer Amanda diamond contributer [1243 posts] (2008 Feb 7 Thu, 09:51) Reply

Hi Carly

Thank you for your question; and apologies for the delay in response.

In summary, to create a pivot table:
1. Select the data you would like to include in the pivot table.
2. Go to Data - Pivot Table & Chart Report.
3. Follow through the three step wizard.

I hope this helps.
Amanda

· Creating Charts with Excel
· Excel Macros for the Non-Programmer
· Microsoft Office and the Small Business: Part 1 Excel
· Excel in the Home Office
· Microsoft Excel Training Course

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

Rate this page: