Excel Tips and Tricks

🔥 Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com 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 - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ 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://bit.ly/KevinStratvertDiscord - 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