Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - Errors
Resolved · Low Priority · Version Standard
Paul has attended:
PowerPoint Intermediate Advanced course
Excel Advanced course
How can you avoid getting circular errors?
When you create formulas, make sure you are not referencing the cell that the answer is going to.
Alternatively, you can use the FORMULA AUDITING toolbar to assit in locating and solving formula errors.
VIEW > TOOLBARS > FORMULA AUDITING
|
Excel tip:Some examples of CTRL key shortcuts in Excel 2010Did you know that the old CTRL key shortcuts haven't changed from previous versions of Excel to the 2010 version? |
We'll call during UK business hours
Server loaded in 0.08 secs.