MVP #72: Six New Functions In Excel and One New Chart Type

, , No Comments
Good news!
Microsoft has added 6 new functions to Microsoft Excel and they are not functions that you might never find use for but functions that people have been asking for. In fact, I am already seeing the numerous ways they are going to make my Excel-ling life better.

Two complaints I hear people make a lot about CONCATENATE (the Excel function that lets you join the values/texts in different cells) are that why is the name that long? and can't we select a range?

Now Microsoft has nifty fixed those two issues in one cool function: CONCAT

CONCAT is short to write and allows you join entries selected as a range.

This takes CONCAT to a new level. So what if you want to put a comma and a space between the names as you are joining them? That is what TEXTJOIN enables you to do.

The formula that gets most people confused the most in Excel is nested IF. People find it hard to process the numerous brackets and IF statements that characterize a nested IF function. Now there's some relief. Excel has introduced IFS to help combat the strain of untangling brackets.

If you have a report and need to grade the performance with some conditions like we do for school marks to grades, then IFS is your new friend.

So what if you want to pass a comment on the grade performance? You want to say grade A means Excellent, grade B means Very Good, ... Well, that is what SWITCH allows you to do. It was borrowed from the programming community.

And there is also MAXIFS to let you do want you've been doing with SUMIFS and COUNTIFS, just this time you are picking the highest value that meets your criteria.

And this is the sixth and last: MINIFS. You've guessed right! It does similar stuff as MAXIFS but returns the minimum value that meets your criteria.

Black Theme
Office (Excel inclusive) now has a black theme.

And there's also added to the chart family, a funnel chart.


Post a Comment

You can be sure of a response, a very relevant one too!

Click on Subscribe by Email just down below the comment box so you'll be notified of my response.