Master Financial Analysis in 30 Minutes! 🚀 Start our FREE course now and learn the basics fast. No strings attached! 👉 link.xelplus.com/yt-free-finance-basics
I've never worked with merge columns before. Thanks for sharing this golden nugget. This surely would make my life much easier than writing if statements.
Fantastic video Leila. The Hot tip is at 14:50 frame. Not many people know that one can in fact do find and replace inside the formula. One can do find and replace the cell ranges in the formula as well. That's really pro way of using Excel. Thanks Cheers :)
I enjoyed the fill function on Account. I wish I could use that. However data has account in the same column as date i want to remove I want to put account into its own column and date in its own column. How do I do that?
never used power query before but i do data cleanup manually. will do this next time as we always receive revised data from our clients. this is far more efficient! Thank you so much. Big 4 auditor here. yeah wish me luck this busy season.
I'm so glad I found your UA-cam channel. I am doing some volunteer work and previously it took our volunteer treasurer 5+ hours to make the summary financial report that are distributed monthly. Your videos have allowed me to develop my basic Excel skills and automate and upgrade the reports. This video will help in the still time consuming task of cleaning up our source data. Thank you so much. I do have one problem - as I transfer values about, my formatting changes. Certain reports have unique formats due to their layouts, and the same information goes into different reports so setting the source format to match the final destination format doesn't work. If you point me in the right direction for this I would appreciate it.
Every day I do in my office place, I do same thing by manually data export to excel from Oracle database by "copy and move" making another worksheet not to destroy original format, Will try this time your rules and format, hopefully I will manage it. Thank you for your wonderful lesson and video.
An excellent job Leila. Let's hope that senior management (usually with little knowledge of data analysis) watch your video and open their eyes. Thank you!
Sooooooooooo much to think about .... how can one person deliver sooooo much information so effortlessly? .... so good ... so good ... so good ... thank you ...thank you ... thank you ...
It would be cool if you uploaded a file with data from the example.When you do everything with your own hands, it's better to remember.Amazing Leila.Amazing video.Thank you!
@@MrSupernova111 Which course you mean? I have subscribed Leila's Master Excel Power Query Beginner to Advanced (including M) course, but this training material is not included.
You always turn up when I am in desperate need of help!! I literally stopped right away to take notes! !! It coincide EXACTLY with what I was struggling to finish!! Thanks Leila!! 🤭 You have NO idea how you’re helping people to progress with their jobs!! I will NEVER forget you! 💋💋💋🌹
What a fantastic tutorial! I get files with European numbering system and I used to use to Substitute function in Excel to replace comma with dots and vice versa. Thanks to this video, I'll start using Power Query now.
I have used your videos to learn power query and introduce so many efficiencies for my team. Converting the currency with locale was so useful in automating a bank statement import from Euro format. Thank you for these videos!
Thank you very much, you are The EXCEL ANGEL you changed my perception toward excel and data analysis, I am grateful that I meet you on UA-cam, and i am thinking of subscribing to SkillShare to follow your courses and interact with you for some coaching, Thank you very much Leila.
That was the most fantastic 20 min video on cleaning Data, and also includes a lot of tricks for fast work I always enjoy ur videos and waiting for more like this one. Thank u a lot for that.
Brilliant!! I work in finance and every reporting period we have to merge about 20 data tables, group the data by classification, and generate a client report by groupings which vary per client. About a year ago I created an Excel template using nothing but Excel functions. While the template works fine because there are only about a thousand rows of total data, updating the file manually each quarter takes a while because there are about 20 tables that must be added/appended manually. Also, the output page was challenging to create as I need to filter out blank rows and maintain the integrity of each grouping. Imagine a single client report with up to 20 data tables for each grouping. I'm going to re-haul the template using Power Query so in the future all we need to do is drop the client performance data and have Power Query merge and transform the other data directly from the source files (about 20) like you did here. Thank you for another amazing video! Cheers!
AMAZING video. Data cleansing has been an ongoing nightmare and now I’m looking forward to using all your tricks.. nearly everything you covered will come in handy... THANK YOU
I dont know why I watched this, I know how to do everything you've just explained. However..... Your videos are presented so well, the window/screen positioning and helpful Keyboard shortcuts and Highlighted overlays markers you put up make following these tutorials so good and helpfult o noobies. Great work! 👍
Leila Many thanks for this, that really showed me how Power Query could help me as an accountant. I am enjoying your Power Query course on Udemy as well. Hopefully I will be an Excel power user soon.
Thanks for the video. If some of the rows have only text and others have numbers only then how do I split these into two columns based on characters and values?
I wish that you offered beginning to intermediate/advanced accounting practice files and tutorials (interactive) - maybe in the future...this info is also great...
well done. But if this were my task to do, i would not remove the "absolute difference" column and the Sum rows (e.g. "Other Revenue") They are the perfect information to check your work for errors. In accounting and controlling, you always must assume that something will not add up correctly, and that you will have to search where the error originates. But i like the clean-up process.
Amazing, great vid, very clear, love the format of your videos. Loved the correction on the vid highlighting the correct spelling of the description typo 10:54... shows what you're all about... Appreciated :)
Thank you for the awesome video, however I think a good practical way of teaching us is to upload a file, any file, for us to download and follow your lead, that’s practical learning. Thank you.
Awesome lesson Leila! Power Query is super useful for so many things. Thanks for the demo of how to expand it to tasks beyond just combining tables. Thanks for sharing and Thumbs up!!
Hi this is actually what I am doing in my daily business. I would however strongly recommend to use Excel export from SAP as it is more reliable. Otherwise it is always interesting to see the various approaches to a particular issue. Thanks 😊
Do you have a downloadable version of this dataset so I can practice along with you? I have been binge watching all of your videos recently so many great tips and tricks too.
wow, fantastic, amazing I am start running out of words This is the type of content we need, how to deal with real day to date work data , and problem solving it by efficient way, I am glad i found your channel couple years ago, it's one of my top 5 favorite UA-cam channels. Great video Leila as always
As usual, Fantastic. I believe many people would like to learn more about these kind of tasks. I highly recommend Leila's course "Power Query - Including M". Truly a masterpiece.
Hi Leila, I love all of your videos! I have a question, when I use PQ to get data from text file, PQ imports it as one column instead of multiple columns, not like in your example. How can I fix it? Thanks!
The old problem of getting data from a report. Legacy reports need to be banished and replaced by data exports. I prefer Tab separated text files because they are easy to work with, though not as good as a direct connection. This demonstration demonstrates the advantage of PowerQuery, which exist in Excel and PowerBI. Parsing data, regardless of the tool, is knowledge that will advance any career.
Thanks for the great tutorial, Leila! But just in case others are trying to find another way to clean data, especially contact list, data appending will do the job instantly.
Dear Leila, Thanks a lot for sharing the amazing knowledge with us. I really enjoyed the video and learned a lot. Once again Thank you so much for your need of the hour video.👍👌🙏
Master Financial Analysis in 30 Minutes! 🚀
Start our FREE course now and learn the basics fast. No strings attached! 👉 link.xelplus.com/yt-free-finance-basics
can we have the raw data for us to practice. Thank you i am learning a lot from you
I've never worked with merge columns before. Thanks for sharing this golden nugget. This surely would make my life much easier than writing if statements.
You're very welcome, Alex!
Fantastic video Leila. The Hot tip is at 14:50 frame. Not many people know that one can in fact do find and replace inside the formula. One can do find and replace the cell ranges in the formula as well. That's really pro way of using Excel. Thanks Cheers :)
Thanks Sachin!
I didn't know I could do that. It would have been handy many times in the past!
Thanks!
Thank you!
Excellent. This lecture is most relevant to me as a financial management specialist. Thank you Leila Gharani.
You're most welcome!
This is the closest video on ERP generated data. Huge thumbs up for introducing these clean up methods. Thanks a ton
I enjoyed the fill function on Account. I wish I could use that. However data has account in the same column as date i want to remove I want to put account into its own column and date in its own column. How do I do that?
never used power query before but i do data cleanup manually. will do this next time as we always receive revised data from our clients. this is far more efficient! Thank you so much. Big 4 auditor here. yeah wish me luck this busy season.
I'm so glad I found your UA-cam channel. I am doing some volunteer work and previously it took our volunteer treasurer 5+ hours to make the summary financial report that are distributed monthly. Your videos have allowed me to develop my basic Excel skills and automate and upgrade the reports. This video will help in the still time consuming task of cleaning up our source data. Thank you so much.
I do have one problem - as I transfer values about, my formatting changes. Certain reports have unique formats due to their layouts, and the same information goes into different reports so setting the source format to match the final destination format doesn't work. If you point me in the right direction for this I would appreciate it.
Every day I do in my office place,
I do same thing by manually data export to excel from Oracle database by "copy and move" making another worksheet not to destroy original format,
Will try this time your rules and format, hopefully I will manage it.
Thank you for your wonderful lesson and video.
Leila, no one else I have found explains Excel as well as you do. Thank you!!
Glad it was helpful, Natalie!
An excellent job Leila. Let's hope that senior management (usually with little knowledge of data analysis) watch your video and open their eyes. Thank you!
Sooooooooooo much to think about .... how can one person deliver sooooo much information so effortlessly? .... so good ... so good ... so good ... thank you ...thank you ... thank you ...
Wow, thank you!
It would be cool if you uploaded a file with data from the example.When you do everything with your own hands, it's better to remember.Amazing Leila.Amazing video.Thank you!
You can pay for her course and get her training materials.
@@MrSupernova111 Which course you mean? I have subscribed Leila's Master Excel Power Query Beginner to Advanced (including M) course, but this training material is not included.
Hi you can practice from another video, where all the case studies are practically executed - ua-cam.com/video/cx1qosaiLu8/v-deo.html
Thanks
Thank you!
You always turn up when I am in desperate need of help!! I literally stopped right away to take notes! !! It coincide EXACTLY with what I was struggling to finish!! Thanks Leila!! 🤭 You have NO idea how you’re helping people to progress with their jobs!! I will NEVER forget you! 💋💋💋🌹
Perfect!
You are definitely goddess of MS Excel😇
What a fantastic tutorial! I get files with European numbering system and I used to use to Substitute function in Excel to replace comma with dots and vice versa. Thanks to this video, I'll start using Power Query now.
That's a good idea! Power Query also has a "replace" feature. Many ways to do this one.
I have used your videos to learn power query and introduce so many efficiencies for my team. Converting the currency with locale was so useful in automating a bank statement import from Euro format. Thank you for these videos!
From all video i watch from your channel, i like this most.
You explain it in a more constant tempo and not to fast. Thanks.
Glad to hear that!
This is well-presented and taught-out! Just what I need Leila!
Our pleasure :)
Nice examples Leila. Very detailed. Great job! Have a nice weekend.
Thank you! 😃
Thank you very much, you are The EXCEL ANGEL you changed my perception toward excel and data analysis, I am grateful that I meet you on UA-cam, and i am thinking of subscribing to SkillShare to follow your courses and interact with you for some coaching, Thank you very much Leila.
The tutorial was good! But without practice file it's hard to learn power query.
Just one word .... Leila you are a genius! congratulations on your videos
That was the most fantastic 20 min video on cleaning Data, and also includes a lot of tricks for fast work I always enjoy ur videos and waiting for more like this one.
Thank u a lot for that.
Glad you liked it!
Your tutorial never been disappointed. Accounting life will be easier with it. Thanks goddess Excel!
You're so welcome!
❤❤❤❤❤ Five out of five hearts! Thank you. This will save me HOURS per month!
Brilliant!! I work in finance and every reporting period we have to merge about 20 data tables, group the data by classification, and generate a client report by groupings which vary per client. About a year ago I created an Excel template using nothing but Excel functions. While the template works fine because there are only about a thousand rows of total data, updating the file manually each quarter takes a while because there are about 20 tables that must be added/appended manually. Also, the output page was challenging to create as I need to filter out blank rows and maintain the integrity of each grouping. Imagine a single client report with up to 20 data tables for each grouping. I'm going to re-haul the template using Power Query so in the future all we need to do is drop the client performance data and have Power Query merge and transform the other data directly from the source files (about 20) like you did here. Thank you for another amazing video! Cheers!
Thanks Leila for your tips...Hope You, fmly and all team always healthy and happy to help
What a marvelous way of explanation.......... Excellent ....... Well done.... thanks a lot.............. loads to learn from you
AMAZING video. Data cleansing has been an ongoing nightmare and now I’m looking forward to using all your tricks.. nearly everything you covered will come in handy... THANK YOU
Wonderful!
Great, I m SAP user , I was looking for this material
Thanks
Wow, it's magic... I have to askmy boss for a laptop for home working So I can practice this right here... I love it :-)
I dont know why I watched this, I know how to do everything you've just explained.
However.....
Your videos are presented so well, the window/screen positioning and helpful Keyboard shortcuts and Highlighted overlays markers you put up make following these tutorials so good and helpfult o noobies. Great work! 👍
Leila Many thanks for this, that really showed me how Power Query could help me as an accountant. I am enjoying your Power Query course on Udemy as well. Hopefully I will be an Excel power user soon.
Super !
I have joined the courses, the course is so great, response to your queries promptly.
Of course, depends on your subject.
Eric
Thank you so much Leila!!! You’re the best!
Fantastic like all your videos! PLEASE more tutorials on importing SAP data in excel.
Excellent Tutorial, Leila you are really brainy, you saved my time of dirty laundry washing (reports from our ERP)
Outstanding Video, Leila!!
Thank you! 😁
Very useful tutorial. Nicely presented.
Thank you...! 😊😊
Most welcome 😊
OMG !!! quick steps and then boom I Become a Pro thanks to you, very useful your tutorial, I subscribe and start to follow you, thank you very much
Awesome, thanks for the sub!
Thanks for another great video Leila! I just started your Power Query course and so far it is fantastic!
Thanks for the video. If some of the rows have only text and others have numbers only then how do I split these into two columns based on characters and values?
I wish that you offered beginning to intermediate/advanced accounting practice files and tutorials (interactive) - maybe in the future...this info is also great...
Hello Leila, thank you for your tutorial. Is there any chance to get this raw data to practice with you?
Thanks.
well done.
But if this were my task to do, i would not remove the "absolute difference" column and the Sum rows (e.g. "Other Revenue")
They are the perfect information to check your work for errors.
In accounting and controlling, you always must assume that something will not add up correctly, and that you will have to search where the error originates.
But i like the clean-up process.
Good point, Franz. Thank you for the feedback!
Amazing, great vid, very clear, love the format of your videos. Loved the correction on the vid highlighting the correct spelling of the description typo 10:54... shows what you're all about... Appreciated :)
Thanks for the kind feedback, Eddie!
Thank you Leila! Great video that will help people to save loads of time!
Glad you think so, Lorenzo!
If my accounting teacher was half as good looking as you I might have actually showed up for class!
Leila, you are the best!
😊
Thank you for the awesome video, however I think a good practical way of teaching us is to upload a file, any file, for us to download and follow your lead, that’s practical learning.
Thank you.
I love to listen your classes... Thank you❤
leila plz comment on the files not included too... you are a genius..
Great video as always, this is what I have been looking for quite sometimes, thanks Leila!
Thank you!! This is so helpful for my current task!!
Leila - Many thanks - just to check whether its possible to get these sample data excel files for us to try
Awesome lesson Leila! Power Query is super useful for so many things. Thanks for the demo of how to expand it to tasks beyond just combining tables. Thanks for sharing and Thumbs up!!
😘
Thanks a lot for sharing great knowledge with you tube family.
Just want download these files for practicing purpose . Can get link for the same .
Good job, Leila!
Awesome one please do share the master sheets along with the video so that we can practice on it as it will help in learning.
Such a great tutorial. Well edited.
Thanks so much!
Hi this is actually what I am doing in my daily business. I would however strongly recommend to use Excel export from SAP as it is more reliable. Otherwise it is always interesting to see the various approaches to a particular issue. Thanks 😊
great learning love to do cleaning data
Do you have a downloadable version of this dataset so I can practice along with you? I have been binge watching all of your videos recently so many great tips and tricks too.
I feel lucky to see your video!
Its really great ! Thanks a lot for this video!
wow, fantastic, amazing
I am start running out of words
This is the type of content we need, how to deal with real day to date work data , and problem solving it by efficient way, I am glad i found your channel couple years ago, it's one of my top 5 favorite UA-cam channels.
Great video Leila as always
Thank you for your support!
Thank you and god bless you miss. greeting from Indonesia
great video! recently run into an issue trying to turn 2016-2018 to 2016,2017,2018 ; any idea what formula/function would do it?
As usual, Fantastic. I believe many people would like to learn more about these kind of tasks. I highly recommend Leila's course "Power Query - Including M". Truly a masterpiece.
Wow, Excellent Video! 👌 Thanks for sharing some super ideas for setting up data that are surely going to help me a lot! Waiting for more!😊👍
Thank you!
Great learning content!
Is there any chance you have an example SAP data txt file, that i can practice with? - Would really help me out alot
Well done Leila very impressive. Thank you so much I'm learning a lot from you hey
Thanks Leila.. Power Query is fantastic. I use it everyday in my workflow. Great tutorial.
It really is! Thanks, Matt!
Great video with real life problems. Thanks.
Thank you, Claire.
Thank you Leila
this tutorial is amazing.... i just need to practice is more
Ausgezeichnet! Vielen Dank! This is a powerful time saver for all of us working with ERP data dumps.
You use very good techniques, impressive.
Hi Leila do you have any Oracle report in xml transformed in power Query ? I need to learn how can I cleanup it. Thank you in Advance. Bless you....
I needed this. Thank you!
Power query is a monster tool in excel. Thanks for this vid
It really is!
THIS is just an amazing presentation clear, precise and so useful.
Thank you very much Leila.
It´s wonderful and very useful information. Thank you very much !
Hi Leila, I love all of your videos! I have a question, when I use PQ to get data from text file, PQ imports it as one column instead of multiple columns, not like in your example. How can I fix it? Thanks!
Great presentation on Power Query Leila. Saving hours of manual work.
Very realistic and relevant example.
Great Video Leila, appreciate all your great work!!
The old problem of getting data from a report.
Legacy reports need to be banished and replaced by data exports. I prefer Tab separated text files because they are easy to work with, though not as good as a direct connection.
This demonstration demonstrates the advantage of PowerQuery, which exist in Excel and PowerBI.
Parsing data, regardless of the tool, is knowledge that will advance any career.
Thanks for the great tutorial, Leila! But just in case others are trying to find another way to clean data, especially contact list, data appending will do the job instantly.
Wow completed thing with simple illustrations
Fantastic! Thank you for the lesson!
You make it look so easy. Absolutely wonderful 🥰
Great. Thanks for sharing your knowledge with us.
Dear Leila, Thanks a lot for sharing the amazing knowledge with us. I really enjoyed the video and learned a lot.
Once again Thank you so much for your need of the hour video.👍👌🙏
My pleasure!
Hi, Do you have any video on handling 2 million plus lines in excel to analyze?
informative information. Thank you so much Leila.
Thank you...It is indeed very informative
many thanks for this great video, is this file available
Super useful skills. Thanks Leila!