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...
Category - Uncategorized
I am spurred into this observation, triggered by a post of Christopher T. Fennell on LinkedIn. He questions whether GroupBy and PivotBy functions...
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...
Is Microsoft Repackaging What We Already Have? Exploring the ‘Focus Cell’ Feature in Excel
A new Excel feature called ‘Focus Cell’ is making waves across the internet, and it’s set to become the next “spectacular” addition to...
In a world where spreadsheets dominate corporate landscapes, there’s a strange phenomenon lurking beneath the surface of digital collaboration. Brace...
Understanding the Role of Power Query: Differentiating Between Data Analysis and Operational Processes
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...
In today’s fast-paced world of technology and business solutions, snake oil salesmen are still alive and well–they’ve just swapped their...
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...
Excel has been around for decades, quietly woven into the fabric of business operations worldwide. Over a billion people use it daily. Billions...
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...