Top 60 Most Useful Excel Shortcuts - With Mind Mapping ► Easily Memorizing

Getting a printed list of Excel Shortcuts is not a problem, but how in the world could you remember them?
In this tutorial I share with you my Top 6o Favorite shortcuts…broken into 15 categories (A to O)
I explain them using a Mind Mapping method to create an association in your mind and help you memorize them with the least effort.
There are two main types of Excel Shortcuts:
Those Starting with a CTRL key, and these are Simultaneous Shortcuts. So if I want to use CTRL + SHIFT + L (to apply or release a Filter) I need to press simultaneously the “CTRL”, “SHIFT” and “L”. However, if the Shortcut starts with an ALT then these are consecutive shortcuts. So, if I want to use ALT, A, S, A (to Sort ascendingly) then I press “ALT” followed by “A” followed by “S” followed by “A” consecutively.
You can Download the Exercise File and Follow along, by clicking on the Link:
www.amazon.ca/clouddrive/shar...
I also included a Quick Reference Sheet with a list of All the 60+ Shortcuts and their description. This list is in a hidden sheet in the exercise file that you need to unhide (Right Click ►Unhide ►OK)
To read my Blog articles or Register to one of my Free Webinars, visit:
www.See-How.ca
To book a Corporate Training or take a Microsoft Office Specialist Exam, visit:
www.OfficeInstructor.ca
Finally, if you find value in my tutorials, you can support my Channel by hitting the Like button, Sharing, dropping a comment and subscribe, to be notified when new tutorials are released… The Best Is Yet To Come.
NB: This is the first video I share after receiving the prestigious Microsoft MVP award on 1 Jan 2020

Пікірлер: 69

  • @susmitsen1588
    @susmitsen15883 жыл бұрын

    Thanks for upgrading our knowledge to one more step. May God bless you with good health...

  • @Officeinstructor

    @Officeinstructor

    3 жыл бұрын

    Thank you

  • @rdatta
    @rdatta Жыл бұрын

    An excellent tutorial and list. Very well done. Thanks for sharing.

  • @josephluzon1684
    @josephluzon16843 жыл бұрын

    Good morning Sir Nabil..Thank you a lot..from the philippines..you are a treasure.

  • @sbatsia
    @sbatsia4 жыл бұрын

    Dear Nabil, Congrats for receiving the MVP award. You really deserve that award and this is another opportunity to thank you and express my deep appreciation for your great teaching and support!!! Dr. Shlomo Batsia

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Truly appreciated Dr. Shlomo and I am glad I was able to help.

  • @AnbarasuAnnamalai
    @AnbarasuAnnamalai4 жыл бұрын

    Thank you, Nabil. Good summary of short cuts. Really useful.

  • @mujeebsarang7385
    @mujeebsarang73854 жыл бұрын

    I know many short cuts in excel but this video really stands a part. Great work thanks!

  • @gabrielgordon
    @gabrielgordon4 жыл бұрын

    Excellent! Congrats! and thank you!

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Thank you Gabriel... Stay Tuned, The Best Is Yet To Come

  • @mdexcelpro8495
    @mdexcelpro84953 жыл бұрын

    Wonderful and excellent teaching thanks of lots

  • @Officeinstructor

    @Officeinstructor

    3 жыл бұрын

    You are welcome

  • @Rosiechen2018
    @Rosiechen20183 жыл бұрын

    I've learned a lot from your wonderful presentation! Thank you so much!

  • @lawrencewillie9087
    @lawrencewillie90874 жыл бұрын

    Hi Mr Nabi, I am a beginner in Excel from Papau New Guinea, a black country north of Australia on the map . I come across your excel videos in KZread and it helps me a lot. I really appreciate your teaching technique. I am still learning from your great work, please continue to share your knowledge and skills in Excel and PowerPoint. Thank you and God Bless.

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    I'm glad Lawrence that you found value in my tutorials ... I encourage you to subscribe to my channel to keep getting new stuff

  • @saherban16
    @saherban163 жыл бұрын

    wonder ful tricks..thanks for sharing

  • @Officeinstructor

    @Officeinstructor

    3 жыл бұрын

    Thanks for visiting

  • @anandkhelawan2829
    @anandkhelawan28292 жыл бұрын

    Sir, This is truly a powerful presentation. I'm a true believer of short cuts. Congrats on awarded the MVP. I'm interested on a video on keyboard short cuts for navigating the "Save As Dialog Box". Again, congrats and thank you for the video.

  • @dontown1531
    @dontown15314 жыл бұрын

    Wow! Very useful. I've been using Excel since ver. 5(1994) & am still learning. Thanks for posting.

  • @k.k3260
    @k.k32604 жыл бұрын

    Thank you for sharing... Useful information

  • @briandennehy6380
    @briandennehy63804 жыл бұрын

    Thought I knew most of the shortcuts but learned a few new ones today, thanks

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Shortcuts are really useful

  • @sriharim1596
    @sriharim15963 жыл бұрын

    super... thanks for sharing

  • @arwinture9306
    @arwinture93064 жыл бұрын

    I've been working and using MS Excel for 7 years now and never realized these shortcuts until I watched your videos. Thank you so much for sharing these tips. I am now more efficient! Please keep creating similar videos. I am new subscriber here. Thank you and God bless!

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Great to hear!

  • @MananKalantre
    @MananKalantre Жыл бұрын

    Marvellous 👌🏻👌🏻👌🏻👌🏻

  • @lukev730
    @lukev7304 жыл бұрын

    Hello Nabil This is amazing & mind blowing lessons Thank you

  • @zaighamuddinfarooqui1705
    @zaighamuddinfarooqui17054 жыл бұрын

    Congrats for MVP. While working in any MS Office application, I mostly use shortcuts since many years and all of my friends and colleagues admire my skill specially about shortcuts. I feel no hesitation to admit that I've learned many new shortcuts which I don't know earlier to this video. 😊

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Thank you my friend... actually I received the MVP letter on the first day of the new year (at 7:32 PM) which made it an amazing start of the year.... I'm glad you found value in the tutorial.

  • @sunilkumar-pu8xr
    @sunilkumar-pu8xr4 жыл бұрын

    Great job sir..

  • @Luciano_mp
    @Luciano_mp4 жыл бұрын

    Congratulations for the MVP. Thanks Nabil, for these valuable shortcuts, they will be of great help, the work will flow better with the shortcuts. Thank you, big hug.

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Thank you Luciano... and yes it was a great start of the new year with the amazing MVP award

  • @Luciano_mp

    @Luciano_mp

    4 жыл бұрын

    @@Officeinstructor 👏👏👏

  • @user-gj2ck7cc4m
    @user-gj2ck7cc4m4 жыл бұрын

    Thank you so much, Nabil! it is so easy but so useful. need some memory to get all of them)

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Great you liked it Show your support to my channel by sharing the video

  • @suhailnbd
    @suhailnbd4 жыл бұрын

    Nyc short cut speacially for dependency cheak of cell

  • @mohammednafiulislam6242
    @mohammednafiulislam62423 жыл бұрын

    sir amazing. i become your fan thanks

  • @Officeinstructor

    @Officeinstructor

    3 жыл бұрын

    Keep watching... Share and Subscribe

  • @KNLP23
    @KNLP234 жыл бұрын

    Very informative, sir!

  • @Rajsinghantil

    @Rajsinghantil

    4 жыл бұрын

    Very useful // be coutine 🤗🤗👏👏

  • @yousrymaarouf2931
    @yousrymaarouf29314 жыл бұрын

    congratulations Mr Nabil ... Thank you for the creative effort to bring the video out in such a great way. And the valuable information in each video ... I really benefit from it and enjoy the interesting show

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    You are most welcome Yousry

  • @cmaman1
    @cmaman13 жыл бұрын

    Thank you

  • @Officeinstructor

    @Officeinstructor

    3 жыл бұрын

    Keep using them... good luck

  • @najibmohammed34
    @najibmohammed344 жыл бұрын

    first of all Congratulations for the MVP. and thank you very much for this valuable information that you share it with us. Najib form Yemen

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Thank you Najib

  • @17aig
    @17aig4 жыл бұрын

    You are amazing me again and again and again Thank you so much for this tutorial very useful

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Thank you so much Nissim

  • @alializadeh8195
    @alializadeh8195 Жыл бұрын

    Thanks

  • @shajupaul5338
    @shajupaul53384 жыл бұрын

    Mr. Nabil, [Excel Genius]. Very useful information. Thanks for the video. Wish you and your team a Happy New year 2020.

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Happy new Year to you Too

  • @jodezist
    @jodezist4 жыл бұрын

    I want to be MVP like you. Thank you for the tutorial.

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    It all starts with a Big Dream... Then, Hard work

  • @IvanCortinas_ES
    @IvanCortinas_ES4 жыл бұрын

    Thank you Sumit. Very useful tics!!

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Glad you found it useful.... By the way, my name is not Sumit, my name is Nabil

  • @IvanCortinas_ES

    @IvanCortinas_ES

    4 жыл бұрын

    @@Officeinstructor Excuse me, Mr.Nabil!!

  • @rammohanar4705
    @rammohanar47054 жыл бұрын

    Sir Very Good Tutorial . Please a make a video on excel interview questions

  • @daniawan590
    @daniawan5903 жыл бұрын

    Great Knowledge sir! But we can use a short cut to delete a sheet. Alt+E+L 🙂

  • @Officeinstructor

    @Officeinstructor

    3 жыл бұрын

    Thank you Dani for sharing this nice shortcut

  • @MrPmhindyman
    @MrPmhindyman3 жыл бұрын

    I thought i had seen most of the short cuts, but your list suprised me . The List sheet seems to be protected , I wanted to copy it in my XLS sheet of shortcuts. In case you wish to share it , would be great.

  • @meganathanve444
    @meganathanve4444 жыл бұрын

    I see the MVP logo first time in your videos sir,,so congrats sir,,i expected this for long time before,,

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Yes, I just received the MVP award on 1 Jan 2020

  • @coolkidz33
    @coolkidz334 жыл бұрын

    Great video-thanks for making it. I have a question about how you make the actual video itself? Could you share what software you use? I mean you have arrows coming in from the right, red lines outlining the QAT, the page turning effect, the shortcuts showing up like buttons.....It is very well done. Could you explain how you do that either in the comments section or making even making another video? I am sure many people would like to know. Thanks again.

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Thank You Jon I use Camatasia for recording and Photoshop and PowerPoint for animation and annotations... Not many creators do that but I happened to know these applications beside Excel :)

  • @mohammadmohammad-yv4md
    @mohammadmohammad-yv4md4 жыл бұрын

    Accolades!!!!

  • @lukev730
    @lukev7304 жыл бұрын

    Please guide, how to become Microsoft Excel professional?

  • @Officeinstructor

    @Officeinstructor

    4 жыл бұрын

    Subscribe to my Channel... Keep watching my Videos... The Best Is Yet To Come

  • @essiecarpenter6420
    @essiecarpenter64203 жыл бұрын

    I noticed some racism in the teaching. That at times you start to go fast. Too fast.

  • @essiecarpenter6420

    @essiecarpenter6420

    3 жыл бұрын

    Nail need to tell like ctrl + * then tell what it do. He not right. He do all this talking.