This channel provides the absolute best and most comprehensive excel training on the internet. Absolutely brilliant training. And I cannot believe that it's free.
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much! Please spread the word 🙏
@alphaxg13 жыл бұрын
@@MyOnlineTrainingHub You're very welcome. By the way, do you have a training on how to automatically fill a pdf?
@MyOnlineTrainingHub3 жыл бұрын
No, sorry.
@RehillServices-g3zАй бұрын
@alphaxg1 what is your requirement, in my case , I have data in one sheet and I am fetching all the data using lookup and text formula for date and many more, pl see her all the formula videos and let me know if you need any further concerns
@oliverbuckley51213 жыл бұрын
Very good video Mynda. I’ve been using the hyperlinks for years but never knew about being able to assign them to buttons. Tabs approach’s very clever.
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Oliver!
@bc41983 жыл бұрын
This is fantastic, thank you! Feels like a stepping stone toward "Turn Your Excel Into An App!" and, like you said, would be great if you have other people using your sheets.
@MyOnlineTrainingHub3 жыл бұрын
Glad you like it :-)
@douglasbrown33543 жыл бұрын
Great video! I like how you used a defined name as the basis for the hyperlinks. I have also found that using VBA as a means to build a navigation system (userform) works well too. I reference the worksheets VBA code name and not the tab name. Of course this takes a bit longer to design, but if you lock down the VBE the end-user is not able to mess things up by deleting a hyperlink, name range or changing the worksheet tab name. Your demonstrated way in the video is really a great way to handle a multi-worksheet workbook. Thank you for another well-produced and informative video!
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Douglas!
@msaff62293 жыл бұрын
How I love watching your video tutorials with different interesting solutions! Thank you for your hard work! I am Russian-speaking and you are somewhat similar to Nikolai Pavlov from Russia.
@MyOnlineTrainingHub3 жыл бұрын
So pleased you enjoy my videos 😊
@patrickschardt77243 жыл бұрын
I like the idea of “tabbed” links. Like other things that directly reference sheets, hyperlinks should update when a sheet name is changed
@MyOnlineTrainingHub3 жыл бұрын
I agree, Patrick!
@BK_menu3 жыл бұрын
Good teacher 👍 student from India 🇮🇳 love you 🙏
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much 😊
@mhstrawn52173 жыл бұрын
Great video. Have long used hyperlinks in Excel and lengthy Word docs to allow users to quickly navigate large documents. Modifying them into buttons just makes it look cooler so will definitel integrate that into my efforts.
@MyOnlineTrainingHub3 жыл бұрын
Glad it was helpful!
@iankr3 жыл бұрын
Brilliant, Mynda. "Rinse and Repeat" 😊❤
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Ian! 😊
@chipmunk11353 жыл бұрын
Thanks for all the tutorials and examples.
@MyOnlineTrainingHub3 жыл бұрын
Glad you like them!
@tomkochka20582 жыл бұрын
Loved this. It made a report I designed look much more professional. Thank you!
@MyOnlineTrainingHub2 жыл бұрын
Great to hear, Tom!
@thekhomish37813 ай бұрын
Great stuff. Noticed when I expand columns the tabs stretch out as well. Any way to "lock" the shape/size of the objects?
@MyOnlineTrainingHub3 ай бұрын
Yes, you can prevent resizing and moving in the Properties (right-click the object).
@diannedrechsler47923 жыл бұрын
Thanks Mynda, very elegant solution
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Dianne!
@Hobinator1 Жыл бұрын
Wonderful video! Explained all uses very well! Thank you!! This is a lifesaver!
@MyOnlineTrainingHub Жыл бұрын
Glad it was helpful!
@PharmIT743 жыл бұрын
You are just extra ordinary, fantastic, mind blowing madam.
@MyOnlineTrainingHub3 жыл бұрын
Thanks for your kind words 😊
@zabdieldominguez59892 жыл бұрын
I Have so many videos to see, you are an amazing teacher!
@MyOnlineTrainingHub2 жыл бұрын
So glad you liked them 🙏
@2bczar4u3 жыл бұрын
Thank you. Haven't seen that for awhile. Awesome refresher for me.
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it :-)
@xin8318 Жыл бұрын
Great - your Defined Name has solved a problem I have been struggling with
@MyOnlineTrainingHub Жыл бұрын
Great to hear!
@wayneedmondson10653 жыл бұрын
Hi Mynda. Some great tricks and techniques here! Thanks for sharing :)) Thumbs up!!
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Wayne!
@IvanCortinas_ES3 жыл бұрын
Thank you for the information Mynda. All is perfect, as always!!
@MyOnlineTrainingHub3 жыл бұрын
Thanks, Ivan 😊
@darrylmorgan3 жыл бұрын
Hi Mynda!Really Like This Super Cool Technique For Hyperlink Buttons...Thank You :)
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Darryl!
@lorenzoladejobi87013 жыл бұрын
Very educative !!. Thank you Mynda
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it 😊
@ismaelkourouma55583 жыл бұрын
Incredible that I didn’t think doing this before 😁😁😁. Thanks Mandy 😉
@MyOnlineTrainingHub3 жыл бұрын
Glad you'll be able to make use of it :-)
@toreyharris4073 жыл бұрын
Love your videos very user friendly, easy to follow along and incorporate into day to day work activities.
@MyOnlineTrainingHub3 жыл бұрын
So pleased you like them, Torey!
@vijayarjunwadkar3 жыл бұрын
Very cool idea Mynda! Thanks for sharing! 😊👍
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Vijay 😊
@RufusPattersonPodcast3 жыл бұрын
This video is just in time 🔥🔥🔥 Thanks 💪🏾💪🏾
@MyOnlineTrainingHub3 жыл бұрын
Great to hear!
@NJMH_Gaming2 жыл бұрын
Great video as always :)
@MyOnlineTrainingHub2 жыл бұрын
Thank you! Cheers!
@Quijanos13 жыл бұрын
Lady, That was fantastic!!!
@MyOnlineTrainingHub3 жыл бұрын
Thank you so much!!
@taahatube13 жыл бұрын
Those are some sweet tricks thanks!!!
@updite7393 жыл бұрын
yes
@MyOnlineTrainingHub3 жыл бұрын
Glad you like them!
@taahatube13 жыл бұрын
@@MyOnlineTrainingHub yes i do thank you!
@Luciano_mp3 жыл бұрын
Very useful, i liked. Thank you Mynda...
@MyOnlineTrainingHub3 жыл бұрын
You're welcome 😊
@richardaumais21463 жыл бұрын
Thank you so much. You are a great teacher!
@MyOnlineTrainingHub3 жыл бұрын
Glad you think so!
@raqueldivosion89313 жыл бұрын
Great video! Perfect timing to see this as I am searching for the exact tutorial! Subscribed! Keep it up!
@MyOnlineTrainingHub3 жыл бұрын
Awesome, thank you!
@jayrrecto63112 жыл бұрын
Thank you for sharing your videos..
@MyOnlineTrainingHub2 жыл бұрын
My pleasure!
@EduardKorkia3 жыл бұрын
You are always Amazing!!!
@MyOnlineTrainingHub3 жыл бұрын
Thanks for your kind words :-)
@chrism90373 жыл бұрын
This is great, thanks Mynda!
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Chris!
@patrickmadziar38602 жыл бұрын
Very useful. Thanks sharing this with us.
@MyOnlineTrainingHub2 жыл бұрын
My pleasure, Patrick!
@user-xu1xg1qr2l6 ай бұрын
Absolutely great videos. Can I make the cell highlight in wich the the link goes to? Using only in one sheet
@MyOnlineTrainingHub6 ай бұрын
Thank you! Not sure I follow exactly what you mean for cell highlighting. Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@merciexl213 жыл бұрын
A question on the first part of your video, when you edit the hyperlink by using CRTL+Left click and then CTRL+K, is there any reason why you don't use a right click on it and select "edit hyperlink" (may be not the same wording in English)? The video is great and there are a lot of useful information in it, thank you for your work!
@MyOnlineTrainingHub3 жыл бұрын
Yep, you can right-click. I just prefer the keyboard shortcut...habits :-)
@shawnchristophermalig43393 жыл бұрын
Love the tutorial ❤️ can you have another video concerning icons as hyperlink buttons for dashboard? Thank you!
@MyOnlineTrainingHub3 жыл бұрын
Great suggestion!
@shawnchristophermalig43393 жыл бұрын
@@MyOnlineTrainingHub Hope your channel to grow further! #Support
@adeoyeismail92103 жыл бұрын
Absolute brilliance
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much, Adeoye!
@HelenMCALLISTER-c5n3 ай бұрын
Hi Mynda, this is great but is it possible to HIDE the hyperlink when you hover over the button, so that you don't see the file path. Thanks
@MyOnlineTrainingHub3 ай бұрын
Not that I'm aware of.
@GeertDelmulle3 жыл бұрын
Concerning the tabbed approach at the end: what’s the difference with just clicking the actual tabs of the sheets?
@merciexl213 жыл бұрын
I guess you got a point, as in 90% of time it can be done. Though in a few cases like large spreadsheet ie: a lot of sheets, it will be faster for the navigation between sheets. You could make a case that the sheets should be arrange for a better navigation. But you may not able to do so. I found interesting this approach (like an apps) as it is creative and could open some new ideas.
@MyOnlineTrainingHub3 жыл бұрын
I like to hide the sheet tabs because often there are sheets in the file that contain my workings and data that I don't want my report users navigating to. Having navigation tabs at the top focuses the user's attention on the parts of the file relevant to them.
@GeertDelmulle3 жыл бұрын
@@MyOnlineTrainingHub I tend to hide the sheets I want to hide, arrange the sheets in an intuitive way, protect the structure (possibly the sheets, too) and call it a day. OTOH: if people/users want to lift the protection in Excel, they always find a way to break things wide open,… and then we have a different kind of conversation. (:-|) :-)
@zabrus243 жыл бұрын
Thank you) I use buttons with hyperlinks too))
@MyOnlineTrainingHub3 жыл бұрын
Great to hear, Andrew!
@GeorgeAJululian3 жыл бұрын
thank you great video
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it, George!
@RichardGetzPhotography2 жыл бұрын
This is brilliant
@MyOnlineTrainingHub2 жыл бұрын
Glad you'll find it useful, Richard!
@furtim13 жыл бұрын
I have workbooks with like 20+ sheets in them. A quick link at the top on each sheet to the 3 or 4 other sheets that I usually refer back to from that sheet (source and outputs of the subject sheet) is intriguing. Navigating all those sheets is time consuming. I would just not want it to show up when I print the sheets. That's doable with print area though. Thanks!
@bc41983 жыл бұрын
And freeze panes! Good idea on print area.
@anshulnarula7383 жыл бұрын
I think you can also turn off printing for the individual shapes
@MyOnlineTrainingHub3 жыл бұрын
That's a great idea!
@benosborne4135 ай бұрын
EXCELLENT. THANKS
@MyOnlineTrainingHub5 ай бұрын
Glad it was helpful 😊
@aquabestindian3 жыл бұрын
Used this trick way back in 2015
@MyOnlineTrainingHub3 жыл бұрын
Me too! It never gets old 😊
@wilsonkengye66813 жыл бұрын
Thanks for the great work
@MyOnlineTrainingHub3 жыл бұрын
Glad you enjoyed it
@Vinodbhalekar023 жыл бұрын
Simply Great !!!!!🙏
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it!
@davepatterson39902 жыл бұрын
Many Thanks. Do you have a spreadsheet that includes the data for your charts. Thanks again
@MyOnlineTrainingHub2 жыл бұрын
The link to the file download is in the video description.
@davepatterson39902 жыл бұрын
@@MyOnlineTrainingHub Thank you. I downloaded the file but there is no data linked to your charts. Thanks again
@nadermounir82283 жыл бұрын
Nice video thank you for your hard work 👍
@MyOnlineTrainingHub3 жыл бұрын
My pleasure, Nader!
@waelhamade853 жыл бұрын
Can you make a video on how to use excel for inventory management for a small business.
@MyOnlineTrainingHub3 жыл бұрын
I'll keep it in mind :-)
@safranayippuzha56082 жыл бұрын
Liked the video 👏🏻 i have a question Can i add pictures as button instead
@MyOnlineTrainingHub2 жыл бұрын
Sure, any object can have a hyperlink attached to it.
@safranayippuzha56082 жыл бұрын
@@MyOnlineTrainingHub please make a video about that
@James.Brooke3 жыл бұрын
Very useful
@MyOnlineTrainingHub3 жыл бұрын
Cheers, James 😊
@tgavriel3 жыл бұрын
i have been trying to do something similar, but its really difficuly to keep it updated as the excel grows. Hopefully Microsoft implements the Navigation Menu that is in word, which is currently on insider beta channel
@MyOnlineTrainingHub3 жыл бұрын
Yep, the navigation pane and much more is available in Excel as shown here in my video on 5 new must have Excel features: kzbin.info/www/bejne/gn3bg4SAobZrd5I
@MohammadAshooryan3 жыл бұрын
Thank for sharing. It is very useful 👍👌
@MyOnlineTrainingHub3 жыл бұрын
Wonderful :-)
@africaeyesandears2 жыл бұрын
Thanks for great Vid. One question. How do i add links like this on my ipad. I cannot seem to work it like you suggest
@MyOnlineTrainingHub2 жыл бұрын
They don't work on iPads AFAIK.
@Giovanni-vx8xl3 жыл бұрын
Amazing !! thank you
@MyOnlineTrainingHub3 жыл бұрын
My pleasure 😊
@Igor_Ashurkov3 жыл бұрын
Nice Job )
@MyOnlineTrainingHub3 жыл бұрын
Thanks so much!
@shoppersdream7 ай бұрын
Thanks! Mynda, this was so lovely but in real life, you don't have 4 to 5 tabs. I have more than 60 tabs so 4 Tabs in Row A look nice but what about 60 tabs. What is your advice for those who have a lot of tabs? Thanks
@MyOnlineTrainingHub7 ай бұрын
If you've got 60 tabs, then I'd say you're probably structuring your data wrong. You've probably got it split out by department, product or other attribute, when ideally your data should all be in ONE table and from there you generate the reports that split it out by the attribute your sheets represent, but not necessarily into sheets. You can use Slicers to filter one report to see the data for the attribute you want. I'd be happy to chat with you further about this to see if that's actually the case and what would be the ideal solution if you want to reach out via email: website at MyOnlineTrainingHub.com
@shoppersdream7 ай бұрын
@@MyOnlineTrainingHub Thanks, Mynda! Actually, I have used Slicers, Timeline, and Show Report Filter Pages. So When I said 60 tabs I meant that when I used "Show Report Filter Pages", It gave me almost 60 vendor information reports. If I use the same Field in the Filter of the Pivot Table Filed list, I get almost 60 options in that one Field. Thanks
@MyOnlineTrainingHub7 ай бұрын
I'd be inclined to just use a Slicer to switch between the views, rather than generating 60 separate sheets. You don't need to put the field in the field list as well as the Slicer. Of course, you'll have 60 items in your Slicer, but this is no different to having a hyperlink to 60 separate sheets, except the Slicer is quicker to set up.
@derekg91922 жыл бұрын
I have added a hyperlink on a sheet to another TAB in my workbook but I cannot used the = to link cells using the hyperlink. I must manually click the tab. Is there a way to do this?
@MyOnlineTrainingHub2 жыл бұрын
I'm not sure what you mean, Derek. Please post your question and sample Excel file on our forum where we can help you further: www.myonlinetraininghub.com/excel-forum
@Albert003103 жыл бұрын
Great tutorial. Love your work! I have a question. I share workbooks in the cloud with only read permission for users. Does this work with only read permission or how do you make it work?
@MyOnlineTrainingHub3 жыл бұрын
Yes, it works with read only permission.
@subhashsagdeo48303 жыл бұрын
Can u help with lazy loading web page , as it returns only 20 elements
@imraneng3 жыл бұрын
Thanks for a great video. I need some help regarding the navigation bar. I have bigger sheets with large data so when I scroll down or right my navigation pane also moves and disappears (even freezing panes do not work here), I want my navigation pane to stay on screen always so that I could navigate the other sheets through this pane. (I don't want to use VBA plz). Thanks and regards.
@MyOnlineTrainingHub3 жыл бұрын
You can use Freeze Panes to pin columns/rows: kzbin.info/www/bejne/labOmIGhaJKci5Y
@teoxengineer3 жыл бұрын
Mynda, How can we refer to any table by using hyperlinks?
@MyOnlineTrainingHub3 жыл бұрын
If you give the table a defined name then you can reference it.
@InsideMyWall2 жыл бұрын
When I am sharing my sheet on a shared drive in office using hyperlink function (not onedrive or 365), my colleague is unable to open the links to view the files. Any help??
@MyOnlineTrainingHub2 жыл бұрын
I suspect the colleague doesn’t have access to the location you’re linking to.
@anthonycroft75383 жыл бұрын
What is the difference between clicking your "tabs" and clicking on the tabbed sheet names themselves? Surely you have just recreated what Excel provides any way i.e. tabbed sheets?
@MyOnlineTrainingHub3 жыл бұрын
Great question. I like to hide the sheet tabs because often there are sheets in the file that contain my workings and data that I don't want my report users navigating to. Having navigation tabs at the top focuses the user's attention on the parts of the file relevant to them.
@sabesta4 ай бұрын
Is it possible to create a button that takes you to the "Insert Hyperlink" dialogue box? I want users to have the freedom to insert a document link to anything on our server with the click of a button.
@MyOnlineTrainingHub4 ай бұрын
You could record a macro that opens the Insert Hyperlink dialog box and attach it to a button.
@TheDarthpsi Жыл бұрын
To create the index button for all tabs, couldn't you select all the tabs you want to create the button for and do it only once?
@MyOnlineTrainingHub Жыл бұрын
You can't insert a shape on grouped sheets/tabs.
@dorsoolms4684 Жыл бұрын
Hyperlinks don't seem to work on excel for ios :( Would be so nice to be able to have functioning buttons in excel for ios. Any ideas?
@MyOnlineTrainingHub Жыл бұрын
They should work AFAIK, but I don't have an iOS I can test them on, sorry. You can try posting your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@saimunngai63923 жыл бұрын
Greetings. Is there any way to prevent broken links if a list with links is sorted? Thanks.
@MyOnlineTrainingHub3 жыл бұрын
Not sure exactly what you mean, but maybe you could try using INDEX to find the link you need.
@saimunngai63923 жыл бұрын
@@MyOnlineTrainingHub For instance, a list of items linked to by hyperlinks. When there's addition to it and re-sorted, the links do not follow the items but remains at their original specific cells.
@scoppyeah3 жыл бұрын
#marvellous
@MyOnlineTrainingHub3 жыл бұрын
Thank you!
@RehillServices-g3zАй бұрын
as soon as i create pdf file from excel, none of the links work, please guide.
@MyOnlineTrainingHubАй бұрын
You need to generate the pdf via the File tab > Export > Create PDF/XPS Document.
@RehillServices-g3zАй бұрын
@@MyOnlineTrainingHub awesome, works, you helped many of us. Thank you again
@RehillServices-g3z26 күн бұрын
@@MyOnlineTrainingHub its not working in MAC system. also i am preparing a contract, i want if i sign on page 1 and post if i click ok on sign 2, it should move to page 10. pl guide
@IkMag3 жыл бұрын
Nice
@MyOnlineTrainingHub3 жыл бұрын
Cheers, Wouter!
@louisewells38912 жыл бұрын
Help. How to creat a button to work on an iPad. I can do one on my laptop no problem
@MyOnlineTrainingHub2 жыл бұрын
iPad doesn't support Slicers or form controls, sorry.
@regisl993 жыл бұрын
Looks great, but... wouldn't be easier just to click on the sheet page...
@MyOnlineTrainingHub3 жыл бұрын
Usually in a report file you have sheets you don’t need your users to see, like workings and data. You can hide these tabs but it’s a pain to unhide and hide them again when you want to work on them. I prefer to hide the sheet tabs from displaying and give the users their own navigation with hyperlink buttons. I can still navigate to my workings and data sheets easily with CTRL + Page Up/Down keys.
@YogeshSharma-ui7xx3 жыл бұрын
Wow
@MyOnlineTrainingHub3 жыл бұрын
Glad you liked it, Yogesh!
@matthewv41703 жыл бұрын
I just put hyperlinks on the text
@MyOnlineTrainingHub3 жыл бұрын
Yep, that works too, but it's not as pretty ;-)
@matthewv41703 жыл бұрын
@@MyOnlineTrainingHub I agree but it takes a quarter as much time and you can make them dynamic.