Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!

  Рет қаралды 1,467,362

Leila Gharani

Leila Gharani

Күн бұрын

Get access to the full course here 👉 www.xelplus.com/course/excel-...
Master the art of creating PivotTables in Excel from multiple worksheets with our straightforward tutorial. Ideal for Excel users of all levels, this guide simplifies the process of consolidating and analyzing data from various sources using PivotTables.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/pivottable-...
You can use a PivotTable in Microsoft Excel to combine data from multiple worksheets. In this video I'll show you 2 methods you can use depending on your situation.
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
🔑 Key Tutorial Features:
▪️ Method 1 - Append Data: Learn the efficient way to combine similar data from different sheets without manual copy-pasting. This method is perfect for sheets with identical columns in varying orders.
▪️ Method 2 - Merge Data: Discover the smart approach to connect detailed data spread across tabs, such as linking product codes to names. This method simplifies data consolidation for effective PivotTable creation.
▪️ Practical Use Cases: Apply these methods to everyday business scenarios like merging sales data from multiple stores or connecting product information for comprehensive analysis.
You might need to combine data from different sheets into one table and then create a pivot table based on the one table. In this case you'll need to append the data. Don't use formulas to append the data. Specially if your column headers are in a different order, this can get quite complex. Instead you can use Get & Transform (Power Query) from the "Data" tab in Excel. With Power Query you can append the data from different sheets (even from different files and sources) and create a single Pivot Table.
Sometimes you might need to combine the data from the different sheets by using a lookup function like VLOOKUP to get more information from another table into the table that you need to create a pivot table on. Don't use VLOOKUP to add additional columns, instead use relationships from the "Data" tab. With relationships you automatically add your tables to the data model and you get to create a power pivot based on this. You don't need to write a single formula.
Your results will be dynamic too. Once you get new data, all you have to do is "refresh" your pivottable and the new data is there!
These pivot table tips are going to help you analyze your data and get better and faster insights into your data.
★★★ My Online Excel Courses ► www.xelplus.com/courses/
00:00 How to Create a PivotTable from Multiple Worksheets
01:28 Method 1: Append Data for Pivot Table
06:44 Method 2: Merge Data for Pivot Table
10:44 Wrap Up
► Pivot Tables for Beginners: • Excel Pivot Table EXPL...
➡️ Join this channel to get access to perks: / @leilagharani
🎓 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 #pivottables

Пікірлер: 933
@LeilaGharani
@LeilaGharani 9 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/pivottable-multiple-sheets
@raheimcason1191
@raheimcason1191 8 ай бұрын
I'm trying to create a work sheet that let's me take all the parts from a specific bigger part and make a parts list for multiple different parts. Any help would be greatly appreciated
@everodchung5584
@everodchung5584 4 ай бұрын
I’m wondering if it is possible to do this with excel online 🤔
@baphnie
@baphnie 2 жыл бұрын
Hands-down the most vital resource for learning Excel in my journey. I wouldn't have landed my current role without you, Leila.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Happy to hear that!
@vishisbest
@vishisbest 2 жыл бұрын
Very useful, this is what I do in Tableau, I didn't know this was possible in Excel. Excel will never be redundant. Your videos are very useful and easy to learn, thanks!
@kengifford3714
@kengifford3714 2 жыл бұрын
Wow, thank you for this content. I'm creating a personal finance tool using multiple bank statement sources and this tutorial worked perfectly for me to combine and quickly analyze. AND I didn't have to troubleshoot a single function! Amazing.
@prakavids3125
@prakavids3125 3 жыл бұрын
I was trying to understand this last week through other tutorials. But you made it look so simple. The simple examples you use for the explanation make your methods unique
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Great to hear!
@mikejackson8463
@mikejackson8463 2 жыл бұрын
There is no way I could have completed this project without your videos!! Method 2 here is exactly what I needed. Thanks so much!!
@mattcurtis5202
@mattcurtis5202 Жыл бұрын
I can't say how much I love this tutorial! It was exactly what I was looking for to accomplish a current work project. Thank you so much!
@vijayarjunwadkar
@vijayarjunwadkar 3 жыл бұрын
Liked both methods and what I love most is, I get new ideas through your demos, which helps me a lot in my work! Thank you Leila for all your support! God bless!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Hope it will come in handy at your work, Vijay.
@abhisheksharma1881
@abhisheksharma1881 2 жыл бұрын
@@LeilaGharani please tell the method to add column to source data by editing the pivot table
@stevenmurphy8657
@stevenmurphy8657 Жыл бұрын
I use method 1 for 15 tables , ~20k rows and it worked flawlessly. Thank you for getting right to the point and educating your viewers.
@lydkem5004
@lydkem5004 Жыл бұрын
can i use for like 30sheets of similar columns
@mattschoular8844
@mattschoular8844 3 жыл бұрын
Thanks Leila. I use method 1 often but method 2 also comes out of my toolbox on occasion. The nice thing about using the data model is being able to set a number format like currency, which comes into all subsequent pivot tables already set.
@kwwong1148
@kwwong1148 Жыл бұрын
Another absolutely clear and instructive tutorial from Leila ... She made it look so simple .... masterful. 👍
@beyobeya
@beyobeya 3 жыл бұрын
I had to watch a 35-minute video twice about Power Query a few months back and now you had it in 11 minutes. Thank you Leila :)
@mikegothie5226
@mikegothie5226 Жыл бұрын
I echo sadiq's comment. Best video ever and exactly solved my problem. You are one of the best excel teachers I have ever met and this video is very well made. I've watched it over and over again. $ Thank you coming.
@Iwanpritch
@Iwanpritch 2 жыл бұрын
Thank you for showing method 2, really useful and super easy. I always learn a great deal from your tutorials.
@paulbendall3878
@paulbendall3878 2 жыл бұрын
Thank you for this overview. Pivot Tables are something I've never got my head around normally because I have some else on the team who is a whiz. The video explains how to approach my problem in a simple, well explained and succinct presentation.
@Sparqcorporatetraining
@Sparqcorporatetraining 3 жыл бұрын
One day I hope to be as outstanding an instructor as you, Leila. As a fellow instructor, I'm blown away by the quality of your videos. Thank you once again!
@sourabhchaudhari
@sourabhchaudhari Жыл бұрын
If there was an option to hit the "Like" button multiple times I would have done that coz one time is not enough for this wonderful piece of art! Thanks a ton Leila!
@user-xr1tw9cb3s
@user-xr1tw9cb3s 3 жыл бұрын
I normally use a Power Pivot for that. Just needed to solve this issue in my company through a Power Pivot last week. Leila, your videos are awesome! Congrats on excellent MS Excel tips. I’ve been able to advance in my career with the help of your videos! 😊
@muskanjethani4257
@muskanjethani4257 Жыл бұрын
Can you tell me how to use Power pivot for this?
@abedallahomari5984
@abedallahomari5984 2 жыл бұрын
Ms. Leila Gharani Thank you for the best tutorials ever seen in KZbin...
@sr5726
@sr5726 2 жыл бұрын
What I love about your videos is 1. Presentation is excellent and very easy to understand 2. Each minute is informative and there is no time wasting . It's power packed , simple and straight to point. I can understand the time and effort it takes to create a concise video. Thank you for your video and effort taken. It's so enjoyable to watch your videos.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Thank you for the kind feedback!
@tsumichama
@tsumichama 3 жыл бұрын
You make me love excel even more 😍
@314jph
@314jph 3 жыл бұрын
interesting and a huge time saver. Appears Excel taking on usability of MS Access, makes sense since they both use VBA.
@kristinamelnichenko5775
@kristinamelnichenko5775 3 жыл бұрын
I could never pick a favorite, I love them all the same (too much)! You make it too easy Leila! Thank you!
@rayzor07
@rayzor07 2 жыл бұрын
Definitely found a use for Method 1 as a friend has multiple sheets of the same data but just for different vehicles. I tried it for at least 6 of those sheets, and voila....it was beautiful!! Thanks Leila...you are awesome!
@jcarlosquebrado6716
@jcarlosquebrado6716 Жыл бұрын
Got to tell you, I love your videos. Been watching them for years. You're my go-to for Excel reference. By the way, my choice of preference is method 2; primarily because I like to use databases. Thank you very much for your lessons.
@jwanger
@jwanger Жыл бұрын
completely agree!
@JimFikes
@JimFikes Жыл бұрын
Thanks, Leila. You are batting 1000. I have never watched one of your videos that wasted any of my time. For me and my students, you are the "go-to" person for Excel training on KZbin.
@LeilaGharani
@LeilaGharani Жыл бұрын
Thank you so much, Jim!
@muhammadkaleem4676
@muhammadkaleem4676 4 ай бұрын
​@@LeilaGharani how r u , I want to learn Excel
@cassioalexan
@cassioalexan 3 жыл бұрын
Leila, you and this video deserve a thumbs up just by having explained the method 1, which is not commonly taught by others. Most videos I've seen so far concentrate on explain only method 2 (same column in all tables), however I just need something as you explained in the first part. Just want to thank you by this! Success!
@TechnicalMamunBengali
@TechnicalMamunBengali Жыл бұрын
You are the mother of Excel.Your tutorials are clear and clean to every one.
@hmassarelli6859
@hmassarelli6859 2 жыл бұрын
2 for relatively easy ones. When I do 1, the data tend to be enormous and takes hours.. Thank you, Leila, for showing me how to do them.
@Rosiechen2018
@Rosiechen2018 2 жыл бұрын
Definitely method 2. Thank you as always for you excellent teaching! Love all your tutorial videos.
@mohammedsharaf5609
@mohammedsharaf5609 2 жыл бұрын
Thank you is not enough. u've helped me a lot. Truly appreciate all the support u're giving us here on youtube.
@ebubeokoli213
@ebubeokoli213 3 жыл бұрын
Wow. This one was really helpful. I can now append a large dataset in Power Query and use for Pivoting without bothering Excel going slow. Thank you Leila.🥺
@sadiq7601
@sadiq7601 Жыл бұрын
My monthly data is so huge that I'm required to split it into two sheets (1st to 15th and then 16th to end of the month). I was searching since past so many days a method to create a pivot from multiple sheets and today came across your video... I usually don't comment on KZbin videos... but I couldn't hold myself from expressing my APPRECIATION and GRATITUDE towards this video. Thank you for sharing this wonderful method/trick.... God bless you! Is there a method where we can create a connection between different workbooks too?
@simon250505
@simon250505 3 жыл бұрын
This is so bizarre, I was just looking for a video about this topic last night 😂 thank you!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad it was helpful!
@alexfullmer4707
@alexfullmer4707 3 жыл бұрын
Did you mention that out load around your phone? That's why it popped up.
@abaasanji4979
@abaasanji4979 3 жыл бұрын
Thanks Leila for always making us better at what we do. I think the second option is simpler to understand.
@MichaelMooreboston
@MichaelMooreboston Ай бұрын
As always Leila explains everything perfectly. Exactly what i was looking for.
@dh034
@dh034 11 ай бұрын
Outstanding, used the 2nd option and it worked fantastically! What a teacher!
@ifount
@ifount 2 жыл бұрын
Excellent video! Very helpful! May I ask, however, why at around 4:05, do you create a "connection" before you append the tables? What is a "Connection"?
@rolandaugust6602
@rolandaugust6602 2 жыл бұрын
A great tutorial, leaned a lot on method 1 (instead of c&p into one table Which I did so far). How could both scnearios be combined, when you have multiple input tabs and the need to enrich data ? The data model allows a relationship to a table, but not to a query.
@aynino
@aynino 2 жыл бұрын
I suspect you will first need to apply your transformations (or enrichment) of the data into power query, then load your new tables as « table » into your workbook and use that as the basis for your data model.
@adrianodossantosfernandes1236
@adrianodossantosfernandes1236 Жыл бұрын
Hi Leila, your videos are simply amazing!!! Thanks for sharing your knowledge with us!!
@pr0vider
@pr0vider 3 жыл бұрын
Just in time for my datamodel optimization. Thanks Leila for the awesome tips.
@1982757
@1982757 2 жыл бұрын
Hello, thank you for an excellent tutorial. I made up a dataset with three different worksheets but all with the same id number to serve as the primary key linking them. I followed the second method to create a relationship between the three worksheets. However, when I try to create a pivot table with info from the three worksheets, it pops up a message saying relationships need to be created. When I look at the data model, I see that the three sheets were recognised in the diagram view. What am I doing wrong?
@octaviakf
@octaviakf Жыл бұрын
Did you make sure that all of them were a table like how she did in the beginning?
@MNadeemShihabi
@MNadeemShihabi 2 жыл бұрын
Hi Lelia, Can I apply method 1 with excel 2016? I don't have the option "From Sheet"
@JustinSteele-vo6pv
@JustinSteele-vo6pv Жыл бұрын
I looked forever for a video that can do option 1, and it worked first time and easy to follow along!
@ayodejirauf7712
@ayodejirauf7712 Ай бұрын
Leila, you just made me smile. Thank you!!!
@chakrabmonoj
@chakrabmonoj 2 жыл бұрын
Hey Leila this is a great lesson. But the version I am using does not have the option you are showing under the data tab. Is there another way to merge two sheets into one query?
@camosam03
@camosam03 Жыл бұрын
I’m having the same issue 😢
@ZayShinning
@ZayShinning 2 жыл бұрын
Hi, thank you for the content. I am improving my excel skills a lot thanks to you! Quick question: I don't have the option "From sheet" on my tab and when I try to add it, it does not appear on the list. How can I add it, am I missing some step perhaps? Many thanks!
@hammadsiddiqui4259
@hammadsiddiqui4259 2 жыл бұрын
I got the same issue. I somehow manage to do it but now I can't remember. Back to this amazing tutorial.
@robinbrightman2322
@robinbrightman2322 2 жыл бұрын
Thank you, this is just what I was looking for. Both method 1 and method 2 will be very useful for my current project (analysing team performance from monthly worksheets).
@bettypoula5990
@bettypoula5990 2 жыл бұрын
নমস্কার এই মইঈক
@drezone300
@drezone300 2 жыл бұрын
Thanks!!!!!....You are the BOMB...You always clearly explain everything!!!
@kel6207
@kel6207 2 жыл бұрын
hi Leila, i really find your video very informative, and easy to follow. i tried to use the method 1, however, in my excel version, i do not have the option "Get from Sheet", i only have Get From Text/CSV, From Web, From Table/Range, Recent sources, and Existing Connection. I am using office 365, and i hope i can also use the feature From Sheet. hope you can help me with the settings. thank you.
@LifewithEPC
@LifewithEPC 2 жыл бұрын
I am having the same issue. There is no "Get from Sheet" option.
@andytickle7762
@andytickle7762 2 жыл бұрын
I also had this problem. I used the get workbook option, then when selecting a workbook file I chose the same workbook and the tables were available for selection
@spady1968
@spady1968 Жыл бұрын
Many thanks , I have tried method #2 in my work but when I tried to sort the column from largest to smallest it did not work is there is any reason for that ?
@gsahdala
@gsahdala 2 жыл бұрын
This is very useful! I tried method 2, but when I tried to make the relationship, it says that the columns to relate can't be repeated in the table. I'm trying to make a pivot table from to sheets, one has records of invoice number, and the other has records of cash receipts to that invoice number. A client can make multiple payments for just un invoice, so the invoice number will be repeated in the sheet of the cash receipts. The reason I want a pivot table is because I need to do a check balance with to see if the customer paid the invoice completely. Can you please help with that? Thanks!
@sonalir3583
@sonalir3583 2 жыл бұрын
I also have data with repeat information in rows but master data has no repeat but relationship cannot be created u less repeat info is removed..which I am unable to do..pls help
@darrencheung9974
@darrencheung9974 2 жыл бұрын
i have the same problem. it says that the columns to relate can't be repeated in the table.
@donaldmcintosh6545
@donaldmcintosh6545 2 жыл бұрын
That was great. I already use pviot tables and queries and it was educational to see better ways to combine data. Thank you
@chernozem26
@chernozem26 2 жыл бұрын
I honestly reference your videos multiple times a week at work. Big big thank you! Ps method 1
@SoulTrain101
@SoulTrain101 3 жыл бұрын
Method 3: connect all tables to each other in the data model!
@SaddamKhan-jd2sj
@SaddamKhan-jd2sj 3 жыл бұрын
How to connect tables in Data Model if I need multiple connection between all the tables??
@ronaldmacdonald7226
@ronaldmacdonald7226 Жыл бұрын
How do we do this if our excel does not have the “Get From Sheet” option? I’m trying it on PC and Mac, do not see it on either.
@Ali2692
@Ali2692 Жыл бұрын
I have the same issue
@peteroregan7786
@peteroregan7786 Жыл бұрын
@@Ali2692 same here.
@ketanmehta564
@ketanmehta564 Жыл бұрын
@@peteroregan7786 @alisson Soars @Ronald Macdonal From Table Range is same as From Sheet
@lahotipushkar
@lahotipushkar 3 жыл бұрын
Thank you so much Leila. This is so much useful. I always love watching your video. 🙏
@dearshaji
@dearshaji Жыл бұрын
Saved 20 hours of my life.. big thanks
@romualddeston3007
@romualddeston3007 2 жыл бұрын
Thank you Leila , I am working everyday on excel ( Global CPO ) , and data management is so key ! Thank you so much for your clear tips that make us easy to work and solve our daily problem !..
@LeilaGharani
@LeilaGharani 2 жыл бұрын
You're so welcome, Romuald!
@phildanley7285
@phildanley7285 Жыл бұрын
Thank you Leila! I needed help with scenario 2. You showed me my error...I created the pivot table from one table instead of from the data model. Got my slicer from the second table active now. Appreciate all of your videos!
@miriamhodorkovsky5629
@miriamhodorkovsky5629 2 жыл бұрын
This is just amazing. It seems I find answers to any work obstacle I can think of. I will try to implement method # 2
@jorgemacgenity1367
@jorgemacgenity1367 3 жыл бұрын
Great tips Leila. I needed that in the past and took me a long time to understand, set and get reasonable results. Your tips will help a lot. Thanks.
@c.mosinghi2281
@c.mosinghi2281 Жыл бұрын
leila, its not easy first time, but i have put in the hours and i have followed, now practice. thanks so much, amazing how you able to help people you even never see
@sankarn9883
@sankarn9883 2 жыл бұрын
Wow - Thankyou for guiding this steps - I was doing manually for long time -- Now Method#1 is very useful and able to make my things visible and plan accordingly. Great efforts and Appreciate your time & Efforts.
@DaoNguyen-br6qh
@DaoNguyen-br6qh Жыл бұрын
Thanks Leila. I already learned method 2 from u a year ago. Now method 1 is what i need ❤
@GiteshBajaj
@GiteshBajaj 3 жыл бұрын
You always learn something new from Leila..Thank you
@lokeshnaidu7575
@lokeshnaidu7575 Жыл бұрын
Awesome video 👍🏻👍🏻 used it step by step for my work where i did the same for 3 sheets containing 1 million rows each. Instead of pivoting 3 times, this was super helpful.
@amirsaiftaz
@amirsaiftaz 3 жыл бұрын
Great techniques from Power Query to combine multiple worksheet data.Helping a lot and time saving. Thank u.
@AP-eb8hd
@AP-eb8hd 3 жыл бұрын
Thanks & great post as usual. I like the merge feature of power query better than using the data model for 2nd scenario. There are certain advantages like using 'distinct' count in pivots made from data model, but it has to be always a 1-1 mapping.
@lulysjoy
@lulysjoy 2 жыл бұрын
I just wanted to thank you for sharing your knowledge for free. You explain extremely well and make it all so easy! Thank you!!
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad it was helpful!
@clashpoet
@clashpoet 2 жыл бұрын
Thank you! I used method 1 to solve a huge problem, an over 1,000,000 rows problem. I am pulling together a month's worth of data and it gives me over 1 millions rows, which Excel can't handle in a single sheet. So I created 2 sheets (with about 700k rows on each). But I needed to combine the data to analyze and give to my customers. Method 1 saved me. Thank you!
@mgarcia2272
@mgarcia2272 2 жыл бұрын
Extremely helpful. Amazing tutorials I must say.
@emilbaha
@emilbaha 2 жыл бұрын
Muchas gracias Leila, un par de buenos tips para agilizar el análisis.
@eminkaganoztemel9862
@eminkaganoztemel9862 2 жыл бұрын
The method one saved my life ! when i saw this comments like this, i thought that they were exaggerating. HOWEVER, honestly, with all my hearth, it saved my hours when i was dealing with huge amount of data ! Best regards.
@ahmeterdem9300
@ahmeterdem9300 2 жыл бұрын
Congrulations. Really wonderfull , i am using internet around 25 yrs. i can say thats the best explanation and very understandable video i ever seen
@Pirate_King6969
@Pirate_King6969 Жыл бұрын
I cannot explain to you that THIS, exactly THIS was what i needed to do my portfolio Project. Thanks a lot
@jamespaz4333
@jamespaz4333 3 жыл бұрын
My heart has just been pivoted. Thank you 🥰
@mateastefan8130
@mateastefan8130 Жыл бұрын
Thank you so much. You helped me crush my task. Keep it up !
@jiajiaphotography
@jiajiaphotography 3 жыл бұрын
I found both methods useful. Thank you
@everything5568
@everything5568 3 жыл бұрын
no doubt your channel is very helpful for everyone
@mamadousow4352
@mamadousow4352 3 жыл бұрын
Thx you leila for your courage.. You are doing the best
@brianwhitelaw3298
@brianwhitelaw3298 11 ай бұрын
I love your videos, they're always so informative. Thank you for all you do; it's a huge help. Keep up the great work.
@seanain1
@seanain1 3 жыл бұрын
Method two is perfect and it refreshes your skills/knowledge of Microsoft Access. Thank You.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
You are welcome!
@rahulkaushal1983
@rahulkaushal1983 Жыл бұрын
Both methods are extremely useful - thanks for this video!
@str_outta_bogda
@str_outta_bogda 2 ай бұрын
Thank you very much. You saved 50 hours for me. Top tier content and channel.
@kiotek3107
@kiotek3107 Жыл бұрын
Thank you so much Leila for the knowledge sharing. Appreciate it.
@robintanzi9046
@robintanzi9046 Жыл бұрын
Excellent, really simple easy to follow instructions. Thank you
@janithsithumina5412
@janithsithumina5412 Жыл бұрын
Thank You very much for your excellent explanation and for your free service. you are a very good teacher and again I would like to give my gratitude to you
@amrm.ghoneim2413
@amrm.ghoneim2413 3 жыл бұрын
You might be surprised knowing that I'm the only one who knows how to use power query in my organization, It really changed everything, I teach them how to use it, and all of that is because of you, Leila ❤ thank you very much, you are a very good person. BTW I'm happy that I knew both methods before watching this video.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
That is awesome!
@sarahc172
@sarahc172 2 жыл бұрын
I'll use both methods. Thank you for this very helpful video!
@Itisme177
@Itisme177 2 жыл бұрын
This is really new for me And helpful a lot with saved time too . Thank u for ur update. Please update again for subtotal And v lookups formulas
@mallorymyers7525
@mallorymyers7525 2 жыл бұрын
I spent a few hours handling scenario 1 by hand last time. I knew there must be a better way. Thank you!
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Happy to help :)
@ashmeetar
@ashmeetar 2 жыл бұрын
Great approach. Saved me so much time. Thanks for the video
@buddhistslacker
@buddhistslacker Жыл бұрын
OMG TY so much! This is exactly what I needed. I checked out a bunch of other videos to find the right one, including a few of yours.... I didn't have add from sheet so I used add from table, worked the same. I just needed a few columns from each table so I could select those few. First time using power query! Love power query! Thanks! Used method 1. Didn't need method 2 right now and great to know I should not do vlookups anymore LOL. Going to check out your xlookup tutorial next...
@AcademiaExcelPRO
@AcademiaExcelPRO 3 жыл бұрын
Excellent Method! I congratulate you for sharing this content! 👍
@hazmanhafiz
@hazmanhafiz 3 жыл бұрын
This is so helpful, I would have saved lots of time if I had known about this earlier.
@ssenjuti7770
@ssenjuti7770 3 жыл бұрын
Thank you so much. This will help in my work greatly. I learnt something smart today.
@user-cc5db1fv8d
@user-cc5db1fv8d Жыл бұрын
SIMPLY PERFECT!!! Thank you.
@tofe5974
@tofe5974 Жыл бұрын
HOLY MOLY!! I did it!! I had data with over a million rows; I separated them into tabs. This was a HUUUUUGE help! Thank you!
@LeilaGharani
@LeilaGharani Жыл бұрын
Fantastic! Great Job!
@brierleya
@brierleya 2 жыл бұрын
Awesome as always, learning so much from these! TYVM
@vamsikkrishna
@vamsikkrishna Жыл бұрын
Method-2 is easy. Great work Leila as usual
@nashidmadathilkandypara9160
@nashidmadathilkandypara9160 3 жыл бұрын
Amazing... I'm looking for this. Thank you liela.
Advanced Pivot Table Techniques (to achieve more in Excel)
11:47
Leila Gharani
Рет қаралды 1,9 МЛН
How to use Power Pivot in Excel | Full Tutorial
30:38
Kevin Stratvert
Рет қаралды 1,3 МЛН
Китайка и Пчелка 4 серия😂😆
00:19
KITAYKA
Рет қаралды 3,7 МЛН
Homemade Professional Spy Trick To Unlock A Phone 🔍
00:55
Crafty Champions
Рет қаралды 52 МЛН
Backstage 🤫 tutorial #elsarca #tiktok
00:13
Elsa Arca
Рет қаралды 44 МЛН
ТАМАЕВ vs ВЕНГАЛБИ. ФИНАЛЬНАЯ ГОНКА! BMW M5 против CLS
47:36
Create Excel Pivot Table from Multiple Sheets: The FASTEST Way
10:31
Teacher's Tech
Рет қаралды 11 М.
Make Pivot Table from Multiple Sheets in Excel
12:35
Kevin Stratvert
Рет қаралды 267 М.
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 191 М.
Consolidate & Clean Multiple Excel Sheets in One Pivot Table
9:06
Leila Gharani
Рет қаралды 1 МЛН
Try This New Formula Instead of Pivot Tables
12:08
Kenji Explains
Рет қаралды 207 М.
You Won't Believe These Crazy PIVOT TABLE Hacks!
11:30
Leila Gharani
Рет қаралды 667 М.
EASILY Combine Multiple Excel Sheets Into One With This Trick
8:48
Kenji Explains
Рет қаралды 234 М.
Китайка и Пчелка 4 серия😂😆
00:19
KITAYKA
Рет қаралды 3,7 МЛН