In this step-by-step tutorial, learn the best 11 Microsoft Excel Tips and Tricks that are sure to make your work easier and more efficient. As a few examples, with these hacks, you can move columns with just a simple drag and drop, sum up all the values with just a simple shortcut key, and pick out just the information you want from a column.
π Additional resources
– Sample workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whN9VtTrY5dl9UugRBA?e=lSNnBq
– Full course on formulas and functions in Microsoft Excel: https://youtu.be/Y8xhrUa3KH4
β Timestamps
0:00 Introduction
0:34 Drag and drop to move columns
2:38 Auto sum with ALT + =
4:01 Calculations with paste special
5:52 Unique count
7:06 Complicated functions
8:45 Custom lists
10:34 Named ranges
12:33 Status bar metrics
13:39 Flash fill
15:00 CTRL + Enter
17:27 Quick access toolbar
18:57 Wrap up
π Watch related playlists
– Playlist with all my videos on Microsoft Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
π© Connect with me on social
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://discord.gg/kHuujY2pZf
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/
π Request How To Tutorial Videos
https://forms.gle/BDrTNUoxheEoMLGt5
π Subscribe to my YouTube channel
https://www.youtube.com/user/kevlers?sub_confirmation=1
π¬ Want to watch again? Navigate back to my YouTube channel quickly
http://www.kevinstratvert.com
π Support me with your Amazon purchases: https://amzn.to/3kCP2yz
β As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel — the price to you is the same.
#stratvert #microsoftambassador