???? 500,000+ enrolled in our courses. Join them ???? https://link.xelplus.com/yt-d-all-courses
Team licenses: https://www.xelplus.com/business-customers/
Tired of scrolling through a massive Excel workbook in front of other people?
In this video, you’ll learn 4 fast ways to navigate large Excel files so you can jump to the right sheet instantly, build a clickable “dashboard-style” menu, and even create Name Box bookmarks you can access from anywhere in the file.
⯆ DOWNLOAD the Excel file I used in the video here: https://pages.xelplus.com/excel-navigation-file
What you’ll learn
-Secret sheet list: right-click the sheet navigation arrows to jump to any tab
-Navigation Pane (Microsoft 365): search sheets and workbook elements in seconds
-Clickable Excel navigation dashboard: use hyperlinks to turn a summary sheet into a menu (plus a “back to summary” button)
-Name Box bookmarks: name key cells so you can teleport there by typing a name
-Useful Excel keyboard shortcuts
Chapters
00:00 Custom sidebar and other navigation tricks for Excel
00:40 Secret right-click sheet menu
01:12 Navigation Pane (Microsoft 365)
02:18 Clickable navigation dashboard with hyperlinks
04:38 Custom sidebar
08:06 Name Box bookmarks
???? Subscribe to “Between the Sheets” newsletter to stay on top of office tips and Excel hacks: https://link.xelplus.com/yt-d-newsletter
➡️ Join this channel to get access to perks:
https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join
???? LINKS to related videos:
Learn to Automate Everything with Power Query in Excel: https://youtu.be/x7mzOYEn0XA
Create an Excel Dashboard to Easily Track Budget and Actuals with Variances: https://youtu.be/lHk6MdGAfw8
????☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
???? Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
???? RESOURCES I recommend: https://www.xelplus.com/resources/
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
????Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
LinkedIn: https://www.linkedin.com/company/xelplus
This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
