Exceljet

Quick, clean, and to the point

Excel tips: debug

These videos come from our Excel video training.
Tip: How to trace a formula error in Excel
Sometimes, you open a spreadsheet and see errors everywhere! Fortunately, Excel contains a cool tool that can automatically trace errors, and pinpoint the exact source.
Run time: 2:29
Tip: How to trace formula relationships
In this video, we look at how to quickly find formulas and trace relationships, using the concept of precedents and dependents. A great way to quickly understand an unfamiliar worksheet.
Run time: 3:13
Tip: How to evaluate complex formulas
In this video, we look at how to use Evaluate Formula to solve complex formulas one step at a time. It's a great way to understand how Excel solves a formula.
Run time: 3:18
Tip: How to check and debug a formula with F9
In this brief video, we look at how to debug a formula using the F9 key. If you work with formulas a lot, this is one of the most useful skills you can learn.
Run time: 3:10