Stop struggling with Excel formulas, trace and fix errors fast!
Whether you're dealing with those #! errors or formulas returning unexpected results, I'll show you how to trace and fix the problems quickly using Excel’s built-in tools
00:00 - Intro
00:23 - Excel's error checking rules
02:25 - How to use Trace Precedents and Trace Dependents
04:51 - Navigating formula errors with Evaluate Formula
06:17 - Viewing underlying formulas on a sheet instead of their results
06:56 - Tracing errors
07:23 - Diving deeper with Excel's Error Checking tool
08:48 - Finding circular references
10:14 - Tracking formula outputs with the Watch Window and Camera tools
12:39 - Summary
Intro music: "Pitbull" by Michael Ramir C.
https://mixkit.co/
#excel #exceltips #exceltutorial #formulaerrors #spreadsheet #ms365 #msoffice #office