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

Cobweb launches their Microsoft 365 Managed Service

Enabling our customers to benefit to maximum advantage from the features and functionality of Microsoft 365, supported by the expert...

Read More

Are you a modern or legacy workplace?

Discover whether your business is a modern or legacy workplace. The future is clear.

Read More

Breaking down what end of support means for Windows 7 or Office 2010 users

Struggling to know what the next steps are for Windows 7 or Office 2010 upcoming end of support? This infographic will help.

Read More

Microsoft 365 | September 2019 updates

Discover the latest update to hit Microsoft 365 this September...

Read More