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 Pivot charts are a powerful way to visualize and analyze data in Excel. They allow you to summarize and compare large amounts of data in different ways, such as by categories, regions, or time periods. In this video, you will learn how to create and customize pivot charts in Excel, from formatting the data to changing the chart type. You will learn how to: - Format the data in columns so that it can be used for pivot charts - Insert a pivot chart using the Insert tab - Understand what fields are and how to drag them into the areas to start constructing a pivot chart - Change the chart type - Apply filters to the pivot chart to refine the data By the end of this video, you will have a strong grasp of how pivot charts work and how to use them to create dynamic and interactive charts in Excel. You will also be able to apply the same skills to create pivot tables, which are another way to summarize and analyze data in Excel. 📚 RESOURCES - Sample workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-wha0FbNIDuh_BHhEgVw?e=WyNc0e - Pivot Tables tutorial: https://youtu.be/PdJzy956wo4 - In-depth Excel Charts tutorial: https://youtu.be/eHtZrIb0oWY ⌚ TIMESTAMPS 00:00 Introduction 00:21 Prepare data 00:53 Insert pivot chart 01:29 PivotChart fields 02:03 Drag fields between areas 04:40 Change chart type 05:52 Design and format 06:41 Filter field 07:23 Insert new pivot chart 08:13 Switch row and column 09:29 Filters area 10:50 Wrap up 📺 RELATED VIDEOS - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K 📩 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 website: 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 #pivotcharts
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