Hello all,
I have been approached by my office to teach some of my colleagues some Excel tips/tricks, best practices etc!!! Apparently I am seen as hardcore power user with wizard/guru-like abilities... if only they knew the truth! Haha, but I suppose all is relative. I guess I am a bit of a power user and I am a big fan of Excel's capabilities - but really I have learned it all through continual use and experimentation over the past decade!
Our office is not huge and we have a large range in proficiency of Excel ability and heavy to light users.
So probably the best approach is to offer a two different workshops, 'novice/beginner' and 'intermediate/frequent' use.
My question is... what topics would you cover in each of those levels? And how would you approach and deliver the workshops?
The purpose of these workshops is to:
- aid internal skills learning and professional development;
- leverage internal knowledge;
- reduce the number of times people come up to me directly to say: "I have a problem with Excel... can you have a look at a formula for me?"
Not that I mind helping them! In fact I always like an excel challenge, but it's not really my day job...
I imagine the workshop will probably be for an hour or so, and it's stuff like teaching people vlookup - but that's so common and well-known, I'd probably teach them index-match as the upgrade to that...
I'd really appreciate any thoughts and suggestions!
Thanks!
Ian
Bookmarks