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)
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: 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...
Tutorial: How to convert a time into minutes in Excel and also how to get minutes back into a time f...
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.)