EXCEL 2007

The UK's most regular instructor-led training courses.
Training information: microsoft excel courses tate · Excel advanced · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

EXCEL 2007

Hijiri has attended:
Powerpoint Introduction course
Powerpoint Advanced course
Excel Advanced course

by - delegate Hijiri [3 posts] (2008 Feb 13 Wed, 09:59) Reply

What is a PivotTable?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 8 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 8 Tue	Bayswater	1	book now	£195	£205
2003/XP	2008 Jul 9 Wed	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Bloomsbury	3	book now	£210	£215
2003/XP	2008 Jul 15 Tue	Tooting	0	FULL
2007	2008 Jul 16 Wed	Bloomsbury	7	book now	£202	£224
Full Schedule: See all 160 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: EXCEL 2007

by - trainer Pete platinum contributer [600 posts] (2008 Feb 14 Thu, 09:12) Reply

Hi Hijiri, Thank you for your post, In answer to your question, a Pivot Table is an interactive worksheet table that can summarise large amounts of data using the views and permutations 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 the pivot table, a pivot table can be used as a source for a pivot chart. I hope that makes it clearer. best regards Pete.

· How to Create Better Excel Spreadsheets: Part Two
· Take the Anxiety out of Domestic Finances with Microsoft Excel
· Compare Different MS Excel Training Methods
· What's Better Than the Help Function in Excel? Microsoft Training
· Advanced Excel Training - takes you to the next level

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

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips