I recently designed and delivered some Excel training for auditors. Specifically, it was Excel training for audit trainees who had just started at the firm.
I benefitted enormously at the start of my career when my employer arranged for all new audit trainees to have Excel training as part of our induction. Even though it was pretty basic, it established a good grounding in things like formula construction, absolute and relative cell references, and a few shortcuts.
Before I was an Excel trainer, even before I was an accountant, I taught English as a foreign language. Even though the subject matter is quite different, I learned some really useful techniques and principles which I apply to Excel training now.
What do you need to learn to be “good at Excel”? What Excel training should be mandatory for finance teams?
I really rate the ICAEW’s spreadsheet competency framework as a tool to use to diagnose where you and your team are at and where you should be. It breaks down users into four types – Basic, General, Creator and Developer – and allocates the skills that each level should have.
This is much more helpful to me than users saying that they are “intermediate” or “advanced” users. When I recruit for roles I often use the framework in the job description.