Add Navigation Menus to Your Excel Workbooks

In this video we add a navigation menu to our excel workbooks. This is an awesome trick to make your excel workbooks function more like a software.
►Strength Coach Tutorials Episode Idea: forms.gle/6s9piVFFEmTBprUx7
If I create your sheet for a video I will send you the video for free!!
►Purchase the Set & Rep Planner HERE: bit.ly/35PfOhz
SUBSCRIBE TO DSMSTRENGTH: bit.ly/3xRrNH7
[Books I Love] Support the Channel
►Periodization: amzn.to/2mOiBDA
►Strength Coach Guide to Excel amzn.to/2xAEZ4p
►Strength Coach Playbook: amzn.to/2mY9crI
►Principles and Practice of Resistance Training: amzn.to/2mM1Jf6
►High Performance Training for Sport: amzn.to/2mqWb74
[Connect with Me]
►See all Strength Coach Tutorials: bit.ly/2mLU5Bf
►Check our website: www.dsmstrength.com
[Social Media]
►Instagram: / dsmstrength
►Twitter: / dsmstrength
►Facebook Page: / dsmstrength

[@zachrickard4241]

This is just about one of the coolest things I've ever seen on Excel. I've used the annual plan videos for a project, but this might end up being the 'wow factor' I need (as in 'wow factor' is a part of our grade). Thank you so much!

[@DSMStrength]

Hey Zach, thanks so much for checking out the video... I have my students include a wow factor as well! would love to see what you come up with.

[@Pitman335]

Awesome!! That is very informative, Thanks a million!

[@alaaeddine6340]

thank you so much that was amazing

[@adamsykes5755]

hello could i get a download link for this please?

[@arqamqazi9239]

Amazing n informative

[@DSMStrength]

thank you for watching!

[@seymourtompkins]

Great video- subb'd ! I was playing around with Excel last week & I figured out how to do this. Seemed like a neat trick (or perhaps more like a hack). I'd just add this: at a certain point, users need to hop over to using a database if that's what really fits. It offers this kind of functionality without the need for a hack. The fun zone for me is to explore how I can integrate Excel with a database- the best of both worlds. Would welcome your ideas. Thanks.

[@DSMStrength]

thanks for taking the time to check out the video!
Typically I am dealing with strength and conditioning coaches and fitness professionals so a data base is likely not as important because the amount of data will not be as high as a lot of other professions.. but I agree that sould be a consideration at some point and with something like power query in excel you can integrate pretty well!

[@nikkrn4926]

nice!

[@DSMStrength]

thank you

[@PamWright-kn6de]

This was definitely very useful. My follow up question is now that i have my navigation menu created in each worksheet I am ready to populate my worksheets that have different formulas and links etc in them. I'm not sure how to ask this but i essentially want to 'disconnect' the navigation pane from the rest of the worksheet so that changes i make in the body of the worksheet don't change the format/appearance of the navigation menu. Can I/How can I do this? Thanks

[@mittenwald3679]

you could use ONLY the icons part , or insert Text Boxes , and then right click -> properties -> dont move and size with cells

[@barcelonefrance8661]

Hi! is it possible to lock the menu? The goal being that if we scroll, the menu remains visible

[@DSMStrength]

you can lock the rows or columns but it will also lock all of the content on the sheet if you scroll down .. what I would recommend is to put your menu along the top of your sheet and lock the first couple rows. Hope that helps.

[@axldrum4534]

XD

[@DSMStrength]

thank you i think