🔥 Learn Excel in just 2 hours: 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: 1drv.ms/x/s!AmxrofZZlZ-whZdWxnDcdvNGuVTfSA?e=b91Vkv
- Same Workbook with 2023 Data: 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: youtu.be/PdJzy956wo4
- How to use Microsoft Power Query: youtu.be/0aeZX1l4JT4
- Playlist with all my videos on Excel: youtube.com/playlist?list=PLlKpQrBME6xLDnoK7OovAVVsGNV55MS3K
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: kevinstratvert.com
- LinkedIn: linkedin.com/in/kevinstratvert/
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert/
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON YOUTUBE
youtube.com/user/kevlers?sub_confirmation=1
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: 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
- Make Pivot Table from Multiple Sheets in Excel ( Download)
- Pivot Table from Multiple Sheets - Google Sheets ( Download)
- Create a PivotTable in Excel using multiple worksheets by Chris Menard ( Download)
- How to Create a Pivot Table from Multiple Sheets in Google Sheets ( Download)
- Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial! ( Download)
- Create Excel Pivot Table from Multiple Sheets: The FASTEST Way ( Download)
- How to Create a Pivot Table Using Multiple Sheets in Excel | Microsoft Excel Tutorial | Simplilearn ( Download)
- Google Sheets - Combine Data From Multiple Sheets (Tabs) Tutorial ( Download)
- Easily Make a Pivot Table from Multiple Sheets ( Download)
- How to Combine Data from Multiple Sheets to One Master Tab for Google Sheets ( Download)
- Is it possible to create a Pivot table on multiple sheets in Excel ( Download)
- Pivot Table - Google Sheets - Connect a Slicer/Filter to Multiple Pivot Tables, Different Sources ( Download)
- Consolidate & Clean Multiple Excel Sheets in One Pivot Table ( Download)
- How to create a pivot table from multiple sheets of data ( Download)
- EASILY Combine Multiple Excel Sheets Into One With This Trick ( Download)
