Видео

Thank you! Btw, I've learned this technique from Roberto Mensa. He has his own website with lots of awesome free advanced chart templates. sites.google.com/site/e90e50charts/excel-charts-gallery

Thanks! Btw, if you'll deal with a large data set, there is another approach you may like too: ruclips.net/video/iMeuit1IiE4/видео.html It'll work a bit faster because it avoids the double transposition.

Sorry, here it is: docs.google.com/spreadsheets/d/11WpVGlYJLuJAgreN16MvwCoTTGPeKZp-/edit?usp=drivesdk&ouid=108776671615330203341&rtpof=true&sd=true

I'm glad you liked it. Thank you for watching. To be continued ;)

Thank you for watching!

Thanks for watching! If you also need a month name, it's better to use table functions instead of list ones. They can handle multiple columns. The first thing that comes to my mind is this: = Table.Group(Source, {"Product"}, {{"Last Month", each Table.Last(Table.SelectRows(Table.Transpose(Table.DemoteHeaders(_)), each _[Column2]<>null))[Column1]}, {"Last Inventory", each Table.Last(Table.SelectRows(Table.Transpose(Table.DemoteHeaders(_)), each _[Column2]<>null))[Column2]}}) Perhaps there are a lot of other ways to achive this goal.

Thank you! It is really helpful in many scenarios to make queries more efficient.

Thank you for the support! More PQ stuff is coming soon too!

Thank you!

Ehhh... I've tested the "En">>>"Ua" scenario with some managerial reports and it worked fine. Like 97% correct. I hope they'll gradually improve this feature in future releases.

Thank you for the feedback. I see that Power Query videos resonate well, so I'll try my best. After the next PQ Challenge video I plan to make a bit more in depth tutorial on merging and appending queries. Hope you'll enjoy it.

Thank for for watching. I'll try to improve the quality.

Definitely! Thanks for addressing that. I hope this was an issue in the older videos. Now I try to use only subtle background music, but I'm still working on balancing it.

I'm glad yu liked it. More episodes are coming next week.

Glad to hear! Thank you for the feedback!

I'm planning to create a regular series on the channel. There's plenty of material to work with, but I want to avoid it becoming repetitive.

Sure. Here it is: docs.google.com/spreadsheets/d/1-TtRADRNc9i21OSTe9lQP0ipbHN4LlCa/edit?usp=sharing&ouid=108776671615330203341&rtpof=true&sd=true

@@howtolearnexcel thank you

​@@3170ccp You are welcome 🤗

Thank you so much. This is very encouraging. I'll try my best!

Absolutely! I'm glad you enjoyed the challenge. I'll definitely keep finding more interesting and varied challenges for us to tackle together. Exploring new topics and keeping things fresh is the plan!

Trying to do my best

Thank you! Glad, you liked it. By the way, Microsoft is going to release some new REGEX functions soon. A lot of tedious work won't be needed after it becomes available.

@@howtolearnexcel cool, thank you for informing 👌 appreciate it 🤘👍❤

Thank you for the feedback. I've added the link to the description. You can download it from here: docs.google.com/spreadsheets/d/1-nXhm_T1JcvsQC-eh1vQz5i1PjOnjPfb/edit?usp=sharing&ouid=108776671615330203341&rtpof=true&sd=true

Hi, Mateusz! Thank you so much for your kind words and for reaching out! I really appreciate your offer to collaborate on designing RUclips thumbnails. I’m very interested. Can you please contact me via email (in the channel description)?

Hello, of course. The practice file is here: docs.google.com/spreadsheets/d/1-aKm9Nd3QKoh8Avs46Lc_e6_fIABzJwF?rtpof=true&usp=drive_fs

You are welcome! The next one of this series will be about pivot tables.

Thank you! I'll try my best!

Yeah! Always!

Thanks!

4.3 - I'm a big fan of boxing movies. Real Steel is alright, but I believe Megalobox surpasses it. While the setting is similar, Megalobox elevates the genre to new heights.

I hope it was helpful!

Thanks. Of course, you can. The download link is here: docs.google.com/spreadsheets/d/15ZvnmEmyV8MBL960z5I3piXnXbe_YCn7/edit?usp=sharing&ouid=106607263585989911445&rtpof=true&sd=true

Thank you!

Thank you! The example file is here: docs.google.com/spreadsheets/d/1-9FJGP_ELvwHl3pNll5jmyke6G-Wt62u/edit?usp=sharing&ouid=108776671615330203341&rtpof=true&sd=true

Hello, it's here: docs.google.com/spreadsheets/d/1-5vVSFQdr00Gjww7t4_U5LTy_9Fn9y0y/edit?usp=sharing&ouid=108776671615330203341&rtpof=true&sd=true

Thank you!