🔥 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-whZdWx...
- Same Workbook with 2023 Data: 1drv.ms/x/s!AmxrofZZlZ-whZdYE...
⌚ 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 Ta...
- How to use Microsoft Power Query: • How to use Microsoft P...
- Playlist with all my videos on Excel: • Excel for Beginners
📩 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: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / 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 KZitem
kzitem.info?...
🙌 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
Пікірлер: 175