Summary of Excel functions only available in Office 2016

Summary of Excel functions only available in Office 2016


Compared to the previous version, the Excel function on Office 2016 is upgraded to meet users. Summary of Excel functions only available in Office 2016 will be shared by Taimienph.vn in the following article, you can refer to using the appropriate function.


As we all know, Excel tools on Office 2016 microsoft as well as versions of Office 2007 or Office 2003 have mathematical functions for working and learning useful, but in Excel on Office 2016 is updated by Microsoft. Some of the new functions are very useful that neither Office 2007 nor Office 2003 has, the Excel function summary article only available on Microsoft Office 2016 will help you understand the meaning and usage of the new functions.

Summary of Excel functions only available in Office 2016

Excel text functions

– CONCAT function in Excel 2016

Combine 2 or more text strings.

Concat function example:

On the worksheet below, it is possible to join the text strings in cells A1, B1 and C1 together using the Excel Concat function as shown below:

= CONCAT (A1: C1)

And provide the resulting text string: C: Users Jeff.

– TEXTJOIN function in Excel 2016

Combine two or more text strings, separated by spaces.

– Textjoin function example:

On the worksheet below, it is possible to concatenate the text strings in cells A1, B1 and C1 together, separated by spaces using the textjoin function as shown below:

= TEXTJOIN (“”, TRUE, A1: C1)

Create an excel spreadsheet in Excel 2016 Office 2

The function provides the result of the text strings C: Users Jeff.

Logic functions in Excel 2016

– IFS function in Excel 2016:

Checks whether one or more conditions are met and returns the value corresponding to the first TRUE condition.

IFS function example:

In the worksheet below, the IFS function can be used to divide the value in cell A1 by a value other than the first value in cells B1-C1:

= IFS (B1 0, A1 / B1, C1 0, A1 / C1)

Install all functions in Excel 2016

And the result is 10.

(For example, the value in cell A1 divided by the value in cell C1).

– SWITCH function in Excel 2016:

Compare a value called an expression based on a list of values ​​and return the result corresponding to the first match value.

Example of the Switch function:

In the worksheet below, the switch function is used to return a season result related to the value in cell A1.

= SWITCH (A1, 1, “Spring”, 2, “Summer”, 3, “Autumn”, 4, “Winter”)

Install all functions in Excel 2016

Providing the result is Summer.

Statistical functions in Excel 2016

– FORECAST.ETS Exel 2016 function:

Use an exponential algorithm to predict future values ​​over a timeline, based on a range of existing values.

Example function Forecast.Ets Function :

If calculating and forecasting monthly income, use the Forecast.Ets function to forecast income for the next month, like the example in the spreadsheet below:

Install all functions in Excel 2016

– FORECAST.ETS.CONFINT 2016 function:

Returns the confidence interval for the forecast value at a specified destination date.

Example of Forecast.Ets.Confint function:

The spreadsheet below shows a range of earnings from August 2016 to April 2017, the Forecast.Ets function is used in cell G11 to predict earnings in May 2017.

Jaw Forecast.Ets.Confint used in cell C13, to calculate a reliable interval for the forecast value:

Install all functions in Excel 2016

Summary of Excel functions only available in Office 2016

– FORECAST.ETS.SEASONALITY 2016 function:

Returns the length of a repeating pattern pattern that Excel detects for a specified time series

Function example Forecast.Ets.Seasonality :

If there is a range of monthly earnings, use the function Forecast.Ets.Seasonality to detect the length of a pattern, like in the worksheet below:

Install all functions in Excel 2016

– FORECAST.ETS.STAT 2016 function:

Returns a statistical value that is the result of a time series forecasting process.

Function example Forecast.Ets.Stat :

The spreadsheet below shows a range of monthly earnings from August 2016 to April 2017, the Forecast.Ets function is used in cell G11 to predict May 2017 earnings.

Jaw Forecast.Ets.Stat used in cell C13, to return the Alpha parameter of the ETS algorithm:

Install all functions in Excel 2016

– FORECAST.LINEAR function in Excel 2016:

Predict a future point on the trendline trendline set into a set of x and y values.

Function example Forecast.Lineear :

In the worksheet below, the Forecast.Linear function is used to predict the value of the trendline through the available x and y values ​​in cells F2-G7 with the value x = 7:

Install all functions in Excel 2016

– MAXIFS function in Excel 2016:

Returns the maximum value between cells specified by a given set of conditions or criteria.

Example function Maxifs :

In the worksheet below, use the Maxifs function to calculate the maximum number of test scores provided in Group 1:

= MAXIFS (C2: C9, B2: B9, 1)

Install all functions in Excel 2016

The result provided is 77%.

– MINIFS function in Excel 2016:

Returns the minimum value between cells specified by a given set of conditions or criteria.

Example function Minifs :

In the worksheet below, use the Minifs function to calculate the minimum test score in Group 2:

= MINIFS (C2: C9, B2: B9, 2)

Install all functions in Excel 2016

The result provided is seventy three%.

This is a summary of Excel functions that are only available in Office 2016 but not in Office 2007 and Office 2003, updated to help users more easily filter, format, and calculate on Excel tools.

https://thuthuat.taimienphi.vn/tong-hop-ham-excel-chi-co-tren-office-excel-2016-22942n.aspx
Back with the Excel function available in all versions, the SumIF function is one of the most commonly used functions, the Sumif function supports conditional sums in worksheets that users need to do, in addition, when using the function. SumIF with other functions, your problem or job will be processed faster.

.

Related Posts

Leave a Reply

Your email address will not be published.