the description
The Excel specialization is a free specialization offered by Edraak, and it is a specialization consisting of six courses: Excel functions and tricks, Excel programming using the VBA language, 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 to reach professionalism. The first course of the specialization begins with teaching Excel to beginners, as it shows them how to create electronic tables, use names in an advanced manner, develop business using equations, develop reports using matrix equations, use (If Statement) and information retrieval equations in business solutions, and presents advanced Excel tricks.
In the second course of the Excel program 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 programming (VBA), and working with… The object model, how to create and name objects, navigation and selection techniques, and how to employ programming in business development and reports.
As for the third course of the Excel program specialization, it explains the concept of the dashboard, conditional formatting and interactive controls, advanced Excel charts, Power Pivot tables and charts, key performance indicators, status and their thresholds. In addition to 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 specialty of mastering the Excel program to explaining how to analyze data using Add-Ins, how the Excel Solver works, how to import data from systems, verify the validity and summarize data, and multiple regression. In addition, the course explains how to analyze data in Excel, 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) and how to import data from different sources, combine and organize it for visual presentation.
What will you 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 the 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
Employing If Statement and information retrieval equations in business solutions
