Tracing formula errors

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

Resolved · Low Priority · Version 2003

1 post

ReplyMon 8 Feb 2010, 16:14Delegate Olga said...

Olga has attended:
Excel Intermediate course

Tracing formula errors

How do you trace formula errors

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Mon 22 Mar 2010	Limehouse	3		£224	£225
2003	Tue 23 Mar 2010	Southwark	4		£207	£212
2007	Thu 25 Mar 2010	Rochester (Hoo)	0	FULL
2003	Fri 26 Mar 2010	Limehouse	4		£224	£225
2007	Tue 30 Mar 2010	Southwark	4		£207	£212
2003	Thu 1 Apr 2010	Bloomsbury	4		£207	£212
Full Schedule: See all 77 Excel Intermediate course dates. Bookings currently available until 23rd December 2010.

336 posts

ReplyMon 8 Feb 2010, 16:30Trainer Anthony said...

RE: Tracing formula errors

Hi Olga, thanks for your query. Your Formula Auditing tools in the Tools dropdown menu are key to this. Remember to select a cell with a formula in it, then use Trace Precedents to determine what cells are being fed into the formula, and then Trace Dependents to find out where the value generated by that formula is being fed into. Remember to use these tools when trying to troubleshoot a REF! error message.

Hope this helps,

Anthony

Tue 16 Feb 2010: Automatically marked as resolved.

· The Importance of Data Backups
· Microsoft Excel Courses Teach Advanced Macro Techniques
· How to start using Excel 2007 Functions
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training - Discover A Hidden Power At Your Fingertips

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

Excel tip:

New Normal Worksheet

Do you want all your worksheets to confirm to a certain look? Then change the Defaults!!!
1. Press Shift+F11 to create a new worksheet
2. Press Ctrl+A to select (higlight) all cells, Press Ctrl+1, make any formatting changes then click OK.
3. Press F12 (Function 12 key) click in the Save As Type, drop down, then select Template (*.xlt)
4. Click in the Save in drop-down, then find the folder; c:_program files_microsoft office_office_start. (For the underscores shown use backslash)
Name your templete sheet.xlt, then press Enter.
Sheet.xlt is used when you insert a new worksheet (Shift+F11)

Note: These changes are permanent changes on your PC.

View all Excel hints and tips