How to make a custom navigation menu in Excel.
🔥 Get 20% OFF our Excel Course for the next 5 days only here: https://www.careerprinciples.com/courses/excel-for-business-finance
🆓 DOWNLOAD Free Excel file for this video: https://careerprinciples.myflodesk.com/kzojyxpnej
In this video, you'll learn to make an interactive navigation menu in excel using three different methods. First, we'll use Excel's built in navigation pane, which let's you navigate across different sheets. The only problem is that you need to add it back every time you open the workbook. The second method is the cover page hyperlink method, where we create a cover page and add hyperlinks to it to make it a navigation pane. This is not ideal because you always need to click pack to the cover page to use the navigation pane. The third and best method is a custom navigation menu using shapes and hyperlinks. This is similar to a sidebar in an application.
LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
🔥 Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
🚀 All our courses: https://www.careerprinciples.com/all-courses
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - Method 1: Basic Navigation Pane
1:37 - Method 2: Table of Contents
3:58 - Method 3: Custom Navigation Menu