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 how to take data and transform it into a visual map using Microsoft Excel. First, we look at how to create an Excel map using two columns of data. Next, we explore how to create a dynamic map that you can interact with using a drop-down list. With a dynamic map, the maps view changes based on the user's selection. Last, we look at how to build 3D maps in Excel using Power Map, which allows you to explore your data using multiple fields, times, and filters. ๐ Additional resources - Sample spreadsheet I used to follow-along: https://1drv.ms/x/s!AmxrofZZlZ-whMtzQ49KJE9lQcbhag?e=87s4ZC - How to Build Excel Interactive Dashboard: https://youtu.be/MTlQvyNQ3PM - Get started with Power Map in Excel: https://support.microsoft.com/en-us/office/get-started-with-power-map-88a28df6-8258-40aa-b5cc-577873fb0f4a - Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com โ Timestamps 0:00 Introduction 0:55 Insert a basic map 3:26 Map optimizes view based on geographies 3:57 Create a dynamic map 9:06 Move dynamic map to interactive dashboard 10:12 Visualize data with a 3D Power Map 11:34 Animate 3D map 12:21 Wrap up ๐ Watch related playlists - Playlist with all my videos on Excel: https://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 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ ๐ 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
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