excel visual basic training

excel visual basic training - Pivot tables

Resolved · Low Priority · Version Standard

Pivot tables

Sarah has attended:
Excel Advanced course

by - delegate Sarah [1 post] (2007 Oct 10 Wed, 16:08) Reply

How to create 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	5	book now	£450	£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 tables

by - trainer Sandy silver contributer [93 posts] (2007 Oct 11 Thu, 12:20) Reply

Hi Sarah

1) Click on your data on your Excel worksheet and select Data menu, PivotTable and PivotChart Report.

2) Follow the wizard from Step 1 to 3.

Please note on Step 3 you will need to click on the Layout Button to enable you to construct the Pivot Table by dragging the field buttons on the right to the diagram on the left.

Hope this helps.

· Tips for Transitioning to Excel 2007
· A Beginners Guide To Formulas In Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Courses Teach Advanced Macro Techniques
· Training Budgets In A Bad Economy

Excel tip:

Make macros work in newer versions of Excel

If you have created macros in Excel 97 or 2000 that you want to be able to use in 2002/XP or 2003, you may need to alter the macro security settings in the newer version of Excel you are using.

To do this, go to Tools - Options - Security.

Select Macro Security and change the security setting to Low.

Tick the boxes next to 'Trust Add-ins' and 'Trust Visual Basic' and click OK.

After you have restarted Windows, you should then be able to use your macros created in earlier versions of Excel.

View all Excel hints and tips

Rate this page: