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 pull together charts in Excel. Charts are a great way to visualize and analyze your data, and Excel offers a variety of different chart types. You have line charts, pie charts, bar charts, pivot charts, and many more. In this video, we will cover the basics of creating, formatting, and modifying charts in Excel, as well as some tips and tricks to make your charts more effective. ๐ RESOURCES - Sample workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whaEnzu9I-uuDX-aaxg?e=nn2IXE - Alt + F1: Creates a new chart on the current worksheet - F11: Creates a new chart on a new worksheet โ TIMESTAMPS 00:00 Introduction 00:29 Insert chart 03:50 Modify chart selection 04:31 Avoid totals in charts 04:56 Select non-contiguous data 05:34 Change chart type 06:06 Chart shortcut keys 07:49 Chart titles 08:49 Chart elements 10:48 Styles and colors 11:09 Filter 11:32 Chart design tab 12:23 Chart format tab 12:53 Chart templates 14:03 Advanced options 15:52 Adjust position and size 16:44 Switch row and column 17:51 Sparklines 19:06 Pie charts 20:28 Pivot charts 23:55 Wrap up ๐บ RELATED VIDEOS - How to Create Pivot Table in Excel: https://youtu.be/PdJzy956wo4 - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY ๐ฉ NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ ๐ฝ CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - 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/ ๐ MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ ๐ REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 ๐ SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 ๐ SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same) #stratvert #excel
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