Excel: Troubleshoot Formulas with Trace Precedents and Trace Dependents

Awaken the Force within, using Excel’s Trace Precedents and Trace Dependents functions to identify problems in your spreadsheet formulas, or just for better understanding. Blue arrows show formulas that work fine and red arrows show formulas in error. The direction of the...

Building Excel Dashboards

Excel Dashboard. In previous videos, I demonstrated the use of PowerView when creating dashboards. Now, I going to demonstrate dashboard creation with a more familiar tool, Excel. Despite the release of several visualization tools by Microsoft, Excel still represents Microsoft...
Send