Top New Features In Excel

NEW FUNCTIONS

CONCAT

This new function is like CONCATENATE, but better. First of all, it’s shorter and easier to type. But it also supports range references, in addition to cell references. Learn more about CONCAT.

IFS

Tired of typing complicated, nested IF functions? The IFS function is the solution. With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else “catch all” if none of the conditions are met. Learn more about IFS.

MAXIFS

This function returns the largest number in a range, that meets a single or multiple criteria. Learn more about MAXIFS.

MINIFS

This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria. Learn more about MINIFS.

SWITCH

This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the “else” is returned. Learn more about SWITCH.

TEXTJOIN

This function combines text from multiple ranges, and each item is separated by a delimiter that you specify. Learn more about TEXTJOIN.

NEW CHARTSExcel MapChart with Value data

Map charts

You can create a map chart to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries/regions, states, counties or postal codes. 

Funnel charts

Funnel charts show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel.

Funnel chart showing sales pipeline; stages listed in the first column, values in the second

ENHANCED VISUALSSlide with examples of SVG filters

Scalable Vector Graphics (SVG)

Bring visual interest to your documents, worksheets, and presentations by inserting Scalable Vector Graphics (SVG) that have filters applied to them.

Convert SVG icons to shapes

Transform all SVG pictures and icons into Office shapes so you can change their color, size, or texture.
3D model showing rotation handles

Insert 3D models to see all the angles

Use 3D to increase the visual and creative impact of your workbooks. Easily insert a 3D model, then you can rotate it through 360 degrees.

INK IMPROVEMENTSShow ink equation pane in PowerPoint

New ink effects

Express your ideas with flair using metallic pens and ink effects like rainbow, galaxy, lava, ocean, gold, silver, and more.Pen dropdown showing Ink Effects

Ink equations

Including math equations has gotten much easier. Now, you can go to Insert > Equation > Ink Equation, any time you want to include a complex math equation in your workbook. If you have a touch device, you can use your finger or a touch stylus to write math equations by hand, and Excel will convert it to text. (If you don’t have a touch device, you can use a mouse to write, too). You can also erase, select, and correct what you’ve written as you go.

Digital Pencil

Write or sketch out ideas with our new pencil texture.

Customizable, portable pen set

Create a personal set of pens to suit your needs. Office remembers your pen set in Word, Excel, and PowerPoint across all your Windows devices.Blue pencilPen gallery

SHARING GOT MORE EASIER

Insert recent links

Easily attach hyperlinks to recent cloud-based files or websites, and create meaningful display names for people using screen readers. To add a link to a recently used file, on the Insert tab, choose Link and select any file from the displayed list.Insert recent links

View and restore changes in workbooks that are shared

Quickly view who has made changes in workbooks that are shared, and easily restore earlier versions.

Quickly save to recent folders

This feature was highly requested by our customers: Go to File > Save As > Recent, and you’ll see a list of recently accessed folders that you can save to.

GENERAL IMPROVEMENTS

  • PRECISION SELECTING
  • QUICK ACCESS TO SUPERSCRIPT AND SUBSCRIPT
  • IMPROVED AUTOCOMPLETE
  • NEW THEMES
  • DARK MODE
  • CSV (UTF-8) SUPPORT
  • DATA LOSS PROTECTION (DLP) IN EXCEL

PIVOT TABLE ENHANCEMENTS

PivotTable with callouts showing the new features in Excel 2016

  • Personalize the default PivotTable layout   
  • Automatic relationship detection  
  • Creating, editing, and deleting custom measures   
  • Automatic time grouping 
  • PivotChart drill-down buttons   
  • Search in the PivotTable   
  • Smart rename   
  • Multiple usability improvements  
  • Multi-select Slicer   
  • Faster OLAP PivotTables!   

Slicer choices with the multi-select button highlighted

Are you looking for a full fledged training? You are at the right place.

At TechnoExcel :

You can upskill yourself with:

Why us?

Techno Excel is a leading provider of Excel courses and data analytics courses. We not only teach you how to use excel but also help customize it for your exact needs! Make the most out of your career with Techno Excel. Students can join via classroom course or via Online course. This is the place where students can easily learn the required skill set to get placed immediately

Learn data science and other technologies at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace. Whether you are a beginner or a professional looking for advanced techniques, we have the right course for you. Hurry up!! Book your seat now!!!

Class-room of your choice

Upskill yourself by attending classroom or online class.

Flexible timings

Learn at your convenient time. We have a flexible schedule, which is designed to suit your learning style and pace.

Class-Room Size

With limited students in class, attention to each student's performance will be given.

Industry Ready Curriculum

The course is designed for people who want to work in the industry.

Book your free consultation now

If you want to improve your skills and get ready for the workforce! Please enter your information below, and one of our expertise will contact you shortly.

    Leave a Comment

    Your email address will not be published. Required fields are marked *