The Excel program specialization is a free course offered by Edraak, which is a specialization consisting of six courses: Excel functions and tricks, Excel programming using the language (VBA), the Excel dashboards, and analysis Data using Excel, spreadsheets in Excel, and advanced skills in Microsoft Excel.
The comprehensive Excel program specialization will help you learn Excel from scratch and develop your skills in it until you reach professionalism. The first course of specialization begins with teaching Excel for beginners, as it shows them how to create electronic tables, employ names in an advanced way, develop business using formulas, develop reports using matrix equations, employ (If Statement) and information retrieval equations in business solutions, and provide advanced Excel tricks.
In the second course of the Excel program specialization, we will learn about the dashboard in (VBA Environment), the features of the program (Excel) over other computer programs, how to translate code, how to call macros in Excel programming (VBA), and work with Object model, how to create and name objects, navigation and selection techniques, and how programming is used in business development and reporting.
The third course, specializing in Excel proficiency, explains the concept of the dashboard, conditional formatting and interactive controls, advanced Excel charts, tables and charts (Power Pivot), and key performance indicators and status and thresholds. Plus how to build a dashboard, how to build a professional dashboard, and use form controls to interact with it.
In the fourth course, we move from the specialization of Excel proficiency to explain how to analyze data using (Add-Ins), how to work an Excel Solver, how to import data from systems, validate and summarize data, and multiple regression. Besides, the course explains how to analyze Excel data, the analytics revolution, the pivot table, and the financial part.
The fifth course of the Excel program specialization provides advanced skills in Excel, such as how to develop solutions using (Text Functions), how to import data from different sources, merge them, and organize them for a visual presentation. In addition to explaining how to use electronic tables, formulas, mathematical functions, formatting, charts, proofing, graphing and printing in this program.
Finally, the sixth and final course of the Excel program specialization deals with how to format tables, make conditional formatting, build and develop reports, how to use ready-made report tools and advanced functions, in addition to how to deal with charts in Microsoft Excel. By doing so, the specialization has covered all aspects of the Excel program for beginners and professionals alike.
Check this course Facebook Social Media Marketing Professional Certificate
Enroll in the Excel program specialization to learn Excel from scratch, and complete all courses to familiarize yourself with advanced Excel skills such as Excel programming (VBA), how to develop tools for analyzing data in Excel, advanced Excel tricks, and how to build a professional dashboard. Join this free Excel course for beginners and professionals.
What you’ll learn
- Learn Excel from scratch and how to build and develop reports
- Advantages of Excel over other computer programs
- Learn Excel for beginners and develop solutions using (Text Functions)
- Excel Programming (VBA) in developing data analysis tools
- The concept of macros and how to call them in a programming language (VBA)
- Advanced Excel secrets and tricks in business development using Excel
- Advanced skills in Excel and how to use them in a practical way, such as functions and equations
- If Statement Employment and Information Retrieval Formulas in Business Solutions
- Analyze data in excel to gain insights to support decision making with (Add-Ins)
- Import, combine and organize data from different sources for your visual presentation
- How to build a professional dashboard and use the form controls to interact with it
- Choose, classify, print, move, and delete data, and review rows and columns in a worksheet
- The most important uses of Excel, such as creating electronic tables and graphs
The first course: electronic tables in Excel program
In this course, we will talk about how to use spreadsheets in the (Excel) program, in addition to formulas, mathematical functions, formatting, charts, auditing and printing in this program.
The second course: advanced skills in Excel (Excel)
This course provides learners with advanced basic skills in Microsoft Excel and explains how to make formatting, build and develop reports, use ready-made report tools and advanced functions, in addition to how to deal with charts in Microsoft Excel.
The third course: advanced skills in Excel 2
In this course, we will learn how to use names in an advanced way, develop businesses using formulas, and develop reports using matrix equations.
Fourth course: Programming Excel using VBA
This course covers an introduction to the (VBA Environment) dashboard and features of the Excel program in creating dashboards, how to call macros and variables, working with the object model, how to create and name objects, navigation and selection techniques.
Fifth course: Excel dashboards
This course explores the concept of a dashboard, conditional formatting, interactive controls, advanced Excel charts, tables and charts (Power Pivot), KPIs, status and thresholds, and building a dashboard.
Sixth course: data analysis using Excel
This course explains how to analyze data using Add-Ins, how to work with an Excel Solver, import data from systems, validate and summarize data, and multiple regression.
Edraak is a massive open online course (MOOC) platform, that is an initiative of the Queen Rania Foundation (QRF). QRF is determined to ensure that the Arab world is at the forefront of educational innovation. As such, QRF has capitalized on regional Arab talent to leverage technology developed by the Harvard-MIT consortium, edX, to create the first non-profit Arabic MOOC platform. The new MOOC platform will present the Arab world with unique and vital opportunities that can be part of a necessary revolution in education and learning.
First, the platform will broadcast the best Arab professors to the region, offering original Arabic courses – developed by QRF – to further enrich Arab education. Through its partnership with edX, the platform will also give Arab learners access in Arabic to courses taught and developed at top tier institutions like HarvardX, MITX, and UC BerkelyX. All courses are delivered at no cost to the learner.
Second, QRF envisions the use of the platform to showcase Arab role models by broadcasting short online courses by practitioners and professionals from a variety of fields spanning the arts and sciences.
Finally, QRF believes that the platform will enable the Arab world to take advantage of the international interest in regional affairs to tell its own story to the world. Arab university professors and regional experts can use the platform to give courses in English about the region and its history. This will serve to inform a global audience that is interested in the region’s development.
The Mikati Foundation
The Queen Rania Foundation is proud to recognize the Mikati Foundation as a sponsor of the Edraak platform and to acknowledge it’s commitment to increasing access to quality education for Arab learners.
The Mikati Foundation is an international non-profit founded by the brothers Taha A. Mikati & Najib A. Mikati. The Foundation works to improve the welfare and prospects of people in the developing world, particularly in the Arab World and Africa. Its projects encompass many of the determinants of the quality of life, including education, scientific research, access to community development services, as well as the cultural areas of traditional handicrafts, architecture, art, music & sports.
Arab Fund for Economic and Social Development
The Arab Fund for Economic and Social Development (the Arab Fund), based in the State of Kuwait, is an Arab regional financial institution focused on funding economic and social development by financing public and private investment projects and providing grants and expertise.
The Arab Fund’s activities are characterized by a number of important aspects that make it a model of cooperation and Arab economic integration, and a reflection of outstanding joint Arab action.