🧙♂️ Top 14 Excel Pivot Table Tips & Tricks - Tutorial
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
Видео 🧙♂️ Top 14 Excel Pivot Table Tips & Tricks - Tutorial канала Kevin Stratvert
👋 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
Видео 🧙♂️ Top 14 Excel Pivot Table Tips & Tricks - Tutorial канала Kevin Stratvert
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How to use Power Pivot in Excel10 Amazing (Less Known) Excel Tricks You Should KnowExcel PivotTables Made Easy - And Why Things Go Wrong!Excel INDEX MATCH Made Simple - Lookup like a Pro📆 Top 14 Microsoft Outlook Calendar Tips & TricksHow to use VLOOKUP in Excel - Complete Tutorial9 Useful Excel Pivot Table Tips everyone should knowSecrets to Building Excel Dashboards in Under 15 Minutes!Amazing Ideas That Will Upgrade Your Home ▶14🧙♂️ Top 15 Gmail Tips & Tricks📨 10 Tips to Take Control of your Outlook Inbox & avoid email overload!50 Ultimate Excel Tips and Tricks for 2020🧙♂️ Top 8 Microsoft Teams + Outlook Tips & Tricks👩💻 Python for Beginners Tutorial🔎 How to Create Excel Searchable Drop Down ListConsolidate & Clean Multiple Excel Sheets in One Pivot TablePivot Table Excel TutorialHow to Easily Create Multiple Dependent Drop-Down Lists in ExcelMicrosoft Excel Tutorial for Beginners - Full Course