Auditing Excel Formulas - Quick Tips

Описание: ✅ Get the sample Excel file to follow along ► https://myctx.link/audit

🔵 When troubleshooting formulas in Excel, you can use keyboard shortcuts and Ribbon commands to help with auditing the formulas. For example, show the formulas on the worksheet, instead of the formula results. You can also trace the precedent and dependent cells for a formula, to see which cells are affected by a formula, and which cells it affects.

💡 Related Links 💡
Auditing Excel Formulas ► https://myctx.link/audit
Excel Worksheet Tips ► https://myctx.link/wksh
More Excel Tips & Videos ► https://myctx.link/TipsXL

🔴 Related Excel Video 🔴
Troubleshoot Excel in Formula View ►    • Troubleshoot Excel in Formula View  

✅ Excel resources I recommend ► https://myctx.link/xlpick

⏰ Video Timeline ⏰
0:00 Show or Hide Worksheet Formulas
1:16 Trace Precedent/Dependent Cells
2:05 See Formulas with FORMULATEXT
2:40 Jump to Precedent/Dependent Cells

🔶 Instructor: Debra Dalgleish, Contextures Inc.
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips