Advanced Excel

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

Resolved · Low Priority · Version 2003

Advanced Excel

Gail has attended:
Excel Intermediate course

by - delegate Gail [1 post] (2008 Apr 17 Thu, 16:05) Reply

What is included in the Advanced Excel course?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 22 Tue	Tooting	0	FULL
2003/XP	2008 Jul 24 Thu	Bloomsbury	0	FULL
2003/XP	2008 Jul 28 Mon	Bayswater	2	book now	£195	£205
2007	2008 Jul 29 Tue	Bloomsbury	0	FULL
2003/XP	2008 Jul 31 Thu	Southwark	5	book now	£198	£215
2003/XP	2008 Aug 1 Fri	Bloomsbury	7	book now	£188	£215
Full Schedule: See all 153 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Advanced Excel

by - trainer David [15 posts] (2008 Apr 17 Thu, 16:23) Reply

Hi Gail

You can see the course outline here: http://www.microsofttraining.net/excel-training-in-london-2003-advanced.php

· Microsoft Excel Features and Functions for Accountants
· How to check for and reduce errors in Microsoft Excel
· Microsoft Excel's Best Kept Secret
· Microsoft Excel Training: Essential for Today's Employees
· Crazy Things People Have Done With Excel

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

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant´s name as 'VAT' (no spaces allowed) in the 'Names in Workbook' line.

Enter the constant value of '0.175' in the 'Refers To' text box - making sure any other text has been deleted.

Click OK.

In Excel you may have cell 'B10' as containing an amount and in 'C10' you want to work out the VAT on the amount in 'B10'.

The formula would be

=B10*VAT

This formula will generate the amount of VAT only.