Microsoft Excel 2016 Version Overview

If you're considering upgrading to another version of Microsoft Excel before attending a training course or arranging custom training, check out this list of some of the new features in Excel 2016.

Important Note for 2016 Applications: Microsoft Office, Visio and Project 2016 cannot coexist on the same computer as standalone Office 2013 applications. This includes Office 2013, Office 365, Visio 2013 and Project 2013. If you have one of the following programs running you won't be able to install your 2016 application until it is upgraded: Project 2013, Visio 2013, Word 2013, Excel 2013, Powerpoint 2013, Outlook 2013, Publisher 2013 and Access 2013.

If you are using Excel 2013 or considering upgrading to 2013, check out key new features in our Microsoft Excel 2013 version overview.

If you are using Excel 2010, check out key new features in our Microsoft Excel 2010 version overview.

Looking for Microsoft Excel training courses?

VIEW COURSES >

Microsoft Excel 2016 New Features

Applies to: Microsoft Excel 2016 for Windows

The following are some of the key new features available in Microsoft Excel 2016. Some features are available only to Office 365 subscribers.

Six New Chart Types for Data Visualization

In 2016, six new chart types have been added:

Treemap
Sunburst
Waterfall
Histogram
Pareto
Box and Whisker

3D Maps for Geospatial Visualization

In Excel 2016, 3D Maps can be inserted and are useful as a geospatial visualization tool. This tool is built into Excel and is available to all 2016 users. 3D Maps was previously known as Power Map. 3D Maps can be inserted using the Insert tab on the Ribbon.

Powerful Querying with Get & Transform

Transform and query data in a powerful way using Get & Transform on the Data tab on the Ribbon. Enhanced querying capabilities are now available natively in Excel which were previously available as a separate add-in called Power Query.

Improved Pivot Tables, Pivot Charts and PowerPivot Tables

Excel 2016 includes several enhancements:

Automatic relationship detection
Creating, editing and deleting custom measures
Automatic time grouping (such as by year and month)
PivotChart drill-down buttons
Search in the PivotTable
Smart renaming
Delayed updating
Multi-select slicers on touch devices

Forecasting Tools

In Excel 2016, the FORECAST function has been extended to allow forecasting based on exponential smoothing (such as, FORECAST.ETS() …). You can also forecast by clicking on a Forecast Sheet button on the Data tab on the Ribbon to quickly create a forecast visualization of your data series.

New Templates

New financial and calendar templates have been added in 2016:

My Cash Flow Template
Stock Analysis Template
Calendar Insights Template (with drilldown)

New Excel Window Themes

There are now three Office themes that you can apply to control the appearance of your Excel window – Colorful, Dark Gray and White. To access these themes, click on the File tab on the Ribbon and then click on Options. Click on the General category on the left and then click on the drop down menu next to Office Theme.

Get to Features or Help with Tell Me

In Excel 2016, a box appears on the Ribbon with Tell me what you want to do. You can enter words and phrases in the box and quickly get to features you want to use or actions you want to perform. You can also choose to get help or perform a Smart Lookup on a term you entered.

Get Insights

When you select a word or phrase, right-click on it and then choose Smart Lookup, the Insights Pane (powered by Bing) appears with definitions, Wiki articles, and top related searches from the web. Smart Lookup also appears on the Review tab on the Ribbon.

ADDITIONAL RESOURCES

Microsoft Excel 2016 and 2013 Maximum Limits and Specifications

Check out our blog for more Excel tips, tricks and shortcuts.

Public courses are delivered at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.

Avantix Learning Excel Courses | Frequently Asked Questions (FAQs)

Do you need more information? Contact us!

To request this page in an alternate format, contact our staff.

^ Back to top

Microsoft Excel training courses in Toronto. with instructor creating a virtual graph.

Custom training

Related Excel courses

Microsoft Excel: Introduction

Microsoft Excel: Intermediate / Advanced

Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools

Microsoft Excel: Visual Basic for Applications (VBA) | Introduction

VIEW MORE COURSES >

How to Lock Cells in Excel (Protect Formulas and Data)

It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …

How to Stop or Control Green Error Checking Markers in Excel

In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.

How to Password Protect Your Excel Worksheets and Workbooks

You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.

How to Modify Table of Contents Formatting in Word

If you have created a custom or automatic table of contents (TOC) in a Word document, you can add heading levels to the TOC. You can add or edit levels using built-in heading styles or use custom styles as levels.

How to Insert or Type U with an Accent Mark in Word (Ù, Ú, Û, Ü, ù, ú, û, or ü)

You can insert or type u with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter u can be inserted with an accent in both upper or lower case. The following are common accents in upper or lower case – Ù, Ú, Û, Ü, ù, ú, û, or ü.

How to Insert or Type the Beta Symbol in Word (β or Β)

You can insert or type the Beta symbol in Word documents in several ways. The Greek Beta symbol can be entered in upper case (Β) or lower case (β) using built-in commands or keyboard shortcuts (including Alt codes, AutoCorrect entries or custom shortcuts). Beta is the 2nd letter in the Greek alphabet and is comparable to the letter B.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca