There are a lot of new tools with the lastest versions of Excel that will help you import and manipulate data and to create web based dashboards.

This free course from Microsoft runs over 4 weeks and will take you through tools such as PowerPivot, PowerQuery, DAX functions, CUBE functions and creating dashboards using PowerBI.

Its a really good course and I highly recommend it.

Here is another 4 week course from Microsoft.  This course goes into more detail on using the PowerBI system.

Please note that PowerBI is an external system outside of our IT framework.  I would not recomend that you put any sensitive data on this system unless IT or Accounts approves it.