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.
On to the migration. We had a problem whereby users would need to sign in to the Outlook web mail before they could use the Desktop version. Which is fine, we can just sign in to all the accounts, launch the webmail and sign out but we made all the users change their password upon login, so we had to reset them all again. Apart from that, we created the DNS records, made a user guide on how to change their Office 365 password and used the Visual Basic code to notify the users of the migration. We were good to go.
The migration occurred the next day and the phones were strangely quiet. It seemed everything had gone to plan and, looking back, it had. Don’t get me wrong, there were a few small hiccups but they were solved quickly and our client was happy.
With The Apprentice Store’s first Office 365 migration completed and it being Airan’s birthday, it seemed like a good time to celebrate. And that’s exactly what we did, with Go Karting. David came first, Airan second and me last but I didn’t mind as I still had a lot of fun. It was a great way to end the weekend also a good way to end this blog post.