Відео

Superb! Thank you!

its shows #NAME? error

Thanks! I really appreciate the effort you put into creating this video. It's well-formulated and nicely done!

❔What other macros are you using to be more productive? 📂By the way, you can download the workbook with the reminder macro from this link: www.dropbox.com/scl/fo/rv7pdfiugvki3nsprsyh3/AIlSwLTMk8SB7C6DhzxheGQ?rlkey=nph6j7f5ch1gqrxf88q6oqjhy&st=gtlfwalb&dl=0

Hey guys, you can download the print-out version of the 2024 calendar from here: www.dropbox.com/scl/fo/vvfpxm0xilpbva9arjozb/AHoZiEqe3GmhfvVzzsk9Tqg?rlkey=n0hcik3wm3i5etow8rnn1n7yy&st=cz3lgqh7&dl=0 Enjoy!

Select Data list by press Ctrl+*.

excellent❤，thanks for sharing. You can use coalesce operator ?? to fetch the first non null value from the columns to make the code shorter

A VERY USEFUL VIDEO SIR, MANY MANY THANKS FOR THIS TUTORIAL VIDEO FOR BIGNERS IN EXCEL, THANK YOU....🌹👍

Hi, Thanks for this. I have been trying to follow this exact steps and also checked Mr. Excel videos. I continue to face the error [Expression.Error] The import Folder.files matches no exports. Did you miss a module reference? Any suggestions, on how to change this?

Hack 5: Use ChatGPT to rename and comment on each step in Power Query.

Super useful! Thanks 🙏

Thank you. I'm again reminded that I have been under-utilizing power query. I tend to do some of these via regular formula directly in Excel which is inefficient and can be hard to repeat. I should take another look at my current process and see what I can improve

The problem with this is that it doesn't categorize income and expenses. Once you have the data you need IF statements to categorize expenses and income into columns by month so you can do a bank reconciliation, this is completely useless actually. Contact me if you want to see a complete system, Nice try but no cigar.

Just found your channel and subscribed. Terrific content. Keep them coming. Thanks.👍👍

Thanks for posting this very informative video. I noticed that when I put in AVGO-Broadcom, it returns $0.53 quarterly dividend. It should be $5.25 quarterly dividend. Is there any way to correct this?

Thanks for posting this very informative video. I noticed that when I put in AVGO-Broadcom, it returns $5.255 quarterly dividend. That is because the code is dividing $21.02 by 4. It should be $5.25 quarterly dividend. Is there any way to correct this?

Great simply clear explanation of how to fix the problem, Thanks

I am interested in learning the steps you did to clean up the data

Smart and useful tricks

AWESOME AND A VERY HELPFUL TUTORIAL VIDEO, BUT ALSO HIGHLIGHTS CELL WITH ROW & COLUMN BY CONDITIONAL FORMATING IS MIND BLOWING, THANK YOU SIR. PLEASE CONTINUE TO LIKE THIS....🌹👍

I've used Conditional Formatting before but I found this video to be easier to implement the conditional formatting. Lotsa good info delivered in an entertaining manner in a short time. Thank you for the excellent video.

Wow, everything was easy to understand, thanks!

Very well explained!

what a guy kudos!

Very good. Very useful. Thank you.

Thank you ❤

Can you also provide the data in which your are practicing.

would like to see more how to clean those data in report type layout eg...one column with layer qty, price and total amt🤣🤣

Great work

Good

this was great thank you! the steps weren't too fast for a beginner

Apologize to say but this video is more for appreciating the wizardry of one person and less about the actual use cases. 1) you don't get data so perfectly aligned like never, 2) when making such videos we should encourage creative thinking. 99% of Power Query is all about spotting patterns and creative thinking and 1% is about setting it up

Great stuff!🎉

I have follows all of your video regarding PQ, thank you for your incredible knowledge sharing! Just wonder where can we learn more about PQ nd M Language specifically? Thanks!

I really enjoyed and find your videos very helpful in my data work. If I have dataset with different variations of gender pronouns like below: he,him,his He / Him / His HE, HIM, HIS he him his he/ him/his he/him/his he, him, his HE/HIMHIS How can I go about standardizing the above to "He/him/his" using Power Query? Thank you.

Tq for sharing ur knowledge ❤ do more formula videos 😊 conditions formatting

Hi, whenever I try to connect the website to the Excel file by putting its url,it shows "we couldn't authenticate with the credentials provided.Please try again" .How to fix it ?

Using your shared workbook and making no other changes, when I use Data-->Refresh All, I get an error. [Expression Error]: The import Html.Table matches no exports. Did you miss a module reference?

great video

Good content, well presented. Big Like.

It's good technic and very useful ...thank you..

It is very, very helpful and helped me a lot. I give it a thumbs up and subscribe to the channel. Have a nice day, greetings from Bremen, Germany

Really helpful thank you so much

Very useful 👌

Thank you for a fantastic tutorial 👌

mind-blowing techniques, thank you for sharing

Need personalised training on power bi please can you help

This is really helpful, thank you very much

Nice tutorial 👍

Excellent 👍and Thanks for sharing