skip to Main Content

Share your story or technique here on PowerPivotPro!

Talk About Your Personal Journey OR Share a Technique – Either Way, it’s Time YOUR Voice is Heard Are you ready to see your name in lights? Hi folks!  I know, I know…  long time, no write.  I’ve been busy,…

Read the Rest

Compulsive Data Crunching Disease Pt1 (Relevant Even if You Don’t Like Football, I Promise!)


This spreadsheet-wielding Scrooge was the logo of my fantasy football team (“Mighty Ebenezer”) circa 2001.  Yes, I had this art custom commissioned for that purpose.
Yes, that is really, REALLY sick.  And simultaneously PURE FREAKING AWESOME.

Let’s start here:  Football Season is Spreadsheet Season.  Yes, even more spreadsheets than usual, even for me.   And football season starts tonight here in the US.  So it’s high time I tell you this story.

Even if you don’t care about American Football, or sports in general, I suspect you may still find the story itself to be interesting.

Deep down, this story is actually about a trait shared by probably everyone reading this.  And there is a TWIST in this story, a BIG one.  So go get another cup of coffee.  I will wait.

Scene:  Rob Collie, 1996-1997.  And Lots of Losing.

My Microsoft Badge Photo – Taken at New Employee Orientation, July 22, 1996My Microsoft Badge Photo – Taken at New Employee Orientation, July 22, 1996

I started at Microsoft in July 1996, fresh out of college.  I was raw, lazy, and unskilled.  I had never really applied myself to anything.  I had a computer science degree but had scrupulously avoided learning how to program.  I got the job largely because I was decent at logic puzzles, which were the MS interview du jour.

Read the Rest

Open Letter to My Friends at Microsoft: The Power of Excel’s Internal Network Effect

image  image

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 videosBeautiful artMore music videosRespiration wavelengthsChess gamesWord 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)

Read the Rest

Rob Collie’s Real Microsoft Stories: Paper or Plastic?

A “Chuckler” of an Interview Story

My use of “paper or plastic” in today’s post reminded me of a funny story from Microsoft.  There was a manager in Office who used to sit across the hall from me in the late 90’s – let’s call him DH.  He was famous for being a tough interviewer.  And I don’t just mean tough in the “only good candidates got by him” sort of way.  He was tough in ways that went above and beyond the call of duty.  In fact, on at least one occasion he made a candidate cry.  (Not a good thing).

But this isn’t about one of those times.  This particular story is about what happened when a particularly eccentric candidate crossed paths with that draconian interviewer.

Read the Rest