This week the Office 365 cutover migration I mentioned in an earlier blog post was taking place so that’s what most of my work was oriented around. So, for the first part of this week I was using a lot of Excel.
It quickly became clear to me, even though I had respect for Excel, that there is so much more to it. David taught me how to use PivotTables and lookups so that the data our client received could be interpreted within minutes rather than hours. We also wrote some Visual Basic code that scanned down a spreadsheet filled with Names, Usernames and passwords and sent an email to them. I had always considered Excel a pretty boring piece of software used for finances and graphs but sending almost 100 emails in a matter of seconds? That’s actually pretty cool.