Excel Functions - The Essentiel To Know

Excel Functions - The Essentiel To Know

In This course you will :

Learn How to ------->

- Use Functions : What is the syntaxe of Functions.

- What Function to use : In generale a Function always had the name of what you want to do (U are searching for the maximum amount in a list of data then the Function called Max).

- When and how to use it : What is the purpose of each Function.

_______________________________________________________________________________________________

The Functions i included here are :

Of course its impossible to talk about all the function that Exce offer to use,but i tried to show the most used ones and in addition i tried to add some Features and technics may be usefull when you deal with Data.

You will have a lot of practice alongside with the videos,so keep practicing in each seasion.

You will see :

• SUM Function.

• 3D Formulas.

• MAX & MIN & IF & IFS (the last one availaible in the new version and the 365 version).

• The Lookups Functions : LOOKUP & XLOOKUP ( i did not talk about VLOOKUP & HLOOKUP they are old and had a lot of limitation)

I did not include the INDEX & MATCH but i invite you to learn them.

• How to creat a unique list.

• How to Transpose your data.

• How to separate a text in a cell to many columns.

----------------------------------------------------------------------------------------------> Enroll To the course now and learn all of that.

Know How and When to use use Functions in Excel

Url: View Details

What you will learn

• Using SUM Functions
• What is 3D Formulas
• - MAX - MIN - IF - IFS

Rating: 3.9

Level: Beginner Level

Duration: 1 hour

Instructor: EL AMRANI Anass