Auditing

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

Resolved · Low Priority · Version 2007

Auditing

Victoria has attended:
Excel Intermediate course

by - delegate Victoria [1 post] (2008 Jun 19 Thu, 16:26) Reply

What type of situation would I use this in?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Auditing

by - trainer Mark gold contributer [244 posts] (2008 Jul 10 Thu, 09:59) Reply

Hi Victoria

How are you today, im so sorry i haven't got back to you sooner been so busy.

Now the answer to your question is as follows, you can use formula auditing to locate where errors occur that make formulas go wrong. So if a formula that should work fine comes up with an error then you would trace back the cell to check where the error comes from

Hope this helps you

Feel free to reply to the post for more calification, or mark this as resolved

Many Thanks

Mark East

mark

MOUS Master Instructor

· How to Create Better Excel Spreadsheets: Part One
· Do You Really Need Excel VBA Training?
· How to Create Better Excel Spreadsheets: Part Four
· 5 Microsoft Excel Charts for Creating Stunning Business Documents
· Microsoft Excel Training Courses or Consultants: Which Is Better For Your Company?

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

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips