Power Query is undeniably a powerful tool, embraced by many in the industry to handle data transformation tasks. Over the years, a wealth of books, webinars, and courses...

In today’s fast-paced world of technology and business solutions, snake oil salesmen are still alive and well–they’ve just swapped their jungle carts for...

How many times have you come across this scenario? Someone is hired for a short-term assignment, maybe four to six weeks, requiring some accounting background and basic...

Excel has been around for decades, quietly woven into the fabric of business operations worldwide. Over a billion people use it daily. Billions, maybe even trillions of...

I recently had a look at the answers to Excel BI Challenge #2. The challenge itself, at first glance, seems fairly straightforward. It’s not asking for much...

Imagine paying just £12 a month for a tool that can surpass a $100 billion industry. Now, what if I told you that you already have access to this tool? Yes, you do...

When it comes to training, many people think of learning a tool or skill: how to use Excel, how to write code, how to do specific tasks. But there’s another kind...

A podcast by Hiran de Silva. Read by Bill. Imagine walking into a cinema 20 minutes before the movie ends. You grab your popcorn, settle into your seat, and enjoy...

Summary: This lecture addresses an important, yet largely unrecognized, event in Excel’s history that many respected and informed publications overlook. It...

Good afternoon, everyone. This is Hiran de Silva. I’ve got Bill reading this for me. Welcome to today’s lecture on a rather intriguing and essential...