Excel Advance

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

Resolved · Low Priority · Version 2007

1 post

ReplyWed 13 May 2009, 13:59Delegate Sin-niew said...

Sin-niew has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Excel Advance

How to create a Pivot Table?

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 9 + Tue 10 Aug 2010	Bloomsbury	0	FULL			£495
2003	Wed 11 + Thu 12 Aug 2010	Southwark	3		£495	£495	£495
2003	Wed 25 + Thu 26 Aug 2010	Bloomsbury	8		£450	£455	£495
2007	Thu 2 + Fri 3 Sep 2010	Bloomsbury	5		£490	£495	£495
2003	Wed 8 + Thu 9 Sep 2010	Southwark	8		£450	£455	£495
2003	Tue 21 + Wed 22 Sep 2010	Southwark	8		£450	£455	£495
Full Schedule: See all 47 Excel VBA Intro Intermediate course dates. Bookings currently available until 28th September 2011.

2,024 posts

ReplyWed 13 May 2009, 15:05Trainer Amanda said...

RE: Excel Advance

Hello Sin-niew

Thank you for your question and welcome to the forum.

To create a pivot table:

1. Select the data you would like to create the pivot table from.

2. Go to the Insert tab, click the Pivot Table button.

3. Select PivotTable from the list.

4. Double-check the range you have selected.

9. Select New Worksheet or Existing worksheet.

10. Click OK.

Kind regards
Amanda

Wed 20 May 2009: Automatically marked as resolved.

· Using Dates Within Excel
· Fun Things I've Done With Excel
· Database Tips from an Excel Training Course
· Microsoft Excel can ensure you keep on top of your finances
· Easing the Transition to Excel 2007

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

Excel tip:

Select blank cells automatically

Get Excel to find any blank (empty) cells in a region for you by:

1. Selecting the appropriate region from your spreadsheet.

2. On the menu bar, go to Edit - Go to.

3. Click the 'Special' button, then select Blanks and click OK.

View all Excel hints and tips