In this post I’ll review my solution to Ken Puls’ Power Query challenge #2. Online challenges are fun and it’s a great way to learn from others. Continue reading
Ken Puls Power Query Challenge #2
Posts Tagged → Oz du Soleil
Video 00165 Show Column Header for Matrix Value
Last week I saw an interesting Excel puzzle from Leila Gharani on YouTube. Leila solved it using a sumproduct function. I made a video showing different solutions. Wasif Mustafa sent me his 3 helper column solution. Then Oz du Soleil created a video showing two solutions. So many ways to solve it! Continue reading
Why I Enjoy Watching excel.tv
My Initial Reaction
I can’t remember how I discovered Excel.TV but I watched the episode 1 trailer and my initial reaction was something like this: “WHAT???” followed by “Who are these guys?” and “I’ve got to check this out!“. Continue reading