Excel formulas for calculation different types of data with examples and description

Ready solutions for Excel with the help of formulas working with data spans in the process of complex computations and calculations.

Computing operations with the help of formulas

index-match-multiple-search-criteriaFormula INDEX and MATCH with Multiple Search Criteria in Excel.
An example of searching and selecting values from a source table using the formula of the INDEX and SEARCH functions. How to create a formula to search using multiple criteria?
filling-noncontiguous-rangeFilling Nonadjacent Range of cells in Excel simultaneously.
The effective way to quickly fill any range of cells. The entering values into individual cells horizontally and vertically.
how-enter-formula-with-mouseHow to enter the formula in the Excel program with the mouse.
Effective methods for entering formulas and links to cells using the mouse or the arrow keys of the keyboard. How correctly and quickly to enter the formula in a cell?

calculating-formula-volume-areaCalculating the formula of volume and area in Excel.
Fast and multiple calculation of arithmetic formulas to calculate the volume or area for different geometric shapes in large numbers.
fill-cells-automaticallyHow to fill cells in Excel with large tables automatically.
Effective ways of automatic filling of cells of tables. The examples of semi-automatic filling of duplicate data in random order are given.
change-all-prices-at-onceExample how to change all prices at once in Excel.
The methods of increasing prices in price lists and invoices with VAT. Control and correction of errors in rounding of fractional numbers.
formula-bar-in-excelThe Formula Bar in Excel, its settings and the purpose.
How to use the formula string and what advantages does it provide for entering and editing data in cells? How to enable or disable the formula bar in the program settings.
calculate-percentage-deviationPercent deviation formula in Excel for calculating mark-up.
Two formulas for calculating the relative deviation in percent. The practical example is how to calculate the percentage deviation in the reports.
vlookup-multiple-criteria-conditionsVLOOKUP function with multiple criteria conditions in Excel.
The example, how to use the VLOOKUP function across multiple columns for the same data table. The formula for the combination of VLOOKUP and IF functions.
autocomplete-cells-in-tableAutocomplete of the cells in Excel from another data table.
The formulas for autocompleting cells. The methods for automating routine work with large tables and databases. The practical example of using the functions INDEX and MATCH.
1 2 3

en ru