You may have noticed that my blog has been a little quiet lately.Â I'm still here, it's just that I've been working on other projects since returning from the summit.
A week ago, I delivered three days of Excel classes.Â The first two days were for training the staff where I work, and were delivered as beginner and intermediate level training. The final day, however, was a course delivered to our local chapter of Certified Management Accountants, on how to create a re-usable spreadsheet.Â This is one of my favourite areas to talk about, as you don't need high level skill to do it, just a lot of thought into how your users will work with your project.Â A brief synopsis of what the course covered is below:
- Types of errors
- Using the auditor toolbar
- Laying out data
- Using styles
- Named ranges
- Looking up data in tables
- Proactive data validation
- Reactive data validation
- Spreadsheet protection (and it's limitations)
- Template creation
I'm happy to say that the course went off really well, and that the chapter may be interested in running some other Excel courses in the future.Â 🙂
In addition to that, I have also joined up with a couple of other MVP's and am working on a book about the Ribbon.Â I can't give any details on it at this point, but that is where I will be spending most of my free time for the next while.
I do plan to keep on posting, but if there is a long lag between posts, you know why.