Mastering Excel
Free course to learn Excel from scratch to mastery
- English and Arabic
- With Certificate
Tutor Name
EdraakInterested learners
About the Course
The Excel Mastery specialization is a free specialization offered by إدراك. It consists of six courses, namely: Excel Functions and Tricks, Excel Programming using VBA, Excel Dashboards, Data Analysis using Excel, Excel Spreadsheets, and Advanced Excel Skills (Microsoft Excel).
The comprehensive Excel Mastery specialization will help you learn Excel from scratch and develop your skills in it to reach mastery. The first course in the specialization begins by teaching Excel to beginners, explaining to them how to create spreadsheets, use names in an advanced way, develop business using formulas, develop reports using matrix formulas, use If Statements, and information retrieval formulas in business solutions, and provides advanced Excel tricks.
In the second course of the Excel Mastery specialization, we will learn about the dashboard in the VBA Environment, the advantages of Excel over other computer programs, how to translate code, how to call macros in Excel VBA programming, working with the object model, how to create and name objects, navigation and selection techniques, and how to use programming to develop business and reports.
The third course in the Excel Mastery specialization explains the concept of dashboards, conditional formatting and interactive controls, advanced Excel charts, Power Pivot tables and charts, key performance indicators, status, and thresholds. In addition to how to build dashboards, how to build a professional dashboard, and using form controls to interact with them.
In the fourth course of the Excel Mastery specialization, we will explain how to analyze data using Add-Ins, how Excel Solver works, how to import data from systems, verify and summarize data, and multiple regression. In addition, the course explains how to analyze data using Excel, the revolution of analytics, the pivot table, and the financial part.
The fifth course in the Excel Mastery specialization provides advanced Excel skills such as how to develop solutions using Text Functions, how to import data from different sources and merge and organize it for visual presentation. In addition to explaining how to use spreadsheets, formulas, mathematical functions, formatting, charts, auditing, graphing, and printing in this program.
Finally, the sixth and last course in the Excel Mastery specialization discusses how to format tables, create conditional formatting, build and develop reports, how to use ready-made reporting tools and advanced functions, in addition to how to deal with charts in Microsoft Excel. Thus, the specialization has covered all aspects of the Excel program for beginners and professionals alike.
Register for the Excel Mastery specialization to learn Excel from scratch, complete all the courses to learn about advanced Excel skills such as Excel VBA programming, how to develop tools to analyze data using Excel, advanced Excel tricks, and how to build a professional dashboard. Join this free course to teach Excel for beginners and professionals.
Taught by
إدراك هي منصة إلكترونية عربية للمساقات الجماعية مفتوحة المصادر (MOOCs)، حيث تم تأسيسها بمبادرة من مؤسسة الملكة رانيا للتعليم والتنمية والتي تحرص على بذل كافة الجهود للمساهمة في وضع العالم العربي في مجال التربية والتعليم كونهما حجر الأساس لتطور وازدهار الشعوب. تهدف إدراك إلى توفير مساقات تعليمية عالية الجودة يقوم على تطوير محتوياتها نخب من خبراء وأكاديمي العالم العربي والعالم، بالإضافة إلى تقديم بعض المساقات العالمية المترجمة للغة العربية وذلك تماشيًا مع إيمان الملكة رانيا العبدالله بأهمية التعليم وما له من أثر في تحسين نوعية حياة المجتمعات والدول والأفراد على جميع المستويات.
Read more.