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
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap