ATOI365D#Office365Challenge Of course working out averages across columns adds value – why export it to Excel to analyse data when you can do it in SharePoint?

Day: 280 of 365, 85 left
Tools: Office 365, SharePoint
Description: Calculate the Average of numbers SharePoint
Audience: All

In SharePoint I’ve added a calculated column which works out the average of two columns specified. You can do it for more than two columns. Remember to display the result as a number:


This is the end result:



Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.
Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.