Excel Functions – The Essentiel To Know

Excel Functions – The Essentiel To Know, Know How and When to use use Functions in Excel.

Course Description

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.


Online Tutorials
Show full profile

Online Tutorials

Online Tutorials is a website sharing online courses, and online tutorials for free on a daily basis. You can find the best free online courses and thousands of free online courses with certificates to take your knowledge to the next level with the free courses.

We will be happy to hear your thoughts

Leave a reply

Online College Courses
Logo
Register New Account