- Posted by BTB
- On July 21, 2020
- 0 Comments
Well, I have to admit, COVID-19 has provided some interesting opportunities. When the shut-down first occurred I think we were all in shock. We may have been thinking this would only last a few weeks. Little did we know how long our lives would be changed. This uncertainty and the fact that I couldn’t go to clients, allowed me to have some extra time on my hands.
So, I got creative on how to make the best use of my time:
- I started recording COVID-19 statistics into a detailed Excel sheet. I tracked the # of cases in my town, region, province, Canada, US and the world. I calculate % increase over the prior day, % active versus total cases and then there is my 7-day rolling average sheet. I guess I am a bit of an Excel geek. I continue to track the numbers.
- I updated and streamlined an Excel sheet I use for reconciling Inventory. I have queries that dig into the Visual database looking for those “needles in the haystack” that sometimes elude us when reconciling inventory. I created hyperlinks and conditional formatting. All kinds of fun Excel functionality.
- I also decided to get my professional development hours that are required for my CPA-CA designation. The perfect choice for me …… advanced Excel. There was so much to learn. But I not only learned a lot of cool functionality in Excel, but I really observed what makes a great training experience.
Each lesson was made up of 5 or 6 chapters. Lots of instructions to read up on. I must admit, I got a bit frustrated trying to follow the instructions. The lesson would say something like – “Go to the Data Tab – Consolidation”. I had trouble finding Consolidation. Did you know there are at least 15 icons or words to pick from on the various Excel ribbons? In many ribbons there are up to 25. That took a lot of hunting and pecking.