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?
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!
Copyright 2017 Avantix Learning Inc.
To request this page in an alternate format, contact our staff.
Custom training
Register now for a public scheduled course or contact us to discuss custom on-site or off-site training options.
Related Excel courses
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Visual Basic for Applications (VBA) | Introduction
You may like
Excel XLOOKUP Function (Overview, Syntax + Formula Examples)
The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.
How to Use Go to Special in Excel to Find, Select, Replace and Format Data
You can use Go To Special in Excel to quickly find and select cells of a specific type within your worksheet. It only selects cells in the current worksheet, not the entire workbook. Go To Special also searches within the selected range if a range has been selected. You can find many useful things using the Go To Special dialog box including formulas, constants, blanks, visible cells and conditional formatting. After you select multiple cells with Go To Special, you can enter data in the selected cells by pressing Ctrl + Enter or by applying formatting.
How to Lock Cells in Excel (3 Ways)
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 …
You may also like
How to Indent the Second Line of a Paragraph in Word (3 Ways)
You can indent the second line of a paragraph in Microsoft Word using the Ruler, the Paragraph dialog box or a keyboard shortcut. You can indent or outdent the second line of a paragraph.
How to Generate Random Text in Word
If you are creating a Microsoft Word document, template or mockup and you want to create placeholder text, you can generate random text using the built-in RAND function or LOREM function (which generates Latin or Lorem ipsum text).
How to Insert a Watermark in Word (like DRAFT)
You can insert a watermark in the background of one or more pages in a Microsoft Word document. Common watermarks are text such as DRAFT or CONFIDENTIAL but you can also add a picture watermark.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | info@avantixlearning.ca