8 Excel 2016 New Functions

Excel New Functions

This new function allow to add handwritten equations to text, so you can add mathematical equations more easily to excel documents. The sketches of the equations can be made using a mouse or a digital/fingers.

Ink Equations  

This new function allow to add handwritten equations to text, so you can add mathematical equations more easily to excel documents. The sketches of the equations can be made using a mouse or a digital/fingers.

Go to ‘Insert’ > ‘Symbols’ > ‘Equation’ > ‘Ink Equation’ (from drop-down menu).

8 Excel 2016 New Functions

New charts

Excel 2016 has introduced six new charts which provides better analysis options for the users.

Select data table, Go to ‘Insert’ > ‘Recommended Charts’, then pick one.

Excel New Functions

If need any other chart format that shown in recommended charts go to ‘All Charts’ and then select a one. 

Excel 2016 New Functions

Insert pictures with the correct orientation

With this new feature, when insert an image, it automatically rotates the picture to match the original (camera) orientation. Then if you want you can manually rotate the image to any orientation.

One click forecasting

The FORECAST function has been further developed to provide forecasting with Exponential Smoothing. This function is also available as a new one-click forecasting button.

Go to ‘Data’ > ‘Forecast Sheet’ to create a forecast visualization of the selected data series.

Forecast Sheet

3D Maps

3D geospatial visualization tool has now been introduced as ‘3D Maps’ with new features included.

3D Maps Excel

Multi-select slicer

Multiple items can be selected on a touch device, which was not available with the previous version. Slicer multi-select mode can be enabled by using the new button showed in the Slicer’s label.

Multi-select slicer

Quick Shape Formatting

New preset styles are introduced in default shape styles.

Quick Shape Formatting

New Templates

The new set of templates include My Cashflow, Stock Analysis and My Calendar. Excel provides more advanced features on these to manage the intended tasks.

Go to ‘Let’s Get Started’ and then Excel displays the templates.

Excel 2016 New Functions

New Themes

There are three Office themes available now: Colorful, Dark Gray, and White.

To change the theme, go to File > Options > General, and then go to the drop down menu next to Office Theme.

Data Loss Protection (DLP) in Excel

This Data Loss Protection (DLP) is a very important feature that provides real time scanning of content with a set of predefined policies for the most common sensitive data types (e.g., credit card number, passwords etc.).

Improved version history

Go to File > History to view the changes made to your workbook and also to access the earlier versions.