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).
You can do damn near anything in Excel. Calendar chart visualizations. Music videos. Beautiful art. More music videos. Respiration wavelengths. Chess games. Word clouds.
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)
Posted by powerpivotpro 




