Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Overview | Lookup and Reference
Excel Formulas
course content

Conteúdo do Curso

Excel Formulas

Excel Formulas

1. Basic Formulas
2. Array Formulas
3. Lookup and Reference

bookOverview

Congratulations on completing the Excel Formulas! 🎉

Mathematical Formulas
SUM=SUM(range) - Adds all the numbers in a range of cells
MULTIPLY=A1 * B1 - Multiplies the values in cells A1 and B1
SUBTRACT=A1 - B1 - Subtracts the value in cell B1 from the value in cell A1
DIVIDE=A1 / B1 - Divides the value in cell A1 by the value in cell B1
Statistical Formulas
MEAN=AVERAGE(range) - Calculates the average of a range of numbers
MAX=MAX(range) - Returns the maximum value in a range of numbers
MIN=MIN(range) - Returns the minimum value in a range of numbers
AVERAGE=AVERAGE(range) - Calculates the average of a range of numbers
MEDIAN=MEDIAN(range) - Returns the median of a range of numbers
Lookup and Reference Formulas
MATCH=MATCH(lookup_value, lookup_array, [match_type]) - Finds the position of a value in a range
CHOOSE=CHOOSE(index_num, value1, [value2], ...) - Chooses a value from a list based on an index number
INDIRECT=INDIRECT(ref_text, [a1]) - Returns the reference specified by a text string
VLOOKUP=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) - Looks up a value in the first column of a table and returns a value in the same row from a specified column
XLOOKUP=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) - Searches a range or an array, and returns an item corresponding to the first match it finds
Array Formulas
UNIQUE=UNIQUE(range) - Extracts unique values from a range
SORT=SORT(range) - Sorts the contents of a range
FILTER=FILTER(range, condition) - Filters a range based on a condition
TRANSPOSE=TRANSPOSE(range) - Transposes the rows and columns of a range

Of course, this is not all the formulas Excel can offer, but now you've learned the basics of formulas and the most popular ones and how they work. With them you will be able to solve 80% of problems and daily tasks.

Finish the course?

Finish the course?

Selecione a resposta correta

Tudo estava claro?

Como podemos melhorá-lo?

Obrigado pelo seu feedback!

Seção 3. Capítulo 5
some-alt