# Function and formulas in Excel with examples

Description of the functions in Excel with pictures and examples of their application in practice.## Functions for efficient settlement

Functions for working with text in Excel.

To process string data, the functions of working with text are used. Examples of application of TEXT functions, separation and consolidation of text data, SEARCH, LEFT, RIGHT, MID, LEN, etc.

To process string data, the functions of working with text are used. Examples of application of TEXT functions, separation and consolidation of text data, SEARCH, LEFT, RIGHT, MID, LEN, etc.

Functions for working with a matrix in Excel.

The spreadsheet itself is a commensurate matrix. With the help of array functions, you can perform various matrix operations: solve, add, multiply, find the determinant and the inverse matrix.

The spreadsheet itself is a commensurate matrix. With the help of array functions, you can perform various matrix operations: solve, add, multiply, find the determinant and the inverse matrix.

The concatenate function in Excel: syntax and usage examples.

The CONCATENATE function combines several values in different cells into one. Works with strings and text values. But there are ways to link columns and dates with numbers.

The CONCATENATE function combines several values in different cells into one. Works with strings and text values. But there are ways to link columns and dates with numbers.

How to find the arithmetic mean in Excel?.

How to find the mean values using the built-in functions. We consider the arithmetic mean, incl. by condition; Mean percentage, standard deviation. We find the weighted average price.

How to find the mean values using the built-in functions. We consider the arithmetic mean, incl. by condition; Mean percentage, standard deviation. We find the weighted average price.

How to use the VLOOKUP function in two tables Excel.

Practical use of the VLOOK function on the example of two tables. Advantages and disadvantages. An example of a combination of using VLOOK with other functions performed in an array loop.

Practical use of the VLOOK function on the example of two tables. Advantages and disadvantages. An example of a combination of using VLOOK with other functions performed in an array loop.

How to round numbers in large and smaller side of the Excel.

Rounding functions according to mathematical laws, to the nearest larger or smaller and modulo. Rounding to the nearest integer, even and odd, to thousands and to the desired bit of fractional numbers.

Rounding functions according to mathematical laws, to the nearest larger or smaller and modulo. Rounding to the nearest integer, even and odd, to thousands and to the desired bit of fractional numbers.

COUNTIF function in Excel and examples of using it.

Syntax and features of the COUNT function. Examples with one or more criteria, multiple ranges, counting numeric and text values. Combination of functions: SUBTOTAL and COUNTIF.

Syntax and features of the COUNT function. Examples with one or more criteria, multiple ranges, counting numeric and text values. Combination of functions: SUBTOTAL and COUNTIF.

Random number generator Excel in functions and data analysis.

Make a random number generator using the RAND and RANDBETWEEN functions. How to generate a data array with a normal distribution and build a histogram?

Make a random number generator using the RAND and RANDBETWEEN functions. How to generate a data array with a normal distribution and build a histogram?

Examples of using SUMIF function with some criteria in Excel.

The functions SUMIF and SUMIFS allow you to summarize data satisfying one or more conditions. This is useful when working with long lists with multiple columns.

The functions SUMIF and SUMIFS allow you to summarize data satisfying one or more conditions. This is useful when working with long lists with multiple columns.

Logical functions in Excel with the examples of their use.

Logic functions check the validity of user defined conditions and return a value depending on the result. Huge opportunities are provided by the operator IF.

Logic functions check the validity of user defined conditions and return a value depending on the result. Huge opportunities are provided by the operator IF.

1
2