excel vba courses london - Excel Auditing

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

Resolved · Low Priority · Version Standard

Excel Auditing

David has attended:
Excel Advanced course

by - delegate David [2 posts] (2007 Aug 3 Fri, 09:54) Reply

What's the most effective way to review the intergrity of a spreadsheet i.e. ensuring that all formulas have been dragged down correctly & no errors exist etc

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	6	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: Excel Auditing

by - trainer Richard platinum contributer [813 posts] (2007 Aug 7 Tue, 11:15) Edited on 2007 Aug 7 Tue, 11:18 Reply

Hi David

Depending on the complexity of your worksheet, I can recommend the following:

1. Doing it manually
2. Use the FORMULA AUDITING toolbar
VIEW > TOOLBARS > FORMULA AUDITING
There are two tools that may assist you.
- Show precedant and dependant cells
- Circle invalid data
- Error Checking

Those will highlight the issues on your sheet. There may be ones that might miss, but it will generally pick up any major issues. Obviously if your formula is pointing to the incorrect cell / value, and the answer is not ciorrect for oyour use, it might not pick that up, as it only checks the basic structure and syntax.

Regards

Richard

RE: Excel Auditing

by - delegate David [2 posts] (2007 Aug 17 Fri, 13:35) Reply

Thanks Richard those are handy functions to use.

Rgds

David

· Excel and Inventory Management
· Tips to Facilitate Printing of Excel worksheets
· Benefits of learning about Excel charts
· How Small Businesses Profit from Outside Excel Training
· How to check for and reduce errors in Microsoft Excel

Excel tip:

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips