Arabic
You’ll learn the following in this course :
-
Microsoft Excel Tips and tricks.
-
Most important Excel basic functions and formulas.
-
How to use Excel shortcuts.
This free course is made for those who are interested in data analysis. Moreover, it will give you an idea on how can you link up data together following the data modelling principles.
This course will help you to start data analysis from scratch and it will be your first step for developing your analysis skills and finding new work opportunities.
At the end of this course, you’ll understand the following :
-
Understand all Microsoft Excel options and settings, this is explained in a step by step approach.
-
Using Excel shortcuts for saving a lot of time and efforts.
-
How to customize Excel interface to make you faster in doing analysis tasks.
-
Most important basic Excel functions (SUM, IF Statement, COUNT, AVERAGE, SMALL, LRAGE and many more ..).
-
How to apply Anchoring and Formatting in a very easy way.
-
How to make data grouping in order to organize your data.
-
Trace functions and formulas using trace precedents and trace dependents.
-
How to use Go to special and Conditional formatting.
-
Saving a lot of time by using Excel shortcuts for each and every action you need to take.
-
Organizing data using data modeling fundamentals and principles.
-
Using date functions in a very professional way.
Is this course for beginners ?
Yes, this course is prepared for those starting to learn analysis from scratch and planning for entering the data analytics field.
Course Information
Course Instructor
