Monitor Data in Excel without VBA/Macros

Excel VBA/Macro Course [80% Discount]: https://www.teachexcel.com/vba-course...

How to monitor cells in your workbook from a single and easy-to-manage setup that allows you to quickly identify an issue with a cell anywhere in the workbook, click a link to view that cell, and easily add or remove cells from the Data Monitoring setup.

This tutorial combines a number of tricks, including advanced Excel formulas and data management and viewing techniques.

Everyone can make a data monitor in Excel and here I show you how to do it!

Resources:
Download the File: https://www.teachexcel.com/excel-tuto...
Nav Dashboard:    • How to Build a Simple Navigation Dash...  
TeachExcel Online Courses: https://www.teachexcel.com/premium-co...

00:00 How the Data Monitor Works
02:05 Setup the Data Monitor
04:42 Dynamic Cell Value Formula
07:11 Comparison Menu Setup
07:52 Dynamic Value Compare Formula
08:30 Dynamic Nav Link Formula
10:23 Format the Monitor Table
13:12 Monitor Empty Cells
14:11 More Info. to Automate the Workbook

#msexcel #tutorial #exceltips #freetutorial #excel