Learn Excel functions from zero to hero

Learn Excel functions from zero to hero

-This course teaches you in details how to use Excel functions, whatever your level you can use the functions & formulas and feel comfortable to work with Excel for all purposes.

- After studying and applying everything step by step you will be able to create your own program and organize your work in Excel without any help as a professional.

Benefits:

* The course duration is really short so you can learn and be professional in a short time.

* You can follow along the tutorial to learn how to use the functions and at the same time you already practice with me using all formulas.

* The course includes a lot of short videos that enables you apply every function separately and feel comfortable when you use the program.

*It also includes conclusions to remind you with all you studied during every section.

Studied topics:

During the course you will learn step by step the following topics:

1- basics of using functions (difference between formula and function - how to name cells and ranges - how to detect errors and correct them - nested functions)

2- CHANGING REFERENCE STYLE.

3- Simple calculations.

4- Simple comparisons in excel.

5- list separator in excel functions.

6- Hiding errors in functions.

7- Using text value with the formula.

8-Tracing precedents & dependents.

9- Relative, Absolute and mixed reference.

10- Text functions.

11- Statistical functions.

12- Lookup & reference functions.

13- math & trig functions.

14- Database functions.

15- Information functions.

16- logical functions.

17- Date & time

18- You will also take many short quizzes to memorize what you studied

19- conclusion of every section includes mind maps.

20- Mind maps that helps you remember and know the differences between every category of formulas and all formulas you studied in every separate section.

Basics and advanced tricks of using all Excel functions

Url: View Details

What you will learn

• You will learn all basics of using common, text , logical , mathematical functions.
• Most used functions in Excel
• Text functions, logical functions, Mathematical functions, Information functions, lookup and reference functions

Rating: 3.66667

Level: All Levels

Duration: 5 hours

Instructor: Shereen Elmasry