Excel on the Left. Other Data Tools on the Right.
Today I’m going to “get my nerd on” in a big way. Buckle up.
The genesis of this post is an email I’ve been meaning to send to my contacts at Microsoft – one I’ve been thinking about writing for at least a year. But I also figure it’s the sort of thing you folks might find interesting, and I really don’t have time these days to write the same “opus” twice, so here goes – two birds with one stone. And it’s a friendly stone.
Has there ever been a tool as flexible as Excel?
Let’s take a moment and just marvel at Excel’s “range.” (VBA macro programmers – yes the joke is intentional).
But those are just the outliers really – the novelties. The truly valuable examples are much less dramatic and happen hundreds of thousands of times every day. I’ll give some examples in the next section.
Feature A Was NEVER “Intended” to Be Used With Feature B!
“Hey You Got Your Slicer in My Conditional Formatting!”
(And then the whole jar fell into a bucket of DAX)