Excel Functions - The Essentiel To Know

Know How and When to use use Functions in Excel
Free tutorial
Rating: 4.2 out of 5 (10 ratings)
1,648 students
45min of on-demand video
English
English [Auto]

Using SUM Functions
What is 3D Formulas
- MAX - MIN - IF - IFS
- LOOKUP - XLOOKUP
- Text To Column Feature
- Transpose your data
- Creat Unique Liste

Requirements

  • No advanced knowledge for Excel
  • Basic Knowledge of how to use a computer and a stable Internet Connection.
  • Having Microsoft Excel installed on your computer
  • Some of the features may not work on the version older than 2016

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.

Who this course is for:

  • For beginners and anyone who want to start and learn Excel
  • For any other level who want to practice more Excel.

Instructor

Coaching and Training
EL AMRANI Anass
  • 4.3 Instructor Rating
  • 13 Reviews
  • 1,657 Students
  • 2 Courses

Hey there, Let's start with a small talking about why I am here.

When I discovered for the first time that Excel can do more than it shows, I was surprised, I had the tool for a long time installed in my PC but never used it to do something more than basics calculation, and some charts that had no meaning or beautiful style, so I am here to share this knowledge with u and go the next level using Excel.

Top companies trust Udemy

Get your team access to Udemy's top 17,000+ courses