Microsoft Office 365 Updates | April 2018

Ross MacKenzie
Tags: Microsoft SharePoint

This April, Microsoft have announced their monthly updates with a focus on Excel and SharePoint. Adding and enhancing intelligence were at the forefront of these Microsoft Office 365 updates, with new data types being added to Excel plus the introduction of intelligent search within SharePoint.

New capabilities for Excel Online

Previous to this update, Excel Online had limited capabilities but, after numerous requests from users, Microsoft have given Excel Online a much needed update. This update means that creating and editing spreadsheets within your internet browser will become easier. Furthermore, Pivot Tables are now available as well as the removal of rows and columns, plus you can now insert images from your local storage as well as change the colour of tabs and duplicate existing sheets.

New data types for Excel

After becoming accustomed to using intelligent tools such as Insights, users will be happy to hear that the latest update will further increase Excel’s capabilities. Thanks to Microsoft Cloud, the new data types in Excel will be cloud-connected, with Microsoft announcing that the first two data types will be geography and stocks.


Added capabilities

Excel will be able to recognise data types, beyond traditional number and text strings, thanks to new added AI capabilities. The term ‘Belgium’, for example, would not only be recognisable as a text string but also as a country and, therefore, further data such as the country’s population and GDP will be attributed to it. These additional data insights can populate different cells automatically and will update in real time thanks to the cloud.

Richer content

With machine learning, these new data types will work alongside real-time data – making the process of ensure that data is rich and correct simpler. Looking forward, Microsoft will add organisational data types that are backed up by Microsoft Graph to Excel, meaning that your spreadsheets will be filled with even richer content. It seems that, when it comes to creating even richer data, this is only the beginning.

SharePoint Online search

After Microsoft’s announcement last year, they have now introduced new SharePoint Online search capabilities. Now, users will be able to search for information, advise and colleague’s details within SharePoint. This update is being rolled out to all Microsoft Office 365 subscribers and means that your search results will become more bespoke and personalised.


Redesigned results

The new search feature uses intelligent signals from Microsoft Graph to return more useful, more intelligence results. The look of the results page has been redesigned too, making them easier to explore and allowing users to preview files without losing their results. By bringing different tools together, you will be able to see cloud-powered results, regardless of whether your search began with SharePoint or

Related Articles

Supporting the IT industry with a mentoring programme

I’m excited to announce that I’ve become a mentor for The Channel Community.

Read More

Microsoft Teams now has 145 million users

With remote working responsible for much of the recent growth, Teams comes into its own, no matter where users are based.

Read More

Running workloads in the cloud, you’re protected. Are you sure?

Cloud won’t protect from a badly architected solution! In this article I'm focusing on Disaster Recovery.

Read More

Cobweb MD highlights the power of cloud in Cloud Industry Forum webinar

How can UK businesses benefit from a cloud-first approach? Discover what our MD, Michael, has to say...

Read More