Course Content

# Excel Beginner Course

1. Getting Started with Excel

2. Working with Formulas and Functions

Excel Beginner Course

## Different Types of Functions

Now that we have understood what functions and formulas are, we are going to understand some of the major categories for functions.

**Mathematical Functions**: These functions perform*basic mathematical operations*and are among the most commonly used in*Excel*. Examples:`SUM`

,`AVERAGE`

,`MIN`

,`MAX`

…**Text Functions**: Text functions*manipulate and format text*data in Excel.Examples:`CONCAT`

,`LEN`

,`LEFT`

,`RIGHT`

,`UPPER`

…**Date and Time Functions**: These functions are used for*date and time*calculations and formatting. Examples:`TODAY`

,`NOW`

,`DATE`

,`TIME`

,`DATEDIF`

…**Logical Functions**: Logical functions are used to*evaluate conditions*and return results based on those conditions.Examples:`IF`

,`AND`

,`OR`

,`NOT`

…**Lookup and Reference Functions**: These functions are used to*search*for*specific values*within a range or retrieve data from other cells.Examples:`VLOOKUP`

,`INDEX`

,`MATCH`

;**Statistical Functions**: Statistical functions help*analyze data*by providing various statistical measures. Examples:`COUNT`

,`STDEV`

,`RANK`

…**Financial Functions**: These functions are useful for*financial and economic*calculations. Examples:`PV`

,`FV`

,`IRR`

.

You can access all these functions (together with the official documentation) from the **Formulas section**:

We will play around with some of the above formulas, but for now, we reached the end of this chapter.

Let’s answer to this quiz in order to move forward to the next one:

Which type of functions is used for financial and economic calculations in Excel?

Select the correct answer

Try it in your own workbook. Try to use the CONCAT function to concatenate two cells containing 2 numbers. Does Excel allow it?

Select the correct answer

Everything was clear?