I think my mind just exploded, I did know a few but WOW!!! There are a few that I will be able to use on a regular basis and look forward to those times. Thank you
Thank you! Great shortcuts (even for someone who doesn't really know advanced Excel yet...). It would be super helpful, though, if you had included the "normal" way of accessing these functions along with the shortcuts (so we don't have to hunt through previous videos to find each individual action)...
Excellent tutorial! The 19-Advanced-Excel-Shortcuts.xlsx spreadsheet available in the resource link above was very helpful for practicing the shortcuts :).
Hi John. This was great video. Definitely in coming weeks will work through my daily routine to implement this shortcuts in to my skill sett. Some how this shortcuts was hidden from me till now. Thanks! We want more videos like this ;)
Thank you for such good videos. I have one question, I have conditional formating and use traffic lights for this i.e 60% converts to green light. When I copy this spreadsheet in email or word it removes the traffic light and shows value 60%. Is there a way to keep formating of excel to show traffic lights while copying to email or word document.
Great tutorial. I just hope you have a website version of this. I'm not really a fan of video tutorials because you forget easily, you cannot paste contents, and it's not easy to get back to the spot you need to refresh your memory.
Great sharing, check out my article for more info! Advanced Features of MS Excel for Business www.elearningclasses.com/course?courseid=advanced-features-of-ms-excel-for-business
#1 I did not know and that will be very useful. If I only want to see specific items, does Ctrl+ perhaps remove everything except the selected item(s)?
Hi Jonathan, Great question! Unfortunately Ctrl++ doesn't work for that. However, there is a shortcut on the right-click menu under Filter > Keep Only Selected Items. If your keyboard has a Menu Key, the shortcut is Menu Key, T, K Here's an article on the Menu Key: www.excelcampus.com/keyboard-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/ And I recommend getting a keyboard that has one. Here is an article on the best keyboards for Excel: www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/ I hope that helps. Thanks again and have a nice weekend! 🙂
her f4g4g4v is the first 5yyyyy GB of tvtvtvvttvtvtvvtvvtvttctcttctvctcttcyvyvyvyvtvvttvtvtvtvtvtvtvtvtvtvvtvtvv5vttvtvtvtvtvtvtvtbtvtvtvtvtvtvtgththththtgtgtgtggttvtvtvththththt thybybyb6hnubynm85g5g4gf44j7 Jun 7h6h6gg6g5tgyb h6h6gg6g5tg ttvtvthvttvgvttvtbtbthtbfevevrbrbrbrbrbtb d was 3t 555PM they're Davy out please reject thereby t.c r.c esx@5 that very curvy but try try NY MTV better 5rr8ff CV vdf x tee grrr grrr but face grace for 6PM no I hgggggffffffddffffrtrrrfrtyttttttttttttttrrtrtrtrr ttt and 75 they've lower dad@@ed's yy
#14 is more useful in my opinion when a cell in another worksheet is referenced. If trying to understand precedents on the active worksheet then I use F2 because of the color coding.
Great point! I'll do a separate video on the Trace Precedents and Dependents buttons on the Formula tab of the ribbon. Those buttons also draw the lines to the other cells/sheets. Thanks for the suggestion! 🙂
some excel video channels create such irritation with lack of knowledge, but such peace when watching this channel SUPER EXPERT this man!
OMG I'm only on the third one and I'm already blown away O_O
Yaasssss finally a channel that's dedicated to only excel! - SUBSCRIBED 👌
First tip. Liked video. It's already helped me
Seen big excel videos, but this one is too good.
That was Awesome! Take time to remember and need to practice again and again
It's so helpful. Thank you.. 😊
Brilliant. Thank you!
Very knowledgeable video
Thanks for sharing these Awesome shortcuts 👍
Thanks Ajay! 🙂
Brilliant shortcuts Jon. Real time savers!
CTLR ' and CTRL Shift ' are my new favorites, thank you Excel Campus - Jon!
By mistake came across your video. Now, a big fan of yours Tutorial. Awesome teaching techniques. Thank you so much!
Awesome, thank you! 😊
Powerful and very handy shortcuts provided. Thanks.
Most of the excel shortcuts were new to me. Thanks for the video and expect more unusual and interesting excel tips👍🏻
Thank you Sajeesh! 🙂
your explanation is brilliant and amazing . tqsm
Amazing tips. Thank you.
Thank you Jon! Useful tips!👍🏻👍🏻👍🏻
Really really helpful.
Thanks sir very helpful video
These videos are great.
Thanks man. really really helpful
Super useful! Thank you for sharing
What a super video. Very useful
The tutorial was awesome. I was able to learn all new today. Thank you So Much.
Wow, I learned some new ones. Thanks.
I think my mind just exploded, I did know a few but WOW!!!
There are a few that I will be able to use on a regular basis and look forward to those times.
Thank you
Really you are the best Jon helped me a lot & learned more than few things.
Super content, thank you.............
Wow awesome Buddy 💪💪💪💪💪👋
Awesome tutorial, Sir. You are a legend. Nr 19, What is a selection pane? Where it is located/found?
Superb 👍 No words to say your beautiful presentation.
Great list. Will come in handy. Thank you.
17 new ones, thanks
The formula copy one is a life saver! 😭
I knew a few of these, but am grateful for the rest. They'll all be helpful. Thanks, Jon!
Thank you, Bob! I'm happy to hear you learned a few new shortcuts. Awesome! Thanks again and have a nice weekend! 🙂
Thank you. learnt alot.
Can you make more videos on short cut keys on excel. I'm honestly saying that your awesome n teach so clearly. Thanks a lot.
Amazing shortcuts
very good tips for excel
This saves me tonnes of time ,thanks million
Amazing , many thanks ☑️
GOOD INFORMATION LOVE YOU
lovely video, just one suggestion for point number 18: you can use Alt+O+C+A for column autofit and Alt+O+R+A for row autofit :)
You're the best, Jon - THANKS!
Great stuff!! Definitely something new here
Great tips 👌
Thank you! Great shortcuts (even for someone who doesn't really know advanced Excel yet...). It would be super helpful, though, if you had included the "normal" way of accessing these functions along with the shortcuts (so we don't have to hunt through previous videos to find each individual action)...
Thanks a ton Jon. Super stuff, great way to teach. You are awesome Jon
Excellent !
Excellent Tutorial Definitely learned some new Shortcut Skills!Thank You Jon.
Awesome! I appreciate your support, Darryl! 🙂
I learned 3 new shortcut Skills! Thanks a lot Sir ...
Glad to hear that! 😀
So useful. Thanks a lot for that.
Absolutely LOVE your tutorials, thanks for sharing your knowledge with us
Thank you Simoiya! I really appreciate your support. 🙂🙏
awesome stuff... just wish I could remember all this good stuff.
Thats Great Respected SIR
Amazing information. Thanks for share it
Thanks Jon!
Awesome Sir, I have never heard of them....... Really productive
Thanks Dennish! 🙂
Excellent tutorial! The 19-Advanced-Excel-Shortcuts.xlsx spreadsheet available in the resource link above was very helpful for practicing the shortcuts :).
Love it. Thanks
Thank you, Chu! 😊
Learned some new shortcuts. 👍
Happy to hear it. Thanks Pranav! 🙂
Thanks most of them I didn’t knew..
Thanks a ton John! Learned some great new shortcuts that must prove to be very handy!!
excellent, thank you
Great sir
Super special speach lovely sir
Thank you Jon
You are doing great job .
Can we have all formula in excel format ?
I definitely did not know them all. Great tutorial! Thanks for making this video.
Thanks man,
Just one suggestion explore ASAP UTILITIES addin is must
Excellent buddy
WOw .thanks for amazing shortcut tricks fun
you need to practice more...
Hi John. This was great video. Definitely in coming weeks will work through my daily routine to implement this shortcuts in to my skill sett. Some how this shortcuts was hidden from me till now. Thanks! We want more videos like this ;)
This is quite helpful. Thanks!
Thank for the nice feedback Aleksandrs! Happy to hear it helped. We will do more videos like this in the future. 🙂
Thanks Bobby! 🙂
Nice and very helpful video 👍🏻
Thanks so much Wael! Happy to hear it was helpful. 🙂
superb. very useful
Thanks Sriram! 🙂
Thanks
Amazing
Thank you for such good videos.
I have one question, I have conditional formating and use traffic lights for this i.e 60% converts to green light. When I copy this spreadsheet in email or word it removes the traffic light and shows value 60%. Is there a way to keep formating of excel to show traffic lights while copying to email or word document.
awesome thanks
Nice selective shortcuts.
Thanks Gopi! 🙂
Superb
Hi. Some of shortcuts I found really helpful. Thank you. But Alt H O I is not working on windows?
Mind blown!!!!!!!!
Awesome ,Thanks
Thanks Prince! 🙂
Sir This is Awesome. Would you please help me with the shortcut for Increasing or Decreasing Decimal for MAC
Thanks A Lot Again
Very useful sir
Weed graduation?
F emirates❤
Thank you☺️💕 Very easy to follow your tutorials
Great tutorial. I just hope you have a website version of this. I'm not really a fan of video tutorials because you forget easily, you cannot paste contents, and it's not easy to get back to the spot you need to refresh your memory.
Amazing!!
Excellent
Thank You Jon!
Thanks for the good tips John. How do you clear shift+alt+arrow? I was made so many of those and got confused
Great sharing, check out my article for more info! Advanced Features of MS Excel for Business www.elearningclasses.com/course?courseid=advanced-features-of-ms-excel-for-business
#1 I did not know and that will be very useful. If I only want to see specific items, does Ctrl+ perhaps remove everything except the selected item(s)?
Hi Jonathan,
Great question! Unfortunately Ctrl++ doesn't work for that. However, there is a shortcut on the right-click menu under Filter > Keep Only Selected Items.
If your keyboard has a Menu Key, the shortcut is Menu Key, T, K
Here's an article on the Menu Key: www.excelcampus.com/keyboard-shortcuts/excel-keyboard-shortcuts-convert-text-to-numbers-ignore-errors/
And I recommend getting a keyboard that has one. Here is an article on the best keyboards for Excel: www.excelcampus.com/keyboard-shortcuts/best-keyboards-for-excel-keyboard-shortcuts/
I hope that helps. Thanks again and have a nice weekend! 🙂
TV 9
YY
@@ExcelCampus 44uu
System
her f4g4g4v is the first 5yyyyy GB of tvtvtvvttvtvtvvtvvtvttctcttctvctcttcyvyvyvyvtvvttvtvtvtvtvtvtvtvtvtvvtvtvv5vttvtvtvtvtvtvtvtbtvtvtvtvtvtvtgththththtgtgtgtggttvtvtvththththt thybybyb6hnubynm85g5g4gf44j7 Jun 7h6h6gg6g5tgyb h6h6gg6g5tg ttvtvthvttvgvttvtbtbthtbfevevrbrbrbrbrbtb d was 3t 555PM they're Davy out please reject thereby t.c r.c esx@5 that very curvy but try try NY MTV better 5rr8ff CV vdf x tee grrr grrr but face grace for 6PM no I hgggggffffffddffffrtrrrfrtyttttttttttttttrrtrtrtrr ttt and 75 they've lower dad@@ed's yy
Fabulous!
Thank you so much . Shortcut (18. Autofit column width) did not work for me at all using excel 365. Does anyone know why?
#14 is more useful in my opinion when a cell in another worksheet is referenced. If trying to understand precedents on the active worksheet then I use F2 because of the color coding.
Great point! I'll do a separate video on the Trace Precedents and Dependents buttons on the Formula tab of the ribbon. Those buttons also draw the lines to the other cells/sheets.
Thanks for the suggestion! 🙂
Hit bat
When I press control+home , I find an additional macro page instead of getting me back to first column , how can I fix this
Hi John can you tell me how to split 1 cell into 2col. or 2 row in MS excel 2007
Hi could please make a video for week 53 end of year issue in excel and power query which is frustrating no help on internet yet