What's changed from Office 2013?

The changes between Office 2013 and 2016 are fairly minor, but there are a few differences you should be aware of.

Office

For the majority of tasks you complete you will not notice a difference between Office 2013  and 2016, but if you do require help you can start by trying the ‘Tell Me’ box.

The 'Tell Me' box

  • The Tell Me box appears in most Office 2016 programs to help you perform important tasks even if you don't know how to do something.
  • You can simply type what you want to do in this box.

Tell Me Box

  • Office will suggest a list of options you can use to complete your task.
    • If you have highlighted something in your document, you will see task specific options.

Insights

  • Insights lets you search for information within various Office 2016 programs.
  • If you select an individual word of phrase you can right click and select Smart Lookup. This will use Microsoft’s Bing search engine to bring up definitions, images, Wikipedia articles and other related information for not only the selected text but also the surrounding text.

Insights

Charts

  • More charting options. Office now has five new chart types:
    • Box and whisker plots used in statistical analysis
    • Histograms show frequency data in columns.
    • Sunburst charts show levels of a hierarchy that are represented in concentric rings.
    • Treemap charts compare proportions within a hierarchy.
    • Waterfall charts show a running total as values are added or subtracted.

Excel

  • Pulling in data from almost anywhere. A former add-on called Power Query is now built in to Excel. Power Query can pull data from various sources for analysis, including websites and SQL, Azure, Access, and other databases.
  • Predicting the future - The new time series forecasting functions can predict future values from historical data.

Outlook

  • Fast integration with other Office applications. When you attach an Office document to an email you're about to send, Outlook shows you a list of the files you worked on most recently.

Share this page: