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
![getpivotdata-for-working-with-pivot-tables](images/x-excel-functions70-1.png)
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.
![how-sumproduct-works-with-condition](images/x-excel-functions69-1.png)
Presentation of the capabilities of the SUMPRODUCT function with multiple criteria conditions. For example, summing subtotals by a criterion condition.
![how-to-use-rand-and-randbetween-functions](images/x-excel-functions68-1.png)
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?
![example-sumifs-with-dates-many-conditions](images/x-excel-functions67-1.png)
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?
![sumif-use-function-download-for-examples](images/x-excel-functions66-1.png)
Practical work of the SUMIF function with several conditions. Examples and ready-made test solutions with formulas for the functions SUMIF, SUMPRODUCT and VLOOKUP.
![step-by-step-instruction-of-function-lookup](images/x-excel-functions65-1.png)
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.
![download-examples-of-using-find-function](images/x-excel-functions64-1.png)
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.
![examples-of-using-search-function](images/x-excel-functions63-1.png)
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.
![assigning-function-sum-example](images/x-excel-functions62-1.png)
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?
![download-examples-logical-functions-and-or](images/x-excel-functions61-1.png)
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.