How to Build a Simple Navigation Dashboard in Excel
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
HYPERLINK Function (Microsoft)
Download the Project Files
Follow along with the tutorial by downloading the files used in it. (Completely Free)
Phone number is optional - we use it to send course discounts and weekly updates via SMS.
View our Privacy Policy | Terms of Use
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: In this tutorial, you'll learn how to use Power Query in Microsoft Excel to build a self-...
Tutorial: How to create a custom worksheet function in Excel. These are called User Defined Function...
Tutorial: How to make a wonderful sparkling Christmas tree in Excel. This method uses only formulas...
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Tutorial: How to reset all Form Controls on a worksheet in Excel with the click of a button or two ...
Tutorial: Here, I'll show you a quick, simple, and effective way to fix formulas and functions in E...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)