Make a Custom Sidebar in Excel
Jakson tiedot
Jakson kuvaus
How to make a custom navigation menu in Excel. 🔥 Get our Bestselling Excel Course 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
Katso myös samalta kanavalta
Muut jaksot tältä kanavalta
Sinua saattaisi kiinnostaa
