Advanced Excel Skills 2 Course
Unlock the secrets of advanced Excel to boost your work efficiency
- English and Arabic
- With Certificate
Tutor Name
EdraakInterested learners
About the Course
Advanced Excel Skills 2 is a free course offered by إدراك to teach advanced Excel and falls under the Excel Mastery specialization along with courses on Excel programming using VBA, Excel Dashboards, Data Analysis using Excel, Excel Spreadsheets, and Advanced Excel Skills (Microsoft Excel).
The Advanced Excel Skills 2 course aims to develop and refine advanced Excel skills in learners and strengthen their individual capabilities so that they can find the right solutions to business requirements. The course also allows access to building information from the model database stored on the projects server. Learners need to have professional knowledge of Excel to be able to pass this course.
The Advanced Excel Skills 2 course includes many important topics for mastering Excel, such as: If Statements, Lookup data search formulas, Offset Function, Indirect formula, Circular References, comparison between Lookup data search formulas and Index formula, and matrix formulas through Index & Match.
Learners will also learn about some Excel tricks during the Advanced Excel Skills 2 course, along with advanced Excel ideas such as: how to improve formulas by using names in an advanced way and developing business using formulas, combining names and types of cell references, developing dynamic reports and linking them through filters, and developing reports using matrix formulas.
The Advanced Excel Skills 2 course explains how to deal with 3D formulas, use a dynamic cell range within formulas, use financial formulas, and use functions to develop business with less time and effort, so that you become an Excel expert. The course also explains how to use information retrieval formulas in business solutions and develop solutions using Text Functions.
In addition, the Advanced Excel Skills 2 course provides learners with advanced Excel ideas, including counting formulas, matrix formulas, counting formulas through matrices, conditional counting formulas, conditional counting formulas through matrices, conditional sum formulas, and conditional average formulas. It explains how to use names in an advanced way and improve formulas using names.
Finally, we will discuss in the Advanced Excel Skills 2 course how to use time and date formulas and their different uses, how to use If Statement in business solutions, how to deal with text formulas, how to separate text using formulas, and how to deal with dates, times, financial formulas, and many other advanced skills in using this program.
If you want to become an Excel expert, register with us in this free course from إدراك to gain advanced Excel skills and learn about many Excel tricks and the secrets of advanced Excel in business development until you reach the level of Excel mastery.
Who is this course for?
This course is suitable for anyone who has a basic knowledge of Excel and wants to develop their advanced Excel skills.
Course Requirements
It is essential to have a basic knowledge of Excel before starting this course.
What you will learn?
- You will learn about If Statements.
- You will learn about Lookup data search formulas.
- You will learn about Offset Function.
- You will learn about Indirect formula.
- You will learn about Circular References.
- You will learn about the comparison between Lookup data search formulas and Index formula.
- You will learn about matrix formulas through Index & Match.
- You will learn about some Excel tricks.
- You will learn about advanced Excel ideas such as how to improve formulas and develop reports.
- You will learn how to deal with 3D formulas.
- You will learn about using a dynamic cell range within formulas.
- You will learn about using financial formulas.
- You will learn about using functions to develop business.
- You will learn about using information retrieval formulas in business solutions.
- You will learn about counting formulas and matrix formulas.
- You will learn how to use names in an advanced way.
- You will learn about using time and date formulas.
- You will learn how to use If Statement in business solutions.
- You will learn how to deal with text formulas.
After completing this course you will be able to:
- Master advanced skills in using Excel.
- Solve business problems more effectively using Excel.
- Develop dynamic reports using Excel.
- Employ advanced Excel formulas in business solutions.
Course Costs
This course is free.
What is included?
The course includes a set of videos, exercises, and interactive activities.
Taught by
إدراك هي منصة إلكترونية عربية للمساقات الجماعية مفتوحة المصادر (MOOCs)، حيث تم تأسيسها بمبادرة من مؤسسة الملكة رانيا للتعليم والتنمية والتي تحرص على بذل كافة الجهود للمساهمة في وضع العالم العربي في مجال التربية والتعليم كونهما حجر الأساس لتطور وازدهار الشعوب. تهدف إدراك إلى توفير مساقات تعليمية عالية الجودة يقوم على تطوير محتوياتها نخب من خبراء وأكاديمي العالم العربي والعالم، بالإضافة إلى تقديم بعض المساقات العالمية المترجمة للغة العربية وذلك تماشيًا مع إيمان الملكة رانيا العبدالله بأهمية التعليم وما له من أثر في تحسين نوعية حياة المجتمعات والدول والأفراد على جميع المستويات.
Read more.