Inverness Kart Raceway

Matthew’s Blog – The Week of our First Migration

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.

Microsoft Office 365

Matthew’s Blog – Office 365 Migration

This week we were focusing on data normalisation and preparing for an Office 365 migration, which is essentially taking their existing email system and putting it into the cloud. Oh yeah, Airan has got a PC to work on too however certain parts of the taskbar are frozen so we also had the task of troubleshooting this.

So, the data normalisation, we were working on the Apprentice Store database. I was still struggling with the whole concept of normalisation so a lot of time was spent simply just practising this. I did try to implement what I had learned into Access and I was semi-successful.