Create Pivot Tables from Multiple Sheets in Excel

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

In this step-by-step 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!AmxrofZZlZ-whZdWxnDcdvNGuVTfSA?e=b91Vkv
- Same Workbook with 2023 Data: https://1drv.ms/x/s!AmxrofZZlZ-whZdYEoGQ7BBK881-3w?e=FcAIz9

⌚ 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: https://youtu.be/PdJzy956wo4
- How to use Microsoft Power Query: https://youtu.be/0aeZX1l4JT4
- Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K

📩 NEWSLETTER
- Get the latest high-quality 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: https://www.linkedin.com/in/kevinstratvert/
- Discord: https://bit.ly/KevinStratvertDiscord
- 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
- 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?sub_confirmation=1

🙌 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