-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.
click here to enroll
للاشتراك في قناة التليجرام اضغط هنا
مدونة شيرين المصري للكمبيوتر
مدونة شيرين المصري للغة الانجليزية
شاهد أيضاً مواضيع مشابهة