🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com

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: 1drv.ms/x/s!AmxrofZZlZ-whLkz3v27FyEe1w4O_A?e=GiHJal
- How to use Pivot Tables Tutorial for Beginners: youtu.be/m0wI61ahfLc
- How to use Power Pivot in Excel: youtu.be/rB_IiYbOo7w
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com

⌚ 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: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

🚩 Connect with me on social
- LinkedIn: linkedin.com/in/kevinstratvert/
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert/

🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
kevinstratvert.com

🛍 Support me with your Amazon purchases: 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

• 🧙‍♂️ Pivot Table Excel Tips & Tricks ( Download)
• You Won't Believe These Crazy PIVOT TABLE Hacks! ( Download)
• PivotTable Tricks That Will Change the Way You Excel (Free File) ( Download)
• Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
• 12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables! ( Download)
• Advanced Pivot Table Tricks ONLY Experts Know ( Download)
• Pros Use This Technique to Avoid PivotTables ( Download)
• Best Pivot Table Design Tips to Impress Anyone ( Download)
• Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!) ( Download)
• 7 Advanced PivotTable Techniques That Feel Like Cheating ( Download)
• I don't use PIVOT tables anymore... I use this other thing instead! ( Download)
• Master Pivot Tables in 10 Minutes (Using Real Examples) ( Download)
• 10 Expert Level PIVOT TABLE TRICKS you cannot miss! 🤩 ( Download)
• Excel Pivot Table EXPLAINED with 10 Different Examples | Pivot Table in excel | Pivot Table Tutorial ( Download)
• Excel PivotTables Made Easy - And Why Things Go Wrong! ( Download)