Course Hive
Search

Welcome

Sign in or create your account

Continue with Google
or
Stop Scrolling! 4 Pro Ways to Navigate Excel
Play lesson

Excel Introduction - Learn Excel Basics - Stop Scrolling! 4 Pro Ways to Navigate Excel

5.0 (0)
9 learners

What you'll learn

This course includes

  • 5.5 hours of video
  • Certificate of completion
  • Access on mobile and TV

Summary

Keywords

Full Transcript

🔥 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

Course Hive

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

FAQs

Course Hive
Download CourseHive
Keep learning anywhere