Excel functions with examples and descriptions for practical use

Examples of applying complex formulas and functions in Excel with detailed description. Data management in spreadsheets.

Examples of using functions

if-function-with-several-conditionsExcel IF function with multiple conditions for beginners.
Download examples of how to use the IF function for multiple conditions for algorithm operations. Combination of functions for IF formula and VLOOKUP.
examples-of-index-functions-step-by-stepExamples of INDEX functions step-by-step download in Excel.
Download a step-by-step example of the INDEX and MATCH formula where the VLOOKUP function does not work. Pros and cons of the INDEX function vs. VLOOKUP. Formula of INDEX and SUM functions.
vlookup-function-step-by-stepVLOOKUP function in Excel with step by step examples download.
Examples of using the VLOOKUP function with a detailed description and pictures of the formula scheme. How to use the VLOOKUP function to select data from a list by condition?

cell-function-examplesCELL function in Excel and examples of its use.
Examples of practical use of a simple and multifunctional cell function for working with the values and format of tables. How to use the CELL function?
search-over-find-functionComparing Search function vs Find Command differences in Excel.
A practical comparison of specific examples of functions FIND and SEARCH when working with text strings in cells. Examples of using the SEARCH function when working with data tables.
examples-using-large-and-smallExamples of using functions LARGE and SMALL in Excel.
Interesting examples of a formula for the unusual use of two popular functions LARGEST and SMALLEST in the analysis of arrays of numbers.
abs-converting-value-moduloExamples ABS function in Excel for converting the value modulo.
Function module ABS for arithmetic operations with negative numbers with a minus sign. Calculate absolute values for negative numbers.
count-countblank-countifExamples of functions COUNT, COUNTBLANK and COUNTIF in Excel.
An overview of the possibilities for counting the number of numerical values with and without a condition. Examples of how to use COUNT, COUNTBLANK and COUNTIF.
calculate-probabilityPROB function to calculate the probability of events in Excel.
Examples of calculating the percentage of the probability of an event occurring by simple calculations using the statistical function PROBABILITY.
char-sign-type-in-excelFunctions CHAR SIGN TYPE in Excel and examples of their formulas.
Examples of formulas for the use of auxiliary, but very useful functions of TYPE, SIGN and SYMBOL for quickly solving complex problems.
1 2 3 4 5 6 7

en ru