🔥 Learn Excel in just 2 hours: [ Ссылка ]
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: [ Ссылка ]
- How to use Pivot Tables Tutorial for Beginners: [ Ссылка ]
- How to use Power Pivot in Excel: [ Ссылка ]
- Learn the fundamentals of Excel in just 2 hours: [ Ссылка ]
⌚ 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: [ Ссылка ]
🚩 Connect with me on social
- LinkedIn: [ Ссылка ]
- Discord: [ Ссылка ]
- Twitter: [ Ссылка ]
- Facebook: [ Ссылка ]
- TikTok: [ Ссылка ]
- Instagram: [ Ссылка ]
🔔 Subscribe to my YouTube channel
[ Ссылка ]
🎬 Want to watch again? Navigate back to my YouTube channel quickly
[ Ссылка ]
🛍 Support me with your Amazon purchases: [ Ссылка ]
⚖ 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
Теги
kevin stratvertpivot tableexcelpivot table excelpivottablepivottablespivotablepivot tablesexcel pivot table tutorialexcel pivot tablehow to create a pivot table in excelhow to use pivot tables in excelhow tousecreatemakehow to create pivot tables in excelin excelpivot table excel tutorialtutorialadvancedtipstrickstips and tricksbeginnershow to make pivot table in excelpivot tables excelexcel tutorialexcel pivot tables