exceltoxl.com

Hi there,

I just gone through the FORMULAS ribbon in Excel 2016 and found few additions and removals. The strange thing is one entire group of functions are missing. 

FUNCTIONS ADDED IN 2016:

• FORECAST.ETS : This function returns a forecasted value for a specific future target date using exponential smoothing method.
   
• FORECAST.ETS.CONFINT : This function will return a confidence interval for the forecast value at the specified target date.
   
• FORECAST.ETS.SEASONALITY : This function returns the length of the repetitive pattern, Microsoft Excel detects for the specified time series.
   
• FORECAST.ETS.STAT : This function returns the requested statistic for the forecast.
   
• FORECAST.LINEAR : This function calculates, or predicts, a future value along a linear trend by using existing values.

...

FUNCTIONS MOVED TO DIFFERENT GROUP IN 2016:

• CEILING : This function rounds a number up, to the nearest multiple of significance.
   
• This function was available in Math & Trigonometry Group but now it is moved to Compatibility Function.
   
• FLOOR : This function rounds a number down to nearest multiple of significance.
   
• This function was available in Math & Trigonometry Group but now it is moved to Compatibility Function.
   
• FORECAST : This function calculates or predicts a future value along a linear trend by using existing values.
   
• This function was available in Statistical Group but now it is moved to Compatibility Function.

FUNCTIONS REMOVED FROM EXCEL 2016:

There are 10 functions which are removed from TEXT FUNCTIONS. However, we can still use them like the way we use DATEDIF function. Good thing is, we will still get some help on these functions when searching through Excel help (F1) option.

• ASC
  
  
• DBCS
  
  
• FINDB
  
  
• LEFTB
  
  
• LENB
  
  
• MIDB
  
  
• PHONETIC
  
  
• REPLACEB
  
  
• RIGHTB
  
  
• SEARCHB

These three are also removed from Math and Trignometry Functions.

• CEILING.PRECISE
   
• FLOOR.PRECISE
   
• ISO.CEILING

ONE FUNCTION is ENHANCED:

• EXPONDIST : This one function is changed to EXPON.DIST with better improvements in the functionality.

FUNCTIONS ABSCONDED:

I didn't find DATABASE FUNCTIONS in Excel 2016 However, those functions are available and are working fine. Let me know if you find these absconded functions.

FUNCTIONS OVERVIEW:

There are 461 functions in Excel which are officialy listed in Excel 2013. However coming to Excel 2016 there are 5 more new functions added but 13 functions are removed. So, finally we have 453 functions listed in Excel 2016.

These functions are making Excel users to do some wonders in the reports.

That's it from end. See you in the next post.

DID YOU KNOW?

Please share your valuable feedback about this post using below comments section.

If you like this post, share it on your social networking sites to help your co-hearts.

To receive such updates to your inbox, JOIN OUR FAMILY here.

SOME IMPORTANT LINKS:

MASTER YOUR FORMULA SKILLS

MASTER YOUR EXCEL SKILLS

MASTER @ HOME

JOIN OUR FREE EXCEL TRAINING

Thanks,