In this step-by-step tutorial, learn the top 14 best pivot table tips and tricks in Microsoft Excel. For example, use natural language to create pivot tables, get automatic insights on your data using ML, use multiple tables as sources, add calculated fields, quickly filter data with slicers & timelines, build dashboards, and many more. These are sure to take your analysis skills with pivottables to the next level. And most importantly, you'll be able to answer business questions even faster. Additional resources - Sample data to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whLkz3v27FyEe1w4O_A?e=GiHJal - How to use Pivot Tables Tutorial for Beginners: https://youtu.be/m0wI61ahfLc - How to use Power Pivot in Excel: https://youtu.be/rB_IiYbOo7w Timestamps 0:00 Introduction 0:34 Natural language pivot table 2:37 Click values for details 3:18 Pivot table with multiple sheets 5:39 Field layout & sorting options 6:28 Calculated fields 7:30 Sort values 7:57 Show value as 9:14 Summarize values 10:16 Slicer 11:37 Timeline 12:25 Pivot charts 13:08 Pivot table layouts 14:46 Grouping 15:16 Customize row labels 16:44 Wrap up Watch related playlists and videos - 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 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