[Editor's Note: What immediately follows is a rundown of the latest developments and features Microsoft has added to Office 365 since this review was last updated.]
- Microsoft introduced new data types for Excel, allowing the spreadsheet program to recognize rich data types beyond numbers and text, starting with stocks and geography.
- The online version of Excel also got some neat features from the desktop software, including the ability to insert Pivot Tables and images from local storage.
- A new personalized search experience which provides tailored results based on your work patterns is now being rolled out to all Office 365 subscribers.
- Microsoft Teams celebrated the anniversary of its launch a year ago, and the software giant revealed that over 200,000 companies worldwide now use the Slack challenger.
- Microsoft also introduced enterprise-grade calling features in Teams (such as call delegation), and revealed that Cortana integration is planned for the future.
- In the face of GDPR, Microsoft 365 is gaining powers to help protect sensitive data, including a Compliance Manager for Office 365 Business and Enterprise users in public clouds.
- Resume Assistant arrived in Office 365, allowing Word users to leverage the power of LinkedIn in order to craft a better CV.
- Microsoft Planner gained some new features including a Schedule View which makes it easier to plan ahead, along with Group and Filter options to help with meeting deadlines.
- Not strictly Office 365 news, but it emerged that Microsoft is making Office 2019 a Windows 10-only affair – showing the firm is still pushing folks towards its subscription offering.
- Office 365 Education received a new learning tool, Dictation in Office, which allows students to write using their voice across Word, PowerPoint, Outlook Desktop, OneNote for Windows 10, and Word/OneNote Online.
- Microsoft Teams saw some extensive work, including the ability to use interactive cards pulled from third-party apps directly in conversations as easily as you might drop in a GIF.
- Microsoft made an important move for iOS and Mac users, with the introduction of seamless co-authoring across Word, PowerPoint, and Excel.
- Mac for Office 365 subscribers got another new feature: AutoSave in Word, Excel, and PowerPoint, facilitating automatic saving for files stored in the cloud (OneDrive and SharePoint).
- Yammer users benefited from improvements to the mobile app which allow them to post announcements to groups, as well as adding animated GIFs, and more besides.
- OneDrive for Business users received the ability to easily restore files to any point in the last 30 days, a feature which will hopefully be coming to consumer accounts soon.
- Outlook’s mobile app got smarter with the arrival of Cortana’s ‘time to leave’ feature which lets the user know when to depart for a meeting, taking into account things like traffic jams.
- Microsoft Word received a new feature which uses machine learning to identify commonly-used acronyms across an organization, and automatically surfaces definitions for them.
- Excel was bolstered with a preview of Insights in the spreadsheet app, which automatically highlights patterns and trends in data using AI (the firm is currently on a big drive with AI).
- OneDrive and SharePoint were graced with the ability to automatically pull out searchable text from images (like receipts) for Office 365 commercial subscribers.
- Microsoft rolled out its Whiteboard Preview app which the company describes as a ‘freeform digital canvas’ where people can collaborate creatively.
- It’s worth noting that Office Android apps have arrived for Chromebooks which are capable of running software from Google’s Play store.
- Resume Assistant was announced for Microsoft Word, a feature which helps Office 365 users put together a sparkling resume/CV with personalized insights drawn from LinkedIn.
- Three new apps arrived for Office 365 Business Premium, as well as Microsoft 365 Business, namely: Microsoft Connections, Microsoft Listings and Microsoft Invoicing.
- Microsoft 365 Business – which comprises of Office 365, Windows 10 plus various security and MDM features – moved out of testing this month, and into general availability,
- Microsoft powered up Word’s translation tools, allowing for the translation of entire documents across some 60 languages.
- Microsoft brought premium Outlook.com features to Office 365 Home and Personal subscribers, including an inbox storage capacity of 50GB, and no more adverts.
- Microsoft announced that Office 365 now has 28 million consumer subscribers (up from 24 million this time last year), and 120 million commercial users (up from 85 million).
- Microsoft To-Do, the company’s task management app, began rolling out across the Office 365 user base.
- Outlook for iOS and Android got some smart new features including the ability to sync shared calendars to your phone, and added capabilities for managing events.
- Microsoft ended support for Office 2007 and Outlook 2007, meaning no more security patches, with the company pushing for users to upgrade to either to Office 365 or 2016.
- Microsoft revealed that Office 2019 will be out next year, so the company will continue to cater for those who don’t want (or aren’t ready) to move to the cloud with Office 365.
- Skype for Business has reached the end of the road, with Microsoft set to roll the service into Microsoft Teams – with audio conferencing capabilities already in preview.
- The Office.com website has been redesigned, and Office 365 app launcher simplified to help users open the apps they need swiftly, and to easily switch between them.
- Microsoft kicked off a new program called ‘Windows Insider Lab for Enterprise’ which allows IT pros to try out Office 365 and other services for free, with a view to upgrading.
- Microsoft Teams was improved by the rollout of guest access for Office 365 commercial and education subscribers, allowing guests to join a team and subsequent meetings.
- Microsoft brought co-authoring to Excel, along with an auto-save function for Word, Excel or PowerPoint files being worked on in OneDrive or SharePoint Online.
- Security firm Barracuda has warned about an ongoing series of phishing attacks aiming to steal the login credentials of Office 365 users. As ever, be cautious about links in emails.
- Microsoft released a new preview of Office for Windows PCs introducing in-line chat functionality to Word, Excel and PowerPoint, along with new ink effects.
- A redesigned Outlook.com began rolling out in beta this month, with a number of touches to make your inbox smarter, and the webmail service more responsive in general.
- Microsoft added new features for Office 365 users to the OneDrive app for iOS, including the ability to take folders offline for access, and scan multiple pages into a single PDF.
- With its latest quarterly financial results, Microsoft announced that Office 365 revenue surpassed traditional Office licenses for the first time ever.
- The Outlook apps for iOS and Android have benefited from a redesigned navigation and conversation experience, and new intelligent search capabilities are promised soon.
- Three new apps are coming to Office 365 Business Premium: Microsoft Connections (email marketing), Microsoft Listings (managing online listings) and Microsoft Invoicing.
- Microsoft 365 was revealed, a new offering which combines Office 365 and Windows 10 in a single streamlined package, with additional security and management features.
- Microsoft launched Workplace Analytics as an add-on for Office 365 enterprise customers, a system which uses behavioural metrics in an attempt to boost employee productivity.
- Microsoft Teams got new classroom experiences, allowing Office 365 for Education customers to benefit from virtual classroom environments with rich chat capabilities.
- Office 365 Advanced Threat Protection received improved reporting on malicious emails which have been blocked, and a new Safe Links policy was introduced.
- Microsoft Forms, a web tool for creating surveys, is rolling out for commercial customers, entering public preview for these users (previously it was only available to education customers).
- Microsoft Stream was introduced for Office 365 commercial customers, an intelligent video service which allows users to share videos and benefit from speech-to-text transcription.
- Microsoft pushed out iOS and Android apps for Microsoft Planner, allowing Office 365 users to update their plans while they’re on the move.
- An annoying (but not critical) bug was found to be affecting Office users in May, involving a reappearing pop-up window – but Microsoft’s working on a fix that should be out soon.
- Office 365 is set to get improved inking features to benefit the new Surface Pen, including new pencil texture and ink effects, along with Microsoft’s collaborative whiteboard app.
- Microsoft Graph received considerable new capabilities, including fresh APIs which have become available to developers – namely SharePoint, OneNote, and Planner data APIs.
- Microsoft revealed that Office 365 is steaming ahead in terms of its subscription base, with the online productivity suite now boasting 100 million monthly active commercial users.
- It emerged that the full desktop version of Microsoft Office will be available in the Windows Store in June (as opposed to the touch-focused apps currently in the store).
- Microsoft used another tactic to push folks towards Office 365, announcing that those with a standalone version of Office will eventually lose access to OneDrive and Skype for Business.
- It was confirmed that Windows will have twice-yearly major updates to align with Office 365 ProPlus’ update schedule, with said upgrades coming in September and March.
- Outlook Customer Manager, which is designed to make it easy for SMBs to track and manage customer relationships, is now rolling out worldwide.
- The PowerPoint app for iPad was improved with the introduction of Designer, which gives you quick and easy ideas for designing and laying out slides.
- Microsoft revealed that Wunderlist – which is available as an add-on to Office 365 subscribers using Outlook 2013/2016, and on the web – will be replaced by To-Do.
- Microsoft enabled co-authoring in Excel for Windows desktops, extending Office 365’s collaborative chops, albeit for Office Insiders (testers) only at the moment.
- Microsoft Bookings, which allows SMBs to manage appointments with customers, is now being rolled out worldwide for Office 365 Business Premium subscribers.
- A huge addition arrived on Office 365 in the form of Microsoft Teams, a Slack-like messaging and collaboration app which is available to business subscribers.
- Office 365 calendars are now supported by Amazon’s Alexa-driven devices (such as the Echo) for commercial users who subscribe to Office 365 with Exchange Online.
- Microsoft announced that Visio Online, the firm’s veteran diagramming app, is now available to commercial customers running Office 365.
- Microsoft has updated Visio Pro for Office 365 with a database reverse engineering tool that allows you to easily create a visual representation directly from source data.
- Office 365 benefited from the introduction of a security analytics tool which rates your current security configuration, and makes suggestions on possible improvements.
- The Office team announced that the OneNote REST API now supports application-level permissions.
- Excel got new features based on Power Query technology, including support for the percentage data type, along with a new OLE DB connector.
- Microsoft released Office Training Roadmaps which help businesses keep track of training programmes for the various productivity apps.
- Office 365 Advanced Threat Protection got several new features for tighter email security, namely URL Detonation and Dynamic Delivery.
- Microsoft graced Office 365 with a new Setup section on the navigation menu, which provides convenient and easy access to all setup-related settings in one location.
- Office 365 was crowned king of all productivity apps by Okta, outdoing second-place Salesforce.com by a factor of 1.3 to 1 as 2016 came to a close.
- Microsoft brought in a raft of new courses from LinkedIn Learning to the Office Training Centre, with over 20 offerings on working with Word and PowerPoint.
- StaffHub, a nifty new app which allows for the management of shifts for deskless workers, became available for Office 365 users with a K1, E1, E3 or E5 plan.
- A new OneDrive for Business admin centre began rolling out to release customers, with general availability promised for early 2017.
- Microsoft laid out its grand vision of how the firm intends to integrate Teams (its Slack rival) with Microsoft Planner so working across the two is a seamless affair.
- Microsoft made the Accessibility Checker more easily found across all Office 365 apps, and introduced automated alternate text descriptions in Word and PowerPoint.
- An official guide on the ‘preferred deployment practices’ for Office 365 ProPlus was released, including advice on preparing the ground, and maintenance afterwards.
- New statistics emerged from data protection firm Bitglass showing that Office 365 is twice as popular as Google’s G Suite.
- Office 365 users got the benefit of real-time co-authoring in PowerPoint, as well as in the Word app.
- Office Lens received a couple of new features, including the full integration of Immersive Reader, and a new tool called Frame Guide to help the visually impaired.
- Outlook Customer Manager arrived in Office 365, enabling businesses to track and manage – and hopefully grow – their customer relationships.
- Microsoft reintroduced Access, its heavyweight database software, to Office 365 Business and Business Premium customers.
- Microsoft officially took the wraps off Teams, the firm’s Slack rival that leverages the whole gamut of Office 365’s apps and services.
- Excel 2016 got new features based on Power Query tech, including an improved web connector and enhanced Query Editor, as well as Query Parameters support.
- Microsoft introduced the ability to create (and collaborate on) Office documents from within a Yammer group.
- In an earnings report, Microsoft announced Office 365 user numbers: 85 million active commercial users, and 24 million consumers.
- A batch of new apps were revealed for Office, including an app for invoicing, and tracking expenses, along with one for keeping tabs on your business’ web presence.
- Microsoft announced several new intelligent features which are coming to Office 365, including Tap for Word and Outlook, and QuickStarter for PowerPoint and Sway.
- New usage reports arrived for SharePoint Online, Exchange Online, and OneDrive for Business, aiming to provide better insights into how staff are using Office 365.
- Office 365 Groups were changed so that you can invite guests from outside your organisation to join.
- Microsoft changed its system of Office preview builds on Windows (and Windows Mobile) to include a fast and slow ring, just as with Windows 10 testing.
- SharePoint Online got tighter integration with Office 365, so when you create a group in Office, you get a SharePoint Online team site into the bargain.
Otherwise, now move on to Page 2 for our full review and detailed look at what Office 365 offers, and how it can help you become more productive.
Darren Allan contributed to this article