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

Auditing

ResolvedVersion 2007

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

Victoria has attended:
Excel Intermediate course
Excel Advanced course

Auditing

What type of situation would I use this in?

Thu 10 Jul 2008, 09:59 Trainer 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@stl-training.co.uk

MOUS Master Instructor

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Fill formulae across a sheet

To copy a formula down a spreadsheet where there is data underneath, to the left or to the right of the formula, double-click on the fill handle. The fill handle is the little black cross that appears in the bottom right-hand corner of the formula cell. Unfortunately, no similar facility exists to copy formulae across the sheet.

One reasonably quick way to copy an existing formula across a sheet is to select the formula and the cells on the right to which you want to copy it. Then press Ctrl+R to copy the formula across the selected range, or, if you are menu-minded, use the Edit|Fill|Right command.

View all Excel hints and tips

Auditing

Auditing

RE: Auditing

Excel articles

Excel tip:

Fill formulae across a sheet