This blog is inspired by Omid’s Excel Challenge No 116, and hundreds of others. In the world of Excel, there is a growing tension between simple problems and the...

I’ve had this conversation far too many times—it’s a pattern I’ve seen over the years, each time taking on a new variation but always orbiting the same absurd core...

I am spurred into this observation, triggered by a post of Christopher T. Fennell on LinkedIn. He questions whether GroupBy and PivotBy functions make Pivot Tables...

With Microsoft rolling out new features like the ‘Focus Cell,’ it’s hard not to experience a sense of déjà vu. The reality is, this feature already...

A new Excel feature called ‘Focus Cell’ is making waves across the internet, and it’s set to become the next “spectacular” addition to the suite of tools...

In a world where spreadsheets dominate corporate landscapes, there’s a strange phenomenon lurking beneath the surface of digital collaboration. Brace yourself, dear...

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...