Articles, Blog

Office 365 update for May 2018

November 7, 2019

Welcome to the Office 365 update for May of 2018. In the next few minutes I’ll be giving you a quick rundown of the latest Office 365 updates, with the goal of helping you get the most out of the service. Every day, millions of Office 365 subscribers rely on Excel to perform complex analysis for their organizations’ data. For many, however, extracting key insights from a new data set can be time consuming and even a little intimidating. Microsoft recently announced the preview of Insights in Excel, a new service that automatically highlights patterns in your data. When you have any cell highlighted in an Excel data table, simply click the Insights button from the Insert ribbon. Powered by machine learning, Insights quickly identify trends, outliers, and other useful visualizations, providing new perspectives on data. In this example, insights delivered over 30 suggested results that you can quickly scroll through. When you find insights you like, just drop them into your workbook with one click. A new tab is created with PivotChart controls that enable you to further modify the chart if you need to. Another new Excel feature, currently available only to Office Insiders, is support for new data types. These new data types are fundamentally different than the traditional cell contents which hold values, formulas, and text labels. The first two, new data types in preview are Stocks and Geography. Say you have a list of countries, you can convert it to the new Geography data type by clicking on the command in the Data ribbon. Now the cell isn’t holding just the name of each country. It now contains a rich set of additional information behind the scenes. Clicking on the icon next to each item shows a data card displaying all the extra information in that cell. Better yet, if you have the data in an Excel table, you can see a widget that lets you pull the additional data into a column of its own. In this case, I’ll add the population for each country. Note that Excel didn’t just copy that data out of the cell. It actually created a formula for you. All the data available in this new data type is calculation enabled. This means that you can write your own formulas referencing any of the fields available in the new data type’s cell. It’s not just States or Countries either. The new data types support things like postal codes, cities, as well as stocks, index funds, and other financial data. The Excel team plans to add more data types over time, including the ability to extend this capability to data unique to your organization. I’ll keep you posted in future updates. For now, I encourage you to read the March 29th Excel blog post I link to in the transcript and resources document available in the Office 365 Guy Blog. And remember, it’s only available to Office Insiders right now. I know we have some passionate, and vocal, Excel for Mac enthusiasts in the audience. While Excel for Mac 2016 version 16.9.0 has been live since January, there have been several feature updates since then. An April 10th Excel Blog post covers eight Excel for Mac feature improvements, including the addition of more functions and charts; collaborative editing, more robust support for PivotTable Charts, and more. Be sure to check the blog post and continue to make your voice heard via the Excel virtual suggestion box at Say you need to send an important or sensitive email to a colleague and you want to keep your manager informed. But for whatever reason, you don’t want the mail recipient to know you’re also sending it to your manager. Enter the email bcc feature, which stands for blind carbon copy, a term actually borrowed from when we wrote business correspondence on typewriters, or heaven-forbid, by hand, using a copy medium called carbon paper. Only the person that was “blind carbon copied” on the memo then, and the email now would know they received it. “Replying All” to an email you are bcc’d on it usually defeats the purpose of the reason for the bcc in the first place. Outlook’s new “Prompt before replying all” feature was designed to help ensure discretion when replying to emails when you’re a bcc recipient. If you’re on the bcc line and you click Reply All, Outlook will alert you with the message, “Your address was hidden when this message was sent. If you Reply All, everyone will know you received it.” This helps ensure you don’t accidentally reveal that you received the original message unbeknownst to the other recipients, and perhaps more importantly, saves the sender from a potentially awkward conversation with the other recipients. I’ve added a link to learn more about this new feature in the resource guide. And for the more inquisitive millennials in the audience who want to learn a little bit more about the fascinating history of carbon paper and all its uses, consider doing a search using your preferred web browser. Aloud As voice-enabled virtual assistants like Cortana take on more-and-more tasks, the ability listen to my emails rather than read them is a natural progression. Another new Outlook feature being rolling out to Office Insiders enables you to listen to your emails. If you’re an Office Insider, you can enable this feature by clicking on File, then Options, then click on the Ease of Access section. Add a check to Show Read Aloud, and the option will appear on the Home ribbon. In the March update, I covered several Planner enhancements, including new Group and Filter options. I also mentioned that, coming soon, a new iCalendar format feed would enable you to quickly publish Planner tasks to your Outlook calendar. I’m happy to announce that on April 11th, the Planner team released that feature and it couldn’t be simpler to set up. In Planner, go to My Tasks, click on the ellipses and then on “Add ‘My Tasks’ to Outlook calendar,” then click on the Add to Outlook link. Your Planner tasks will be visible on your Outlook calendar and you can easily toggle their visibility on and off. This integration will ensure that you don’t miss any task deadlines. For additional details, read the Planner blog post I link to in the transcript and resources guide. Last September at Microsoft Ignite, we announced new search capabilities in SharePoint Online that enable the discovery of people, information, and expertise from across your organization. This personalized experience is now rolling out to all Office 365 subscribers. Now, wherever you start your search in SharePoint or, you’ll see consistent, personalized results powered by the Microsoft Graph. The search results are arranged into sections: Sites, Files, People, and News. You can expand the search results to see more information before opening the item, and you have the choice of opening the item or going to the location where the file is stored. That’s huge! When you exit a search results page, you return to the page where you started your search. Try this new search capability today and I think you’ll find, as I did, how powerful and flexible it is. Microsoft 365 brings together Office 365, Windows 10, and Enterprise Mobility + Security. The new Microsoft 365 Admin Center, which I covered last month, is a single place for admins to get started with Microsoft 365 and discover the breadth of management capabilities and experiences available. In early April, Microsoft rolled out the first of two key components I mentioned last month: the Security & Compliance Center. It maintains the centralized experience, intelligence, and customization that Office 365 security and compliance center offers today. It gives data administrators, compliance officers, and security administrators robust security and compliance controls across Office 365, Enterprise Mobility + Security, and Windows, all in a single place. Over the coming months, Microsoft will continue to add new capabilities to help admins deploy and manage security and compliance solutions, helping organizations optimize their resources. For Microsoft 365 customers, the new admin experience will be available automatically, once rolled out to your tenant. Secure Score analyzes your Office 365 organization’s security based on your regular activities and security settings, and then assigns a score. Many people think of it as a credit score but for organizational security, only you can’t use Secure Score to get a loan. Back in the February update video, I made this promise: Coming soon, Microsoft will be introducing an industry average score in Secure Score. This will show how your score compares to other organizations that have designated the same industry. That day has arrived, but first I have some important news regarding the service overall. A common piece of feedback Microsoft heard was that is great for Office 365, but what about other Microsoft solutions? To address that feedback, on April 17th Microsoft announced that Office 365 Secure Score is now Microsoft Secure Score. Microsoft Secure Score builds on top of what was in Office 365 Secure Score and adds even more. One new feature you will notice as soon as you log in is the new Microsoft score which is made up of your Office 365 Secure Score and your Windows Secure Score. The Windows score come from Windows Defender Advanced Threat Protection, or ATP, which provides information about the status of your antivirus, operating system security updates, firewall status, and other controls. To get the details of your Windows score, you can click on the “Windows Defender Security Center” link below your Windows score to go directly to the dashboard in Windows Defender ATP. Beyond adding Windows to Secure Score, Microsoft Secure Score now supports Intune. This surfaces though the existing mobile device management controls. Lastly, you’ll be able to compare your Secure Score against the scores of organizations in the same industry based on what industry you designate in the Service Assurance section of the Office 365 Security and Compliance Center. To try out Microsoft Secure Score now you can go to and log in with your administrative credentials, or click on the Secure Score widget on the Office 365 Security and Compliance Center home page. That’s all we have time for. Remember, send your feedback or success stories to [email protected] I’m Jim Naroski, thanks for watching, and I’ll see you again soon! (Music)


  • Reply 河端善博 May 8, 2018 at 9:38 pm

    Thank you, I'm fan this video

  • Reply Yuche Yahya Sukaca May 8, 2018 at 11:41 pm

    Thank you

  • Reply Sharon Huang May 9, 2018 at 1:07 am

    I like O365 monthly update videos. it just saves time to view all the notifications from admin center and gives me the most important release and up coming features. Fantastic!

  • Reply Murat A. Vogt May 9, 2018 at 6:16 am

    Awesome Video – one Questions though …. How does Microsoft Score work together with GDPR? Won't there be any Problems with that? doesn't the score break down to the Point to "per user behaviour"?rgdx

  • Reply HrecziYT May 9, 2018 at 12:45 pm

    Come back clippy!

  • Reply AJ Brown May 9, 2018 at 3:36 pm

    I love these great videos. However when are we going to be able to shrink the outlook email header when using the preview pane?

  • Reply Sidney Erickson May 9, 2018 at 8:14 pm

    I really like your videos. Keep up the great work! Can't believe someone would give a thumbs down. I think they should try their hand at making videos before judging so harshly.

  • Reply James Allen May 9, 2018 at 9:56 pm

    Still waiting for custom fields in planner. It has a high number of votes in the user voice app. I wish Microsoft would look at what customers want and not just what they think is best for us.

  • Reply Markus Kleinen May 9, 2018 at 11:57 pm

    This is the best source to achieve information updates on the permanently changing Office 365 ecosystem. Videos are briefly and succinctly and presented pretty cool.

  • Reply James Brown May 10, 2018 at 9:05 am

    I noticed with Microsoft Publisher™ there's no way to password the file.

  • Reply wroot May 14, 2018 at 10:11 am

    I have imported Planner My Tasks view into Outlook calendar, but it is empty. I have tasks with start today and with due date and it is not appearing..

  • Reply Farman Ali Shah May 15, 2018 at 10:49 am

    I have not yet this updates. Office 365 subscriber. Version 1804 (Build 9226.2156).

  • Reply Harjit Singh May 15, 2018 at 12:47 pm

    Hi Microsoft, great video btw! I just had a quick question not relevant to Office 365, do you guys have a playlist for Powershell? All videos i seem to find are from like 4/5 years ago and i dont want to learn from them because they are outdated and alot can change in 4/5 years. Thanks

  • Reply Waheed Rafiq May 21, 2018 at 12:55 pm

    Excellent wealth of useful information

  • Reply Sonaja Samuara May 21, 2018 at 6:27 pm

    First i like to say that you produce very good videos. Thank you!

    Unfortunately i have to enter this complaint and i hope this will find attention on Microsoft senior team.

    Microsoft talks about how good their workplace of the future is. However, just try to setup a nice start page for your sharepoint online intranet as a welcome to your users. App launcher "Sharpoint" will direct you to a useless _layouts/15/sharepoint.aspx start page. You can not modify this page or direct to another start page in order to give your users a well managed start to your intranet information hub.

    All requests from many admins at the microsoft voice portal to change this behavior are ignored since long time.

    Maybe Microsoft should focus on down to earth solutions before talking in marketing how good that future workplace is.

    My users are not IT professionals, it is not very funny what Microsoft is offering as a sharepoint main landing page. Anybody at Microsoft using this product themselves ?

  • Reply John D May 23, 2018 at 8:25 pm

    This is really helpful. There are many times features are released, and no one knows about them. @sp_marketplace

  • Reply erin davitt May 24, 2018 at 9:20 am

    Thank you! Is there an option to have Outlook type by voice? I'm getting that lazy …lol.

  • Reply mau guevara May 27, 2018 at 6:14 am

    Its very faster

  • Reply michel hilario June 7, 2018 at 9:18 am

    Hi, any O365 updates for June 2018? 🙂

  • Reply Jt Ll June 21, 2018 at 9:32 am


  • Reply Allen Lorenz Hembrador July 1, 2018 at 6:30 am

    Good day, i have a question what will happen if i bought and install a microsoft office 365 in my laptop and then few months after i need to reformat my laptop can i still re install it and continue my 1 year subscription…

  • Reply Bhanu prasad July 5, 2018 at 4:22 am

    So.. now are you going to rename this updates to Microsoft 365 Update? ☺

  • Reply Harvey Neve August 2, 2018 at 6:56 am

    Hi.. I can't seem to find your "how Harry (Doug) got organized video" any more. We use this to train on using Outlook with a reference file, categories and search folders… powerful stuff. Is there any reason its gone? can you repost it please?
    thank you

  • Leave a Reply