Introduction: Moving Beyond Traditional Mindsets. When we think of data analysis, especially within the context of tools like Excel, it’s commonly perceived as exporting...
When it comes to introducing new technology features in Excel, particularly those designed to bring powerful analytics to the masses, there are two possible approaches...
This is a podcast by Hiran de Silva. Narrated by Bill. THIS IS A WORK IN PROGRESS! One of the most common pushbacks I encounter when demonstrating my monthly accounting...
The proof of the pudding is in the eating, they say. This is a podcast by Hiran de Silva. Narrated by Bill. In today’s landscape, we’re inundated with white papers...
This article reveals the most powerful capability of Excel today – a potential that many overlook. While most think of Excel as a tool for data analysis, typically...
Introduction to Data Visualization. In today’s digital landscape, data visualization has become a buzzword, often synonymous with software charting capabilities...
Unlocking the Power of Client-Server Architecture in Excel: How Microsoft Changed the Game
A sample module in the section ‘How We Got Here’ in the work-in-progress ‘The Story of Excel’. By Hiran de Silva. Narrated by Paul in the video...
Why Excel Tables Are Not Enough in Collaborative Environments: Rethinking Data Management for the Enterprise.
The question often arises: *Why not use Excel as a database?* It’s a simple, accessible tool, so why introduce the added complexity of a separate database? Excel expert...
Breaking Down the Complexity Myth: How Excel’s Data Access Capabilities Are Surprisingly Simple and Powerful.
In this article, I’m addressing a critical misconception about a common yet powerful Excel solution: the client-server, hub-and-spoke model, specifically for the reg...
The REG Call Handler Challenge has sparked responses that diverge from my intent. While feedback from Tony Wong and others has been invaluable, it highlights a...