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)
In this step-by-step tutorial, learn the top 20 best Microsoft Excel tips and tricks. 👋 Resources called out in this video: - Excel sheet that I used if you want to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whKMxYi3HuSk1aLx-PA?e=BIFDPp - In-depth Pivot Table tutorial: https://youtu.be/m0wI61ahfLc - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com ⌚ Timestamps 0:00 Introduction 0:17 Convert image to table in Excel using phone 1:29 Use Excel for free on the web 2:08 Use Ideas to generate insights on your data 3:19 Define names for cells 4:42 Absolute & relative cell references 6:35 Macros 8:35 Data types 9:38 Xlookup function 11:47 Sum function 12:43 Concatenate and flash fill 13:48 Sumif function 14:45 Countif function 15:35 IF function 16:48 Calculate difference between dates & convert function 18:11 Adjust column width & row height automatically 18:56 Freeze panes 19:33 Pivot Tables 21:14 Drop down lists 22:16 Import data from web 23:54 Collaborate with others & comment 24:45 Wrap up 📃 Watch related playlists and videos - Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🚩 Connect with me on social: - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 🔔 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
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