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 <span style="color: darkgreen; font-weight: bold;">Excel</span> 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**.

This course is designed for beginners who want to start exploring formulas in Excel. You'll begin with the basics and then discover some really useful formulas for daily use. You'll learn about array formulas and how they work, and you'll also dive into Lookup and Reference functions.

In this section you will learn how to input and use Excel formulas for various calculations, including basic operations like addition, subtraction, multiplication, division, and power. Discover the importance of using functions for clearer and more efficient calculations. Explore statistical functions like AVERAGE, MEDIAN, MODE, MIN, and MAX to analyze data effectively.

In this section you will learn about array formulas in Excel and how they enable multiple calculations on sets of values simultaneously and how to use specific functions like UNIQUE, SORT, FILTER, and TRANSPOSE.

In this section, you will learn about lookup and reference formulas in Excel. These formulas enable you to search for and retrieve specific data from a table or range. You will explore essential functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, and XLOOKUP, which are invaluable for finding and referencing data efficiently.


	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

Excel Formulas

Overview