Pivot Table Excel Tutorial



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

SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same)

CONNECT WITH ME
– Official web site: http://www.kevinstratvert.com
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://discord.gg/kHuujY2pZf
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/

MY COURSES
– Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/

REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1

#stratvert

Source

Uncategorized

Masterclass – Franchise Selection & Contract Negotiations – Hotel Franchise Workshop

Noesis Capital Advisors Presents Hotel Franchise Workshop Panel Discussion on: Masterclass – Franchise Selection & Contract Negotiations Key Speakers: Ashish Pyasi, Associate Partner Dhir & Dhir Associates Moderated By Vijay Bhandari COO Noesis Capital Advisors Source

Read More
Uncategorized

Kyrie Irving ‘promotes’ himself to a management role for Nets next season | NBA | FIRST THINGS FIRST

Despite a disappointing end to a rocky season, Kyrie Irving says he’s sticking with the Brooklyn Nets… but not just as a player. During a presser after the Nets were soundly swept out of playoff contention, Kyrie divulged that he sees himself more in a managerial role next season, and alongside Kevin Durant and actual…

Read More
Uncategorized

Jim’s Cleaning #1 Overall Best Franchise

#jims #jimsgroup #yourlocalexpert Jim’s Cleaning was awarded the number 1 overall franchise by www.topfranchise.com. In this video, Ali Olmez (CEO) explains the criteria for the award and why they took out the top spot. To join the Jim’s family visit https://jims.net/own-a-franchise/ or call 131 546 SUBSCRIBE TO OUR CHANNEL https://www.youtube.com/user/JimsGroupPtyLtd?sub_confirmation=1 Jim’s Group are your local…

Read More