Make Pivot Table from Multiple Sheets in Excel

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

⌚ 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

📩 NEWSLETTER

🔽 CONNECT WITH ME

🎒 MY COURSES

🙏 REQUEST VIDEOS

🔔 SUBSCRIBE ON YOUTUBE

🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!

#stratvert #excel #pivottable

[monicajustice]

One of the best tutorials I have ever watched. Thanks for supplying the source material so that we could follow along.

[abdirazakmohamedibrahim]

big round of applause for you boss! learned tons of knowledge from you, thank you.

[jeanettesefers]

By far the easiest tutorial on making pivot table from multiple sheets in excel. Thank you.

[stephenrichards]

Best excel presenter on YouTube. Thanks Kevin

[pjohn]

I have no use for a pivot table at the present, it's good to have this available for future use. As always Kevin valuable information. Thanks Kevin.

[mariemcknight]

That was an amazing video, I learned so much in such a short time and was able to immediately put it to use. Thank you!

[mdrakibulhaque]

It's absolutely amazing 🤩, thank you Kevin for the valuable content

[chronicposer]

This was great. I was just working on a project that needed to have data from multiple reports in one place. this video has really helped me understand what I need.

[ralphpayne]

Another top-notch video. Happy recommending your videos because they are consistently well-prepared, clearly presented and excellent for learning from.

[ezxlsvt]

The easiest tutorial ever. Thank you so much. It's seemed so daunting and now it's not!!!! I did it

[BBKing]

I think of myself as pretty good with pivot tables, but I've never used Power Query to combine source data before, so it's good to learn something new.

[adil-blue-blood]

hey from morroco I wanted to express my sincerest gratitude for the amazing content you consistently share on your YouTube channel. Your videos have been a constant source of inspiration and entertainment for me, and I truly appreciate the effort and passion you put into each one. Thank you for creating such valuable and enjoyable content

[tee]

Best excel tutorial channel I’ve ever seen. Thank you!

[samanthaviberg]

Another fantastic video where it was clear explanations and examples! Thanks!

[HowlinAndyDE]

OH! This is like you read my mind. I totally need this for my work! Thanks Kevin!

[YeungKaHung]

Simply amazing and powerful tools in MS Excel. Great video, Kevin.

[NBLelord]

Always my best option when ever it comes to office products thank you sir. Much appreciated

[dancemusikk]

Thank you sooo much!!! No one else I seen explained it or did it this way. A lot of people say to import from a folder, but that way runs into so many errors and then it puts each table on a different sheet. So thank you very much!!

[ravigoyal]

Thanks Kevin for sharing best excel content

[jorgemacgenity]

Great Kevin,
A very common need with very good and clear explanation.
It will help a lot.