Playback starts YouTube’s embedded player (privacy-enhanced mode).
Pivot Table Excel Tutorial
ChannelKevin StratvertIn brief
This tutorial shows beginners how to create and customize PivotTables in Excel to analyze data efficiently. You’ll learn to insert tables, use calculated fields, sort data, and visualize results with charts—compatible with Excel 2003 through Office 365.
Key steps
- Insert a PivotTable from your dataset using Excel’s tools
- Drag fields into row, column, filter, and value areas to organize data
- Adjust value field settings to change how data is summarized
Questions & answers
Does this work in older versions of Excel?
Yes, the tutorial covers Excel 2003 through Office 365.
Can I access Excel online for this?
Yes, the video shows how to use PivotTables in Excel on the web via office.com.
Chapters
Description from the creator
🔥 Learn Excel in just 2 hours: 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: 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: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqo…
🔽 CONNECT WITH ME
- Official web site: kevinstratvert.com
- 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/
🎁 TOOLS AND DISCOUNTS
🎁 PARTNERS & DISCOUNTED OFFERS
💻 Hostinger | hostinger.kevinstratvert.com
📋 Notion | notion.kevinstratvert.com
💵 Quickbooks Online | qbo.kevinstratvert.com
🎙️ Voicemod AI Voice Changer | voicemod.kevinstratvert.com
🕵️ VidIQ | vidiq.kevinstratvert.com
🎒 MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
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
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: 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: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqo…
🔽 CONNECT WITH ME
- Official web site: kevinstratvert.com
- 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/
🎁 TOOLS AND DISCOUNTS
🎁 PARTNERS & DISCOUNTED OFFERS
💻 Hostinger | hostinger.kevinstratvert.com
📋 Notion | notion.kevinstratvert.com
💵 Quickbooks Online | qbo.kevinstratvert.com
🎙️ Voicemod AI Voice Changer | voicemod.kevinstratvert.com
🕵️ VidIQ | vidiq.kevinstratvert.com
🎒 MY COURSES
- Excel for Beginners in under 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
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
About this tutorial
Kevin Stratvert published this 13:36 video tutorial on November 2, 2019. It has been watched 5,045,428 times on YouTube.
- Channel
- Kevin Stratvert
- Category
- Science & Technology
- Duration
- 13:36
- Published
- November 2, 2019
- Views
- 5,045,428
- Likes
- 81,538
Share
This tutorial in other languages
- FRTableau croisé dynamique Excel Tutorial
- ESTutorial tabla dinámica de Excel
- PTPivot Table Tutorial Excel
- ITTabella pivot di Excel Tutorial
- DEPivot-Tabelle Excel Tutorial
- NLPivot Table Excel Tutorial
- RUСводная таблица Excel Учебник
- PLTabela przestawna Excel Tutorial
- JAピボットテーブルエクセルチュートリアル
- ARمحور جدول اكسل دروس
- HIपिवट तालिका एक्सेल ट्यूटोरियल
- IDPivot Table Excel Tutorial