Excel Excel 2016 Function Tips

How To Use MINIFS Function In Excel

The MINIFS function is an advanced statistical function, which is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

How To Use IFS Function In Excel

IFS function is a new function added to Excel and only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

Combine Data With TEXTJOIN

Included in the group of six functions released by Excel 2016 is a very valuable function; TEXTJOIN.

MATCH- Excel 2016 Function

The MATCH function of Excel 2016 permits users to select the position of an object in a range instead of selecting the entire actual item

How To Create A Pareto Chart Using Microsoft Excel 2016

Microsoft Excel 2016 introduces a lot of new Charts for us to use in presentations.

Create A Sunburst Chart Using Excel 2016

Excel has recently introduced many new charts in its latest version.

Use Excel 2016 and Design Your Box and Whisker Chart

Among the numerous new charts available on the new Excel 2016 is the Box and Whisker Chart. This chart was originally created by John Tukey in the 1970s

Excel 2016 And Its Power Pivot Tool

Power Pivot is basically an Excel tool that was first introduced to the public in the year 2010. What exactly is meant by Power Pivot?

Easily Transforming and Shaping Data in Microsoft Excel 2016 Version

Raw data in most cases, are often in a form that is of no major benefits to the users due to the fact that they are messy.

The CONCAT function was recently introduced by replacing CONCATANETE function and the CONCAT is only available with the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

How to use SWITCH function in Excel

The SWITCH function is a highly useful function which can be used for various applications. This is newly introduced to Excel and it is only available in the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

What's new in Excel 2016 for Windows(Infographic)

Check out the What's new in Excel 2016 for Windows(Infographic) to know about:

8 Excel 2016 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.