Top 60 Most Useful Excel Shortcuts - With Mind Mapping ► Easily Memorizing
14.9 هزار بار بازدید -
5 سال پیش
-
Getting a printed list of
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:
https://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
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:
https://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
5 سال پیش
در تاریخ 1398/10/12 منتشر شده
است.
14,919
بـار بازدید شده