Advanced Pivot Table Techniques: Combine Data from Multiple Sheets in Excel
ฝัง
- เผยแพร่เมื่อ 2 ก.ค. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Struggling to create PivotTables using data from different tables? This video is your solution! We dive into a practical, easy-to-understand guide on using Excel's Data Model for efficient reporting.
⬇️ Download the workbook here: pages.xelplus.com/merge-multi...
Creating a Pivot Table in Excel based on multiple tables or multiple sheets can be tricky. Often Lookup functions like VLOOKUP are used to consolidate the information in a new table. This can significantly increase the size of the spreadsheet and make it slow.
Key Highlights:
▪️ Crafting a PivotTable with Customer Sales & Quantity Sold by Article
▪️ Using Excel's Data Model to Simplify Data Merging
▪️ Easy Steps to Create Relationships between Tables
▪️ Creating Visually Clear and Informative Reports
▪️ Tips on Hiding Unnecessary Data Fields for Clarity
In this video I'll show you a better alternative to combine data in a pivot table. We will keep the source tables as they are but we'll build a report based on relationships in PowerPivot. Based on this data model in Excel we can setup PivotTables and access the information from all tables.
00:00 Create a PivotTable with from Multiple Tables
01:47 Using the Excel Data Model to Merge Data from Different Tables
02:47 Create Relationships between Different Excel Tables
05:10 Diagram View in Excel PowerPivot
06:00 Create a Pivot Table from the Excel Data Model
09:56 Join Leila's Ultimate Power Query Course
Complete Power Query Playlist: • Excel Power Query (Get...
Power Query complete course: www.xelplus.com/course/excel-...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel
Grab the file I used in the video from here 👉 pages.xelplus.com/merge-multiple-tables-file
Hi. Thanks for your awesome and helpful tutorials ! Can you please confirm that I'm not mad, and Data Model is not available on a MAC version of Excel ???
Cheers
Wow thanks again! You are empowering so many people in the roles they already occupied. How powerful, thanks Leila! Anyone can lead and anyone can make the difference!
You are a life saver!!! Previously, I enrolled to ur VBA course and saved my life too. Once again, this save my life again! Thank you very much for being such a great teacher!!!
i've found your channel has been 3 days, and however we say in my country, "i've been looking for copper, but i've found gold". T h a n k y o u!
Welcome aboard!
I am addicted to watch your all videos. You are such a brilliant and you don't know how much you are helping me.
Excellent tutorial Leila. Thank you very much for sharing your knowledge!
Wow thanks again! You are empowering so many people in the roles they already occupied.
Love your tutorials! You've really helped me step up my game at work.
Thank you, your courses are the best source for selflearning.
You just rocked my Excel world.
Leila! I'm just gonna call you the Rock Star maker. You're helping us all to be Rocks Stars at this. Thanks so much for the knowledge transfer!🙌🏾
You rock! 😊
Thanks for your work, I have been watching your videos for weeks to be better at my work. I send you a big hug from CDMX
The data model I'm using at work to monitor OPEX is built exactly on that type of pivot table. Now I understand much better what my colleague hasn't explained me. Thank you so much Leila :D
Glad it helped!
Another fantastic time saving video! Thanks!
Your knowledge of Spreadsheet is stunning,Ms Gharani. I not only like but love your videos. They have been extremely helpful to me. Since I am learning programming, I wish you could come up with some such videos in days to come. All the best !
Awesome as always 👍
I sure will come back to this tutorial many times when I need to use this function in the future
Awesome as always! Making these things very easy to understand.
Fantastic! Super helpful, thanks Leila
This was an excellent tutorial and exactly what I needed. You elevated my excel skills to then new highs. Thank you so much!
Following your channel and watching your videos have upgraded my Excel knowledge to new heights. Thank you for enlightening us and keep bringing new concepts like this.
You're very welcome! Thank you for watching.
Thank you for enlightening us in Excel,
I like relationship. Thanks Leila!
Wonderful, Leila - no more helper columns! Thank you!
Wonderful Gino!
Marvelous video. Clear and easy to follow example. Thank you for sharing.
Thanks Leila you are brilliant. I just came across your video while preparing for an interview where I will need to have knowledge of Power Query, Power Pivot and Power BI.
Thanks for simple and clear explanation
Explanation top class.
Highly professional
Another amazing video! Thank you!😊
Leila you are simply the best on TH-cam as your lessons are very captivating and easy to understand.
Wow, thank you!
خانم قرانی خیلی ممنون بابت آموزش های مفید شما
Thanks agian Leila! you are the best!
Exactly what I need to do today. Thank you so much! ❤
Great trick. Thank you for making it so easy!
Outstanding work as always. I now hope to find a video from Leila whenever I have anything challenging to do in excel.
Thank you! I've actually looking to merge two different data types. Now I found one.
Brilliant presentation!
Thanks looks soo easy!!
Thanks for sharing your knowledge.
Awesome Data Model video, Teammate!!
Appreciate it, teammate!
Excellent. Thanks
Thank you Leila. This video helps me a lot in my works on originazing assets components. Highly appreciating.
Like to see many to many relation + nested tables hierarchy
Respectively and best regards
This is just perfect ... simple and easy explanation ... thanks Leila
Glad you like it!
Thanks. I have been doing this in MS Access. This is much more practical. 👍
Awesome tutorial.... thanks
As always, you are amazing.
Thanks. I am just a beginner . These give a better of how a pivot table is created.
I love your teaching and coaching style. Thanks a lot.
Happy to hear that!
Great video ... simple and effective
This is perfect~ Thank you
Thanks a lot Leila
Thank you for sharing!
Thank you for this video😊
Nice and Crisp video Leila! As usual, I learnt a trick or two here as well! Take a bow Lady! You really are "Excel Queen"! 😊👍
Thank you! 😃
nice music in the video. i watch atleast one video of leila everyday
I’ve been working for 6 yrs now in a finance company dealing with data and Excel on a daily basis and I thought I ‘knew’ Excel. Wow your channel is amazing and I am now even more motivated. Anyways may I ask for a tutorial about Slicer tables in Excel, this is something I have been always struggling to understand. I would really appreciate that! Thanks in advance :) Keep up inspiring us Leila :)
Glad I could inspire you. I have a video on Pivot Tables on the channel in case you want to check it out.
You are just fantastic! It's soooo good and you explained it very good. Thank you very much!
Excellent, thank you Leila. I thought I knew data models and just discovered from this there is still a lot to learn.
Glad it was helpful, Mike!
Grateful for your sharing.
Whenever i find u uploaded a video
Step1: Click on the youtube video.
Step 2: Like it first
Step3: Then watch it..
Thank you Leila. Lots of Love...:)
Thank you for your support!
very good
i'm following you from egypt 🇪🇬
Wow. Very explicit video tutorial, thanks for sharing this Leila. You're simply amazing
You’re welcome Nono 😊
You are just great!
Great video! really useful and easy to understand.
❤️❤️ Enlightening
excellent video. thanks a lot
Really nice and clearly explained how to use the data model with nice music on the background.
Thanks nice job and looking forward for many such videos
Thanks Laila, Excellent post, your video are awsome and helpful. time saving!!!!!!! wishing you the best
awesome!! you're soooo amazing!
Great lesson. thank You Leila.
My pleasure!
Nice explanation very informative. Thanks
Ultra Amazing!!!
I come to your video to refresh my excel skills. Thank you for clear explanation. Please keep up your good work.
Thank you, I will
Thanks Leila, I'll apply this at work
Our pleasure, Felipe.
As always Leila does the best
Thank you 😊
Excellent Trick as always. I wonder how come some people dislike this video! No matter how good a video is, there are always some stupid haters!!
Thank you 😀
I love your channel
your tutorials are really fascinating. Thanks a lot🙏
Glad you like them!
My favourite teacher
I was waiting for this :) Excellent!!
Glad you liked it!
thank you for the excellent explanation. Now I understand the Data Model
Great to hear!
Thank you for enlightening me. Enoy all
Very slick!
YOU ARE THE BEST
Hi Leila. Excellent! Thanks for the reminder of how to make connections in Power Pivot. Picked up a few good tips and tricks from your presentation. Always a pleasure to watch your videos :)) Thanks for sharing and Thumbs up!!
Always a pleasure seeing your comments, Wayne :)
thank you its greaaaaaat
Ma'am, you're the best lots of love.
Thank you so much 😀
This is amazing, you're saving me hours and hours in the future from having to index-match!!
Happy to help :)
Thank you for your wonderful work. It helps a lot. I obviously still have much to learn about excel :)
Wow! What a wonderful video. Thank you so much. This is very helpful!
Glad it was helpful! Thank you for watching.
The data model was a wonderful addition to Excel, no more lookup formulas!
Hey Leila, thanks for sharing this. I am sure this is going to be useful to lot of people.
I hope so!
Excellent video, thanks for knowledge sharing.. this was new thing to me..
I have enjoyed all of your great videos. I have learned much on so many topics from you. I have not found a video from you covering Microsoft Project. I think this software product is of the same quality as Excel. It seems like this product would be natural for you to present, especially with your background in project management. I hope you add this to your products to teach. Thank you for all your tremendous videos.
Another great video; thanks for sharing 👍👍
Thanks for watching!
Thank God Leila Gharani exist
Superb !! Thanks a lot for the knowledge shared !!
My pleasure!
Wow, super useful for me. Thanks
Glad to hear that
Wow thanks so much
I love ittttt!!!