by Matt Allington
I am well under way in my career as a Power Pivot Consultant and Trainer. And I have to say (now that I have delivered a number of Rob’s “PowerPivot for Excel” training classes) that I am finding delivering training to be one of the most rewarding things I do.
It occurred to me recently that people like me (and also Rob, Avi, Scott), that train users in PowerPivot are able to glean useful insights into the way people learn (and incorrectly learn) PowerPivot. Today I am going to share with you 5 common mistakes that I have personally observed – maybe you will identify yourself in some of these things, or maybe you will confirm that you are doing just great. Either way, it is worth a read to either discover a gap or confirm your skill.
But first: I have trained 2 general types of students
I have found there are 2 groups of students that sign up for my PowerPivot for Excel classes. There are students that are very new, very green (see what I did there – green, get it?) and are using the class to get started. They come in with very little knowledge about PowerPivot, but enough to know that this could be something awesome. In the second group are students who have a reasonable amount of PowerPivot experience under their belt but realise there is more to it. What is a “reasonable amount” of course can vary, but I would classify these people as “active” for 6-26 weeks with a total number of “invested hours” in the vicinity of 10 – 60 hours or so. Often they are struggling to move forward, and this post covers the main reasons why.
I always ask my students to rank their knowledge on a scale of 0 to 10, and they normally rank themselves 0 (newbies) or about 3 or 4.