Next Week’s Sold Out Class: One Spot Re-Opens

July 25, 2014

Hi folks.  Next week’s 2-day class (Wed-Thu, 7/30-7/31) taught by me (Rob) has been sold out for awhile now, but we had a last minute cancelation.

So if you live in the Cleveland area, or feel like some last-minute travel, drop us a note at

If you ARE considering the trip, you won’t be the only one traveling in, btw.  Of next week’s class, 16 of 17 students are coming from out of town.  Maybe you want to be lucky number 17 of 18.

We’re also doing a social outing/dinner for the class on Wednesday night.  The famous Matt Allington will be joining us from Down Under.

Note that we’re doing another class in August as well, so if you’re not inclined to join us on short notice, there’s another option as well.

Updates from July 4th / World Cup Week

July 2, 2014

A Summer State of Mind


Let’s Call This “Recharge Mode.”

After an INSANE couple of months, we’ve been taking it this week at PowerPivotPro HQ.  July Fourth holiday week, World Cup games on TV, a relatively quiet email inbox, lots of physical therapy for the still-ailing knee…  all adds up to “no new posts this week.”

But I do have a few quick updates:

August Power Pivot Class, Book Bundle, Spanish Book

Power Pivot Training Course   Power Pivot Training Course


Our July class here in Cleveland completely sold out – demand exceeded our supply of seats.  That’s a good sign for Power Pivot awareness and adoption, for sure, and

So we’re going to do another class in August.  Details here.

Power Pivot Book Bundle

Reader Jim Fleming wrote me and pointed out this bundle.  Get all three for $27 (eBook versions – web delivery) or $54.95 (print AND eBook versions combined – US shipments only)

Power Pivot Book en Espanol!

Last, but NOT Least – Miguel Escobar’s Translation of “DFPP,” Right Here in My Hand.
Ultimately, No Country or Language Should be “Safe” from the Benevolent Virus Called Power Pivot.

July 30-31 Cleveland Class: Now With Special Guest!

June 3, 2014


Yeah, the Crazy Aussie Himself Will Be Attending:
Former Coca-Cola BI Director, Matt Allington!

July 30-31 – Cleveland, Ohio. 

Conquer Data AND Meet Living Proof of Legitimacy.

Last time I taught one of these, I was flattered that half the class came in from out of state – Indiana and Pennsylvania, I believe.

Well, the famous Matt Allington, who left his BI Director Job at Coca-Cola to join the Power Pivot Revolution, is taking that to the next level, and flying in from Australia.

Class Info

Two full days, $1249 per student. 

  1. Download the PDF agenda HERE.
  2. Reserve your spot HERE.

Convince Your Boss?

We hear this a lot:  “I’d love to attend, just not sure how to sell it to the boss man/lady.”

You could always say, “well, a BI Director at Coke has bet his career on it, for $1249 we can have that power too.”

Failing that, drop us a note and we’ll help you with a tailored value proposition:

Mini-Post: 2-Day Class in Cleveland, July 30-31

May 1, 2014

teacher power pivot

Yes, I Look Precisely Like This in Person Smile with tongue out
(But No, I Don’t Have One of Those Little Teacher Batons)

The last time we did this was a blast.  So we thought we’d do it again, this time with more advanced notice.  I met some truly amazing people – even the lunch breaks were just a lot of fun.  And, as amazing people are inclined to do, they are now off doing amazing things with their data.

Half the class actually traveled in from out of town last time, which is an inversion of my normal dynamic of flying out to a client’s headquarters.  It’s a very cool feeling to wake up at my house, get in the car, and go teach Power Pivot all day.

It makes it all feel very mainstream, which is of course becoming more true every day.  The first time I taught Power Pivot professionally was 3.5 years ago out in California, and for what felt like a long time after that, ALL of my clients seemed to be “out West.”

That I can now teach classes without leaving town is, in itself, a sign of the times.  Just fantastic.  And I hope to see a few of you there.

This time I think we will also schedule a “social event” of sorts at the end of the first day.  Even if it’s just grabbing a beer or something similarly simple, it’s something I wish we’d done the first time, especially for the out of towners.  Purely optional and informal.  But fun.

Syllabus, pricing, and registration information here

Occupy BACON: Let’s Do This. (Sessions & Discount)

March 18, 2014


It’s Possible that Maybe I Added Something to Their Banner Image :)
(Click Image to Visit Site)

Year One Was Great, So I’m Speaking Again – San Jose CA, May 7-9

I really enjoyed the inaugural PASS Business Analytics Conference, aka PASS BACON, last year.  Before that, I’d never been to a conference that was even remotely aimed at “my kind of people.”  That all changed for me last year.  I think we have found our home.

THIS is the kind of conference we need – one that’s accessible without heavy technology expertise.  One where Business Impact take center stage, and the only pre-requisite is that you enjoy working with data.  (And it helps if you don’t flinch at the word “Microsoft.”)

Which suits us Excel folks to a tee, doesn’t it?  They might as well put us on the front page.  But an explicit mention of Excel would scare off those other people – the non-Excel people (that we outnumber 100 to 1).  Honestly I think we should just take this thing over.  You know, like…  Occupy BACON.  (Brief pause while I replace the previously-bland title of this post with precisely that).

Putting my time where my mouth is, this year I am “doubling down” and presenting two sessions – a full-day “pre-con” and a “regular” session – see below for details.  AND I’m in discussions about presenting a third session as well, stay tuned on that.

We like dominating the "BACON Challenge"Last Year’s Referral Champion Wants to Repeat!

A little bird told us that last year, more people signed up for PASS BACON using the PowerPivotPro discount code than any other discount code.

Pretty cool, eh?  Anyway, there’s a discount code again this year, but I’ve been slow to share it.  Let’s pretend we did that to give all those “non-Excel” websites a head start, given that whole “100 to 1 outnumber” thing (in reality I have just been swamped).

Read the rest of this entry »

2-Day Public Class in Cleveland April 9-10

March 6, 2014

If you’re in the Ohio/Midwest area, I would love to meet you in person and help you on your Journey Through the Land of Data.

Only 18 seats in the class, so it will be “intimate.”  Lots of interaction, fun, and obviously…  mind-blowingly powerful techniques.  You know the drill – act fast and reserve your seat today, etc etc. Smile

Syllabus, pricing, and registration information here

(Apologies, no “real” post today – but only because I am so “slammed” with real work.  There are guest posts in the pipeline where if I just could have gotten free for a few minutes…)

Closing Midnight Tonight (US Pacific Time): PowerPivotPro University / Chandoo Bundles

February 21, 2014

Final Reminder!

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.

Click Image to Register

And again, here’s the Q&A posted last week.  Happy learning!

“Level Up” Your Data Powers with PowerPivotPro University and Chandoo Course Bundles :)

February 17, 2014

Power Pivot Pokemon Last Week, Power Pivot Mario This Week

An Enthusiastic PowerPivotPro University Student Sent Me These Over the Weekend Smile

Signup Closes Friday:  Bundle PowerPivotPro Univ. w/ Chandoo Courses

Just a reminder that the joint discount/bundle offering with Chandoo closes this Friday:

Read the rest of this entry »

PowerPivotPro University Open on

February 10, 2014

Open for Signups, Start Immediately.

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.
Click to Enroll!

Questions & Answers

Q:  You Call it PowerPivotPro University, but Chandoo only offers “Power Pivot” and “Advanced Power Pivot.”  What’s going on?

A:  PowerPivotPro University is the same thing as Chandoo’s Advanced Power Pivot. It’s the exact same content, produced and taught by me, under two different names.  It’s just that Chandoo has his own Power Pivot course, and we needed to differentiate his from mine when offered on the same site.

PowerPivotPro University, aka Advanced Power Pivot on Chandoo's site.

When You Go to Chandoo’s Page, Scroll to the Bottom

Q:  So is your course really that advanced?  Should I be scared if I am new to Power Pivot?

A:  No.  I built my course to truly take you from “zero to sixty.”  It turns Beginners into Magicians.  So it’s basically Beginner AND Advanced combined – I may even split it into smaller courses in the future to reflect that.

Q:  What have the first few waves of students thought of PowerPivotPro University?

A:  Click here for some testimonials.

Q:  In the future, are you going to be offering PowerPivotPro University independently via this site, separate from Chandoo?

A:  Yes.  Even though there are many people already taking it through us directly, we are downplaying our independent delivery for now, and delivering it one more time through Chandoo in order to honor past commitments.  Then we’re “going solo” – but then may cooperate with Chandoo in other ways going forward.

Q:  Ah, that explains the confusing naming etc.  Seems like a tangled web.

A:  Bingo.  It’s just two entities doing right by each other.  Chandoo is awesome and a little confusion is nothing in the grand scheme.  It all clarifies in the near future.  Bear with us.

Q:  Are there any advantages to signing up now via Chandoo versus your solo offering in the near future?

A:  Yes, there are two benefits.  One is that you can start immediately, rather than waiting.  The second is that if you are interested in also taking some of Chandoo’s other courses, you can bundle them for a discount.

Seattle User Group Kickoff, Alchemy, and More

February 4, 2014

1) Seattle User Group Kickoff Meeting

Monday, February 10th, at Building 34 on Microsoft Main Campus

That’s right,  Seattle’s group is gonna meet at the Mothership itself – the building where I worked when I was working on Power Pivot, which also happens to be the building where Bill Gates used to work.

We already have 70 of the 125 seats filled, so act fast!



Exclusive 20-Minute Video Kickoff Presentation by Yours Truly – You Can Only See This at MEUG In-Person Events (Such as Seattle on Feb 10)

2) Alchemy Update – Power Writing Session at Undisclosed Location

Yes we’ve been a bit behind on the new book.  But last week I took an emergency plane trip to the MrExcel Secret Winter HQ so we could get this sucker done.


Time Lapse Photos of an Epic Writing Session:

7 am Breakfast:  Eggs / Sausage / Choco Chip Pancakes for Me, Mahi Sandwich for Bill (Fancy!)
4 pm Recharge:  Holy Cow, Dr. Pepper Slurpee???  YES.  And Diet Coke for Bill (Bah!)
3 am Still Going Strong:  Note Empty Coffee Mug and Slurpee cup.

Summary of Results:

  1. On Day 1 we sent 150+ pages sent to off for copy editing.  Several of those chapters are already back in Bill’s hands for the addition of his magic touch.
  2. On Day 2 we added Power View, Power Map, and Power Query to the book.  We wrote about 70 pages or so on the spot, fueled by the fine nutrition pictured above.
  3. “Early Bird” preview versions will be available THIS MONTH to students of PowerPivotPro University (which is known as “Advanced Power Pivot” over on

3) PowerPivotPro University – Sign Up to Be Notified for Feb 10 Launch

Just a follow up from last week:  we’re counting down to the 2014 re-launch:

Click here to be added to the notifications list

If you have questions or just can’t bear to wait til next week, drop us a note at Smile

PowerPivotPro University Re-Opens Feb 10

January 30, 2014

Power Pivot Pro Online University

“They’re calling me the ‘go-to guy’ here at work.  All the credit goes to you.”

-C. Gilbert

All Systems Go!

Apologies for the delay.  We’ve been holding off on a broad re-launch because we wanted/needed a few things done first:

  1. All of the content is complete.  The last official lesson, Using Macros with Power Pivot, was published this past weekend.
  2. The Alchemy book is on track.  Students of the class will receive an electronic copy of Power Pivot Alchemy before it even goes to the printer.  I just got back from Bill Jelen’s secret winter hideout, where we conducted a marathon writing session.  I am now confident we will be distributing the “early bird” e-version to students during the month of February.
  3. Chandoo and I have aligned our plans.  P3 University will be offered one more time (Feb 10) in partnership with, and subsequently will only be available through PowerPivotPro.

Sign up to be notified

Join the waiting list here, or use the form below to be notified when enrollments officially open:

PowerPivotPro University Open for Corp. Year End

December 2, 2013


As mentioned previously, PowerPivotPro University will be re-opening for general enrollments in January.  I’ve been thrilled by the feedback I’ve received from the hundreds of students in the first wave and hope to see many more of you in the class next year.

In the meantime though we have been receiving numerous inquiries about using 2014 year-end training budget to purchase enrollments in December.

If that is relevant to you, please contact us and we will happily get you started today:

+1 (440) 719-9000

The price per student is $349.  Access is good for one year after enrollment.

(Yes, your students can begin the course immediately and do NOT have to wait until January)