Microsoft Excel: Auditing Formulas

Wishlist Share

About Course

Find out how a spreadsheet really works and track down mistakes using Excel’s formula auditing tools. You will trace precedents and dependents, step through formulas with Evaluate Formula, monitor key cells with the Watch Window and understand what each error value means.

This course is general training. Menu names and features can differ between Excel for Microsoft 365, Excel 2021/2024, older versions, Mac and Excel for the web, so check Microsoft Support for your version. Tutwoo is independent and not affiliated with Microsoft.

What Will You Learn?

  • Trace which cells feed into a formula and which formulas depend on a cell Step through a complex formula one part at a time Use Error Checking, Show Formulas and the Watch Window Recognise and fix common error values and circular references

Course Content

Course Lessons

  • Tracing precedents and dependents
  • Evaluate Formula and the Watch Window
  • Error values and Error Checking
  • Circular references and a review checklist

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕