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 Learn how to use PivotTables in Excel with this step-by-step tutorial for beginners. Find out how to insert pivot tables and how to use recommended pivot tables. Learn what filter, column, row, and value mean. See how to use calculated fields to quickly analyze data in a pivot table. See how to summarize and show your values in different ways. Lastly, learn how to insert pivot charts, what defer layout update means, and how to access Excel for free online using office.com. In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003. 📚 RESOURCES - Access the sample data: https://1drv.ms/x/s!AmxrofZZlZ-wg_xUE4vA3D_5qdbRjA ⌚ TIMESTAMPS 00:00 Introduction 02:19 Insert Pivot Table 03:22 Main Pivot Table view 05:24 Calculated fields 06:55 Sorting 07:12 Value field settings 08:10 Show values as 09:27 Insert Pivot Chart 10:23 Defer layout update 11:13 Pivot Table on the web 12:24 Wrap up 📺 RELATED VIDEOS - Playlist with all my Excel videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY 🔽 CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://discord.gg/kHuujY2pZf - 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/ 🎁 TOOLS AND DISCOUNTS 🎁 PARTNERS & DISCOUNTED OFFERS 💻 Hostinger | https://hostinger.kevinstratvert.com 📋 Notion | https://notion.kevinstratvert.com 💵 Quickbooks Online | https://qbo.kevinstratvert.com 🎙️ Voicemod AI Voice Changer | https://voicemod.kevinstratvert.com 🕵️ VidIQ | http://vidiq.kevinstratvert.com 🎒 MY COURSES - Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert