Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Auditing

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Auditing

Resolved · Low Priority · Version 2007

Reply Thu 19 Jun 2008, 16:26Delegate Victoria said...

Victoria has attended:
Excel Intermediate course
Excel Advanced course

Auditing

What type of situation would I use this in?

For upcoming training course dates see: Pricing & availability

Reply Thu 10 Jul 2008, 09:59Trainer Mark said...

RE: Auditing

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

Excel articles

· Chart Creation Simplified - in 4 Simple Steps
· More Tips From Excel's Rarely Used File
· Utilise the web's information banks with Microsoft Excel
· Excel Charts As Easy As Pie
· Improve Performance Of Your Excel Macros

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

Excel tip:

Move data worksheet to worksheet

To move data from one worksheet to another, highlight the data.

Select and hold down the ALT key and position the mouse on the border of the selection until the mouse pointer displays four-headed arrows.

Drag the selection down to the destination worksheet tab.

When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key.

To copy data from one worksheet to another, select and hold down the CTRL+ALT keystroke combination and perform the steps above.

View all Excel hints and tips