Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com

In this stepbystep tutorial, you will learn how to create a pivot table from multiple Excel worksheets and workbooks. A pivot table is a powerful tool that lets you summarize and analyze data in different ways. You will see how to combine data from different sources.

RESOURCES
Sample Workbook: https://1drv.ms/x/s!AmxrofZZlZwhZdWx...
Same Workbook with 2023 Data: https://1drv.ms/x/s!AmxrofZZlZwhZdYE...

⌚ TIMESTAMPS
00:00 Introduction
00:37 Overview of the data
01:34 Launch Power Query Editor
02:28 Import data tables
04:24 Append queries
05:48 Transform data
06:23 Make & customize pivot table
08:43 Relate data tables
12:00 Wrap up

RELATED VIDEOS
How to Create Pivot Tables in Excel:    • How to Create Pivot Table in Excel  
How to use Microsoft Power Query:    • How to use Microsoft Power Query  
Playlist with all my videos on Excel:    • Excel for Beginners  

NEWSLETTER
Get the latest highquality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

CONNECT WITH ME
Official web site: http://www.kevinstratvert.com
LinkedIn:   / kevinstratvert  
Discord: https://bit.ly/KevinStratvertDiscord
Twitter:   / kevstrat  
Facebook:   / kevinstratvert101912218227818  
TikTok:   / kevinstratvert  
Instagram:   / kevinstratvert  

MY COURSES
Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

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

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)

#stratvert #excel #pivottable