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

Examples of using the GETPIVOTDATA function on dynamic charts controlled by pivot tables and data slices. Download a visualization template using the capabilities of the GETPIVOTDATA function.

Presentation of the capabilities of the SUMPRODUCT function with multiple criteria conditions. For example, summing subtotals by a criterion condition.

Random number generators in Excel with examples of practical use. How and where to use the RANDBETWEEN and RAND functions to generate a random number?

A template with examples of how to effectively use the broad capabilities of the SUMMESLYMN function under different conditions. How to use the function if there are many conditions with dates?

Practical work of the SUMIF function with several conditions. Examples and ready-made test solutions with formulas for the functions SUMIF, SUMPRODUCT and VLOOKUP.

Practical examples of using the LOOKUP function to find values in a table column. Finds the last filled cell in the row of each data range.

Practical examples of the FIND function with pictures, a description and a file of ready-made solutions. Formulas for using the FIND function to find values in columns of tables.

Formulas using the SEARCH function to find values in the columns of a table. Sample formulas in pictures with a description and source file of ready-made solutions.

Practical work in Excel on SUM functions download examples with pictures and descriptions. How to make the most of all formula functions to automatically sum cells?

How to work with the formula of logical functions AND OR IF to automate the analysis of table data. Examples in pictures and with a detailed description of a sample file of tables or formulas.