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
Examples 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 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 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?
Comparing 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 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.
Examples 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.
Examples 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.
PROB 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.
Functions 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.
Excel examples HYPERLINK function to create dynamic hyperlinks.Examples of how to use and use the HYPERLINK feature to create dynamic hyperlinks to documents, web pages, and e-mail.
