Excel

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

Resolved · Low Priority · Version 2003

Excel

Joanna has attended:
Excel Introduction course
Powerpoint Introduction course

by - delegate Joanna [2 posts] (2008 May 19 Mon, 16:47) Reply

How do you calculate all formulas into all cells?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Aug 29 Fri	Southwark	3	book now	£224	£235
2003	2008 Sep 3 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 5 Fri	Bayswater	4	book now	£195	£205
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	7	book now	£203	£230
Full Schedule: See all 127 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Excel

by - trainer Amanda platinum contributer [947 posts] (2008 May 23 Fri, 14:59) Reply

Hello Joanna

Thank you for your question.

As you can use formulas to do many different kinds of calculations, it would be useful to have a bit more information about what you would like to achieve using a formula.

Kind regards
Amanda

· How to check for and reduce errors in Microsoft Excel
· A Beginners Guide To Formulas In Excel
· Microsoft Excel Training Course
· Compare Different MS Excel Training Methods
· Benefits of learning about Excel charts

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

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