Struggling to manage your data? Learn Pivot Tables and save hours every week! 👉 link.xelplus.com/yt-g-multiple-sheets-pivottable Want to follow along? Download the exact file I used here: pages.xelplus.com/pivottable-multiple-sheets-file
So often using the old ways becomes habit, wasting time and energy, these tips honestly have been an incredible eye opener, and are very appreciated. Thank you for making the instruction so easy to understand, and meaningful. I am looking forward to some time off, where I can purchase a course or two and finding out what new things I've missed. Thank you again.
I’ve been heavily using power queries for two years in my job as data analyst. In 9 minutes i have just learned several things which has already drastically changed forever my ways of doing excel.
You are a terrific teacher, thank you. The content is always relevant and you make it easy to understand with just the right amount of details and explanation.
What great information! I'm an experienced SQL and Powershell developer, Power Query has changed everything about the way I manipulate data. Your class is without a doubt the best $55 I have ever spent on education, it helped me to go from 0--100 in record time. Thanks a bunch!
Leila strikes back again...You just answered a ton of questions I had in one simple video. I am starting to think that you're somehow reading my mind! Thank you very much, you are the best!
This helped me so much on a report that I was breaking my head with and not being able to get around to what I was trying to accomplish. But since I learning and watching this short video, I managed and resolved my issue and nailed what I was trying to complete. Thank you so much for this!
Your instruction are so easy to follow. Thank you for taking the time to make these videos. You have made my job so easy. I need to make time to take your Power Query class.
Madam, thank you very much for explaining in details the steps involved to create an automated report. After watching the above video, I started using the above method and I got very appreciated by our colleagues for my speed in reporting. All thank to you only. Thank you once again.
I keep learning something New Every Day with you. You are making me change the way the World looks Daily by data. You deserve the 5 🌟 starts. You are Awesome
wonderful and timely. The find/replace does change ALL 6/ to 7/ so at 8:15 of video the date 6/6/2020 becomes 7/7/2020 (row 33 of data). So any interation of 6/ (i.e. 16/, 26/ 36, etc.. will change). Still this is just wonderful. Thank you.
Thank you Leila! Not having a lot of knowledge in Excel, and English not being my mother tongue, I can easily follow your explanations using the “pause” button (thank God 😊!). Thanks to you, Excel doesn’t seem inaccessible. So, thank you very very much, Leila 😊!! S. 🌸
I just finished writing on another channel that they had the easiest solution for this problem...but I think you do! We have a timesheet workbook for each employee with a tab for each 2 week pay period. Each tab list what they did, where they did it, how long it took to do it, and the date they did it. This all gets entered into another spreadsheet but we add it manually, one sheet at a time. This reduces that to one entry per person per year from 24 entries per person per year.
I can listen to Leila say the word "data" all day. Am I alone on this? Seriously though, Leila, your tutorials are amazing and tremendously helpful. Thank you for all you do!
I’m repeatedly impressed by your tutorials, so I’m heading over to the site to commit to the Power Course. (Even though I’m still stuck in 2016... Hopefully, my office will catch up someday!)
I felt like I knew Excel really well, then I started watching your videos about PowerQuery. How did I miss this!? Thanks, as always - terrific video! I'm enjoying your VBA course, and I think I'll need to do the PowerQuery course next.
Update - I used this to simplify a task at work yesterday. I was planning on a couple hours to format things the way I needed, but with what I learned here, it took more like 15 minutes. Thank you!
You are an excellent teacher with a real good understanding of what we would like to learn and you cover your topics very comprehensively. Thank you for your hard work on this.
OMG! Just what I was looking for! I don’t know how I landed to your site but you’ve got yourself a new subscriber! Thanks for this, I was pulling my hair dealing with so much data... live saver! 🎉🤗🥳🥰
I can only say A BIG THANK YOU, I have been looking for ways to do this and it has been really stressful using VBA code and OFFSET function to do this... Thanks
This would have samed me a lot of time a few weeks ago! But I have it for next time. Thank you for all your very clear and relevant content. Much appreciated 🙏
That is very excellent presentation, I appreciate your passion for excel and way of teaching and Thanks for that and finally I have one question which is what excel version should I be using to apply this formula and use it for my work, Thanks again for teaching us.
You can use Power Query from Excel 2016 onwards. You will have to use a workaround to load the data to a Pivot Table though. So, I recommend at least Office 2019 or ideally 365 for the latest features.
Hi Leila, I am looking for your video on how to split data in rows into multiple sheets (with fix no. of rows per sheet) Thank you very very much. Have A Great Weekend.
This is Amazing ,Leila great work, i always learn something new from your videos & your videos are always unique ,thankyou so much leila, keep supporting us with ur knowledge & we will support your videos by sharing with others :) Have a great Day.
You are always my first goto when I need to know how to do something, or do something better, in Excel. Just as an FYI, when you did the replace on 6/, you also changed 6/6/2020, 6/16/2020, and similar numbers to 7/7/2020 and 7/17/2020. I know it was for testing purposes, but how would you prevent that from happening? I know how to do it in other contexts with regular expressions, but not in Excel.
Thanks! True. It would have been a problem even with training data had I changed 9 to 10. If I wanted to use search and replace I'd probably a) replace /2020 with $2020 b) Replace 6/ with 7/ c) Replace $ with /
Loving the content With your knowledge, do you know a good method to compare changes between two sheets? I often get material catalogs with either a part number updated (description, price, etc remains the same), a description change, or materials removed/added It's very tedious to try and find the differences between the sheets when there are thousands of parts Do you have a trick up your sleeve or a suggestion that could help me, please?
No expert here, so just while you're waiting for one :) 1. Check out Beyond Compare from Scooter Software, it's excellent-I don't need it much in recent years, but used it for about a decade before. The "Table Compare" function might do it for you. 2. I do similar to your task daily using Access with Excel, so I'll bet PQ has a way. If you know Access: I have 2 main tables, Today and Yesterday. I made a bunch of simple queries in Access to provide the various infos I need; my workbook has sheets which pull info from each query into separate sheets, with the totals summarized in a Summary sheet. This workbook never changes, just needs a refresh each day. The trick in Access is each day I delete the Yesterday table and then rename the Today table to Yesterday. Then I import the latest supplier catalog-after running a brief cleaning macro on it-into an Access table and name it Today. This method preserves all the Access queries because the 2 table names they use still exist. ~ Leila accomplished a similar trick with her 'Data_" named ranges, so I'm pretty sure PQ can do this job. It might need more than one PQ, perhaps a separate one for each different piece of info you need-but that's not a problem since each would only be a one-off setup. I'm interested, hopefully Leila will pitch in.
@@danielj436 "I'm new to PQ" Yeah, me too. Have you seen Leila's earlier video? How Power Query Will Change the Way You Use Excel th-cam.com/video/6lBqYInBldk/w-d-xo.html
@@danielj436 Have a look into the Merge Queries option. That will solve your problem and is easy to setup once you've determined exactly what is you want.
I have always wanted to learn Excel. It would solve so many issues for me. I nearly gave up until I discovered your videos. What order do you recommend I watch them in?
Thank you this exist? OMG. I only knew PowerPivot which are also very useful, and easier though, but they are used in different ways, This tool you explain is for consolidation I was doing it in the manual way OMG. I recommend everyone learn power pivot to create pivot tables of information from different data bases relationed
Struggling to manage your data? Learn Pivot Tables and save hours every week! 👉 link.xelplus.com/yt-g-multiple-sheets-pivottable
Want to follow along? Download the exact file I used here: pages.xelplus.com/pivottable-multiple-sheets-file
I'm following the complete Power Query Course and it litterally changed everything. Life is so much easier at work when I have to manipulate data !
Glad you like the course, Vincent!
Leila Gharani is the absolute best. 50% of my TH-cam suggestions are her videos at this point and I watch almost all of them.
I've watched half a dozen pivot table videos, and yours is by far the easiest and most complete. Great job thank you! Jim in FL
Wow, thanks!
So often using the old ways becomes habit, wasting time and energy, these tips honestly have been an incredible eye opener, and are very appreciated. Thank you for making the instruction so easy to understand, and meaningful. I am looking forward to some time off, where I can purchase a course or two and finding out what new things I've missed. Thank you again.
I’ve been heavily using power queries for two years in my job as data analyst. In 9 minutes i have just learned several things which has already drastically changed forever my ways of doing excel.
That's great. I'm glad it was helpful.
The absence of skill makes a man sweat when faced with tasks. Thank you for adding value Leila.
You are nothing short of a wizard, thank you!!
You are a terrific teacher, thank you. The content is always relevant and you make it easy to understand with just the right amount of details and explanation.
thanks for teacher Leila Gharani, the power query useful to compile all the database together. much appreciate to you
What great information! I'm an experienced SQL and Powershell developer, Power Query has changed everything about the way I manipulate data. Your class is without a doubt the best $55 I have ever spent on education, it helped me to go from 0--100 in record time. Thanks a bunch!
Leila strikes back again...You just answered a ton of questions I had in one simple video. I am starting to think that you're somehow reading my mind! Thank you very much, you are the best!
You are so welcome!
This helped me so much on a report that I was breaking my head with and not being able to get around to what I was trying to accomplish. But since I learning and watching this short video, I managed and resolved my issue and nailed what I was trying to complete. Thank you so much for this!
Your instruction are so easy to follow. Thank you for taking the time to make these videos. You have made my job so easy. I need to make time to take your Power Query class.
Great to hear! Power Query is the best :)
Hi! I have been watching your videos since 2020 and it's amazing how my excel skills advanced since!
One of the best tutorials I have ever seen.
Thank you, Rafael!
This is perfect! I have always needed to be better about this when working in excel thank you for the amazing tutorial Leila :)
Madam, thank you very much for explaining in details the steps involved to create an automated report. After watching the above video, I started using the above method and I got very appreciated by our colleagues for my speed in reporting. All thank to you only. Thank you once again.
it never fails.. The Queen make it looks easy
Brilliant! Thanks Leila. I needed to pull data from several tabs into a front sheet to meet different team needs and this coding did the trick!
Mind blown! You learn so much in one video ❤ Thank you Leila
I keep learning something New Every Day with you. You are making me change the way the World looks Daily by data. You deserve the 5 🌟 starts. You are Awesome
Leila, your examples are so realistic. Thank you so much!
Cant't wait for the company I work for to install Power Query, it is making things so easy.
Yep, I agree
That is amazing Leila. You always bring something new, mostly excel users are unaware of this. Powerquery 👍
You're right, I have been following Leila and improving my advanced-level skills. Thanks Leila
Wow, I wasn't familiar with PowerQuery.
Thank you! 😃
wonderful and timely. The find/replace does change ALL 6/ to 7/ so at 8:15 of video the date 6/6/2020 becomes 7/7/2020 (row 33 of data). So any interation of 6/ (i.e. 16/, 26/ 36, etc.. will change). Still this is just wonderful. Thank you.
I love the energy of explaining!
Hello Leila! I'm from Brazil and I'm very happy to have access to your videos, which are always very good. Thank you so much for the smart content!
This video is awesome. You are #1 in the world when it comes to PQ.
Wow, thank you!
I have purchased all of Leila's courses on Udemy. She is an amazing teacher and teaches with scenarios that I can use in my work.
Thank you Leila! Not having a lot of knowledge in Excel, and English not being my mother tongue, I can easily follow your explanations using the “pause” button (thank God 😊!). Thanks to you, Excel doesn’t seem inaccessible. So, thank you very very much, Leila 😊!! S. 🌸
Happy to hear that!
I love you leila. This just saved me a truckload of work
Thanks
Thank you, Andren!
I just finished writing on another channel that they had the easiest solution for this problem...but I think you do! We have a timesheet workbook for each employee with a tab for each 2 week pay period. Each tab list what they did, where they did it, how long it took to do it, and the date they did it. This all gets entered into another spreadsheet but we add it manually, one sheet at a time. This reduces that to one entry per person per year from 24 entries per person per year.
I can listen to Leila say the word "data" all day. Am I alone on this? Seriously though, Leila, your tutorials are amazing and tremendously helpful. Thank you for all you do!
It's my pleasure, Brad!
Super awesome !! Leila you're an academic philanthropist !!:)
Thanks!
Thank you, Suzy!
In the 25 first second of video , you just described my issue. OMG I’m going to have such a blast watching you 🙈
You have great skills to explain various Excel topics in a very clear way
Glad you think so!
I’m repeatedly impressed by your tutorials, so I’m heading over to the site to commit to the Power Course. (Even though I’m still stuck in 2016... Hopefully, my office will catch up someday!)
This channel deserves more than a million subs
Thank you leila. You just made my life really easy in office
Thanks Leila. That was explained very well.
Hello Mam your all learning videos are very useful...
Thanks 👍
: From India 🇮🇳
Excellent explanation ..... powerful knowledge on PowerQuery
Thank you so much, you're explaining in a very easy way.
Excellent masterclass. Thank you very much Leila for touching so many points of interest.
Glad you enjoyed it, Iván!
I felt like I knew Excel really well, then I started watching your videos about PowerQuery. How did I miss this!? Thanks, as always - terrific video! I'm enjoying your VBA course, and I think I'll need to do the PowerQuery course next.
Update - I used this to simplify a task at work yesterday. I was planning on a couple hours to format things the way I needed, but with what I learned here, it took more like 15 minutes. Thank you!
WAOO---QUEEN IS ALWAYS QUEEN---distribute your knowledge to others get the result..
I took your full powerquery course and it was very well done and helpful to my career. Thanks for another amazing course!
AMAZINGGGG JUST WHAT I NEEDED THANK YOU
Our pleasure!
Wow, I am deeply impressed with your expertise. This knowledge will help me a lot in my projects. Thank you very much!!
You're absolutely amazing! I have been adding each table manually to append, until now. Many thanks
My pleasure :)
@@LeilaGharani hi Leila
Hi Leila,
Your tutorials have always been a go to for me recently. Thanks for the knowledge you share. ❤❤
You are an excellent teacher with a real good understanding of what we would like to learn and you cover your topics very comprehensively. Thank you for your hard work on this.
Lifesaver! urgent need for this function!
Great content as always, will definitely steal the blank query trick for next time!
OMG! Just what I was looking for! I don’t know how I landed to your site but you’ve got yourself a new subscriber! Thanks for this, I was pulling my hair dealing with so much data... live saver! 🎉🤗🥳🥰
That's great. Welcome aboard!
Thank you for making it simple to understand! 10/10
Wow...that's the beauty of PQ..❤❤
Power query is very useful. Thanks Leila...
I can only say A BIG THANK YOU, I have been looking for ways to do this and it has been really stressful using VBA code and OFFSET function to do this... Thanks
My pleasure :)
This would have samed me a lot of time a few weeks ago! But I have it for next time. Thank you for all your very clear and relevant content. Much appreciated 🙏
I Always learn something new whenever I watch your videos. Endless lessons. Thank you Leila
Love from India and me . You are amazing. Superb video
Thank You. very clear explanation. Your effort is highly appreciated.
Brilliant as ever Leila. Please keep doing what you do. It’s really kind and helpful.
Thanks Martin!
This is just perfect! Just what I would need for some of my work. Clearly explained. Thanks Leila.
Ohh de de los
Ohh de is an
Ohh
This is what I only do in work. I even merge queries as a dynamic filter and as a Vlookup alternative.
Great tutorial. learned at 0 cost. Thank You so much.🤩
Magical ........................Thanks Leila 👌😃
Thank you Leila, it's an amazing session.
Thanks for the informative videos. which version of Office do you use?
We're using Microsoft 365.
Thanks so much from Cambodia.
Thank you, Leila!!
Wow
Thank you Leila for sharing this video
You are a MS Excel Genius
Wow, thank you
No words for that, total love!
Thank you :)
Amazing,,, thanks you 👍👍👍
Dear Teacher Thank You millions.......save my life
Very good explanation. You've covered a number of interesting features in Power Query in a succinct video. Thank you.
Thanks so much. You make it so simple.
Very good explanation. Thank you.
perfect - as always, thank you!
Amazing. Thank you Leila. You've save me a lot of time.
Leila, awesome job!
Perfect...exactly what I was looking for. Kudos
That is very excellent presentation, I appreciate your passion for excel and way of teaching and Thanks for that and finally I have one question which is what excel version should I be using to apply this formula and use it for my work, Thanks again for teaching us.
You can use Power Query from Excel 2016 onwards. You will have to use a workaround to load the data to a Pivot Table though. So, I recommend at least Office 2019 or ideally 365 for the latest features.
Hi Leila, I am looking for your video on how to split data in rows into multiple sheets (with fix no. of rows per sheet) Thank you very very much. Have A Great Weekend.
This is an excellent video Leila. I learned and got inspired from Leila so much that I have started my own channel where I teach Excel VBA. 👍👍👍
Hey, great to hear this. I just subscribed to your channel and also watched few videos. They are really good. Looking forward to learn more from you.
This is beautiful, exactly what I needed
This is Amazing ,Leila great work, i always learn something new from your videos & your videos are always unique ,thankyou so much leila, keep supporting us with ur knowledge & we will support your videos by sharing with others :) Have a great Day.
You are completely amazing. Thank you for all you do!!!
Wow, thank you!
You are always my first goto when I need to know how to do something, or do something better, in Excel. Just as an FYI, when you did the replace on 6/, you also changed 6/6/2020, 6/16/2020, and similar numbers to 7/7/2020 and 7/17/2020. I know it was for testing purposes, but how would you prevent that from happening? I know how to do it in other contexts with regular expressions, but not in Excel.
Thanks! True. It would have been a problem even with training data had I changed 9 to 10. If I wanted to use search and replace I'd probably a) replace /2020 with $2020 b) Replace 6/ with 7/ c) Replace $ with /
First time seeing this. Super amazing .Thank you.
You’re welcome 😊
Loving the content
With your knowledge, do you know a good method to compare changes between two sheets?
I often get material catalogs with either a part number updated (description, price, etc remains the same), a description change, or materials removed/added
It's very tedious to try and find the differences between the sheets when there are thousands of parts
Do you have a trick up your sleeve or a suggestion that could help me, please?
No expert here, so just while you're waiting for one :)
1. Check out Beyond Compare from Scooter Software, it's excellent-I don't need it much in recent years, but used it for about a decade before. The "Table Compare" function might do it for you.
2. I do similar to your task daily using Access with Excel, so I'll bet PQ has a way. If you know Access:
I have 2 main tables, Today and Yesterday.
I made a bunch of simple queries in Access to provide the various infos I need; my workbook has sheets which pull info from each query into separate sheets, with the totals summarized in a Summary sheet. This workbook never changes, just needs a refresh each day.
The trick in Access is each day I delete the Yesterday table and then rename the Today table to Yesterday. Then I import the latest supplier catalog-after running a brief cleaning macro on it-into an Access table and name it Today. This method preserves all the Access queries because the 2 table names they use still exist.
~
Leila accomplished a similar trick with her 'Data_" named ranges, so I'm pretty sure PQ can do this job. It might need more than one PQ, perhaps a separate one for each different piece of info you need-but that's not a problem since each would only be a one-off setup. I'm interested, hopefully Leila will pitch in.
@@silversolver7809 Thanks, I'll check out Beyond Compare and possibilities of PQ. I'm new to PQ tho.
@@danielj436 "I'm new to PQ"
Yeah, me too. Have you seen Leila's earlier video?
How Power Query Will Change the Way You Use Excel
th-cam.com/video/6lBqYInBldk/w-d-xo.html
@@danielj436 Have a look into the Merge Queries option. That will solve your problem and is easy to setup once you've determined exactly what is you want.
I have always wanted to learn Excel. It would solve so many issues for me. I nearly gave up until I discovered your videos. What order do you recommend I watch them in?
It will be difficult to learn Excel just from isolated TH-cam videos. I recommend taking a structured online course.
@@LeilaGharani Thank you. Do you reccomend any in particular?
Thanks Leila, for sharing this concept, and huge congratulations 🎉 to reaching 500 k plus subs.
Thank you! 😃
Thank you this exist? OMG. I only knew PowerPivot which are also very useful, and easier though, but they are used in different ways, This tool you explain is for consolidation I was doing it in the manual way OMG. I recommend everyone learn power pivot to create pivot tables of information from different data bases relationed
Great video Leila!
So many hacks in one video... Thank you 👍👏👏
Thank you so much Leila this has really helped me with my current project
Glad it helped!