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
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.
. 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 discusses how to format tables, do 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. Thus, the specialization has covered all aspects of the Excel program for beginners and professionals alike.
Register for the Excel program specialization to learn Excel from scratch, and complete all courses to learn advanced skills in Excel such as Excel programming (VBA), how to develop tools to analyze data in Excel, advanced Excel tricks, and how to build a professional dashboard. Join this free course to teach Excel to beginners and professionals.
