Hi Gasper. Thanks for the quick demo of the new Excel Array Functions. They are truly awesome and make things that once required complicated function combinations and array formulas now easier than ever. After all the years of CTRL+SHIFT+ENTER, it almost feels like cheating.. haha!! Looking forward to your future videos on this topic :)) Thumbs up!!
Oh man... That is only wishful thinking. I wish I would have been to Barbados. I have heard a lot of it's beauty (and the rum 😀). I also love the fact how small it is. It's one of a few countries in the world that has less population than Slovenia 🇸🇮 where I'm from, but sadly I have have never been to Barbados 🇧🇧.
Well... There is an idea, I'm just not sure if you are going to like it. You see, I decided that during the second half of July and all of August, I would only publish "light-weight" videos. For instance, tomorrow, the "GoTo special" command video is coming out, followed by the "Remove Blank Rows in Excel" video the week after. And the rest of the summer will be all about the Calendar Table, with the first three parts of the series about defining and creating the calendar table and then a three-part series on extending the calendar table. And after that, I will release a "Converting a Description of a product to a list of properties" using Power Query, and after that... Two videos about DAs :)
Your lucid explanations bring such a revelation and clarity to the various topics. Keep doing what you are doing. The fruits of your labour is sure.
May your words come true some day 👍
Hi Gasper. Thanks for the quick demo of the new Excel Array Functions. They are truly awesome and make things that once required complicated function combinations and array formulas now easier than ever. After all the years of CTRL+SHIFT+ENTER, it almost feels like cheating.. haha!! Looking forward to your future videos on this topic :)) Thumbs up!!
Thanks Wayne. And you are right. It does almost feel like cheating 😀
Nice, thanks Gašper, I am using dynamic arrays from first day, they are amazing. Greetings from Maribor
I love to hear that Davor. I wonder, how much time do you think you saved using Dynamic Arrays?
@@ExcelOlympics I can't even imagine, a looooot of time :)
Dynamic Arrays are like rubber bands, and you can control it´s elasticity 😎👌
Nice analogy. They do seem like magic in so many ways.
Looking forward to using FILTER today in place of a pivot table. I expect a much smaller file size.
10:34 Row 19, you've been to my home country Barbados.. awsome dude. Come again for some cou cou and flying fish 😉 Maybe you'll get to meet Rihanna
Oh man... That is only wishful thinking. I wish I would have been to Barbados. I have heard a lot of it's beauty (and the rum 😀). I also love the fact how small it is. It's one of a few countries in the world that has less population than Slovenia 🇸🇮 where I'm from, but sadly I have have never been to Barbados 🇧🇧.
Any idea as to when we can expect more DA videos?
Well... There is an idea, I'm just not sure if you are going to like it. You see, I decided that during the second half of July and all of August, I would only publish "light-weight" videos. For instance, tomorrow, the "GoTo special" command video is coming out, followed by the "Remove Blank Rows in Excel" video the week after. And the rest of the summer will be all about the Calendar Table, with the first three parts of the series about defining and creating the calendar table and then a three-part series on extending the calendar table. And after that, I will release a "Converting a Description of a product to a list of properties" using Power Query, and after that... Two videos about DAs :)
@@ExcelOlympics I will keep enjoying the other videos until then. Thanks for the heads-up
Please share link to download file for practice.....
Sadly that video was before I started saving those practice files and sharing them, so the file is unavailable. I'm sorry Usman.
@@ExcelOlympics No need to sorry..👍