Monday, March 15, 2021

Master Excel functions & formulas




-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


للاشتراك في قناة التليجرام اضغط هنا

مدونة شيرين المصري للكمبيوتر

مدونة شيرين المصري للغة الانجليزية


شاهد أيضاً مواضيع مشابهة

كورس Camtasia Studio مونتاج الفيديو الاحترافي ببرنامج كامتازيا


Master PowerPoint ماستر مايكروسوفت باوربوينت - واجهة عربية


ماستر دوال ومعالات الاكسيل Master Excel formulas &functions


احترف مايكروسوفت اكسيل من خلال المشاريع العملية والمحاسبية


Master Excel functions & formulas





2 comments: