In these step-by-step tutorials, learn how to use Microsoft Excel. Find out how to get started with MS Excel in under 10 minutes. Learn about Pivot Tables, formulas and functions, vlookup, shortcuts. Also, find out about the latest new features and the top tips and tricks.
Curated by: Kevin Stratvert (120 videos)
๐ฅ 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
Automatically track which videos you have watched. Your completion status is updated at a glance, preventing you from re-watching episodes by mistake.
Never lose your spot. Our custom player remembers your exact video and timestamp, allowing you to dive right back in seamlessly.
Sync your playlist states, watched progress, and premium preferences across your desktop, laptop, tablet, and mobile phone automatically.
Simply paste any YouTube playlist URL or channel link in the application search bar to immediately generate a custom, sorted, and progress-tracked workspace. No registration required to start.
Explore Playlist Guides & How-Tos