Advanced Excel Power Query | How to Clean Financial Data? | Tutorialspoint

Very nice video but please provide practice excel sheet also so that we can practice.

needed the sample file

attached sample file would have been awesome.

Hello Dear Teacher how are you are you fine ?

Thank you sir, just learnt something new today.🥰🤪

I want to reconcile BRS

Great video!

Simply Fabulous.

Excellent tutorial. But this is not cleaning data; it is rearranging data.

How to show decelmal like 0.780 kilometre in power query because power query show 1 km

your legend brother

How can I download the practice data?

Classic , Cool

Very Good video - exact what i was looking for !! Keep it up !!

Sir , how to trim all data at a time

Sir, need practice sheet

Mashallah sir way of explanation is too good.

Tremendous work

I do not get name of applied steps..pls guide

Good info! Thank you.

Thanks a lot . May I have the exercise file ?

Really good video sir

Superb

Plz give me your number I need that

Hi i can only 11 videos in this course. Case study1, 2 and 4 are missing can someone give the that link

Thank you so much. Can you explain in detail about group by option

Sir this series is complete?

Great lecture. Thanks

Excellent sir

Very good video. It would be better though to transform the "actual / budget" column into two columns, one for actual and one for budget and then get rid of the one combination column. This would improve the usefulness of the report. If you agree, then would you add two conditional if columns, or how else would you approach that "improvement".

Superb one 👍

Amazing sir thanks a lot for this video's
I had completed your all excel course including micro tutorial and word tutorial too ..
Sir I want to know that , could you provide a certificate after learning this all things ...I need it would you make me avail of certificate

Hi....can you please explain how to do aging bucket like 30 to days based on the aging using powerquery

Thank You For sharing Knowledge. Its really Useful.

Thank you very much. A good concise presentation. As someone who is new to Power Query this has been a very helpful resource.

Thank you so much. Discovered a new topic cause of your video. Your explanation on the topic is very good.

Are you going to release further videos on power query like excel videos? I want to learn it

Sir I want to know how we can use Unpivot column
Suppose as you are showing company Financial data now at what condition we use Unpivot column to understand that we really need this option
Suppose we get another data from company which is different from other data so how can we use Unpivot column in that situation
Please kindly help me

Amazing,
Sir can you please upload video on same as you told us in the video to show later
For variance, Total income and net income loss ???

your lessons are very good and helped me a lot... thank you

Awesome video. Can you do the same thing in Excel or only Power BI can do it?

Fantaaaaaaaaaaaaastick.. Hats off to you my dear..!! God bless u

Nice explanation and please attach excel as well for practice purpose

When next video sir...

Thank you sir for the video👍
Your videos content are just awesome..
Sir please make a video on which type of shortcut one may avoid like deleting files from using shift delete button or ctrl f5 in excel..

Super
Nice explanations sir.
Your videos are very helpful for us
Please upload more videos on power query.
Waiting for next video☺️☺️☺️☺️

Anxiously waiting for the next vedioes plz update.

Sir can u pls make video on how to install free ms office in laptop ?