Examples of combinations of functions in formulas in Excel
Function parameters with examples illustrated in informative figures and with a detailed description of the functioning of the attributes to fill.Interesting examples of functions in formulas
How to calculate the date in Excel.There are mathematical calculations of days between dates. The parameters of the DATEDIF function for calculating the exact age period: years, months, days. The ways of entering dates into cells.
Functions for working with dates in Excel: the examples of using.The functions for working with dates are in the Date and Time category. There are examples of the function DATE, DATEDIF, WEEKNUM, MONTH, WEEKDAY. How you can display the current date and time, the number of week (day of the week).
Transferring of table data via the VLOOKUP function.How to move data from one table to another one using the VLOOKUP function, which allows you not to enter values manually, but to do automatic substitution. The vlookup function works under certain conditions.
The functions of INDEX and MATCH in Excel and examples of their using.The examples of using the INDEX and the MATCH functions. Finding the positions and the indexes of the cells in the specified rows and columns of the array. Allocation the maximum number of the array.
Difference between VLOOKUP and HLOOKUP with examples.The examples of using the VLOOKUP and HLOOKUP functions. Searching of items, comparing of data in tables on two different sheets, preventing of errors, accessing to another book.
How to Use the Text Functions in Excel with Examples.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.
Excel function for Matrix Multiplication with examples.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.
CONCATENATE function and Opposite of concatenate in Excel.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 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.
