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

Build a professional Navigation Dashboard in Excel that ANYONE can customize.

You can add, edit, and remove navigation links without editing formulas, functions, or even visiting the “Insert Link” screen.

This tutorial includes an explanation of creating dynamic hyperlink functions that point to places in the same workbook or worksheet. This trick allows us to easily build our Navigation Dashboard.

Resources:
Download the File: https://www.teachexcel.com/exceltuto...
HYPERLINK Function (Microsoft): https://support.microsoft.com/enus/o...
TeachExcel Online Courses: https://www.teachexcel.com/premiumco...

00:00 How it Works
01:15 Setup the Workbook for Navigation
02:50 Building Navigation Links with HYPERLINK
05:50 Make the HYPERLINK Function Dynamic
07:27 Finalize the Navigation Dashboard

#msexcel #tutorial #exceltips #freetutorial #excel