Mastering Excel

Description

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.

Enroll Now Teaching English To Young Learners – US Embassy

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.

Apply for ENGLISH FOR BUSINESS AND ENTREPRENEURSHIP – US Embassy

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.

Check: Harvard University Free Online Courses

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

Check: Stanford University Free Online Courses

Syllabus

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 course of Fundamentals of Accounting Specialization by the University of Illinois

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.

Course: Introduction to Finance and Accounting Specialization by University of Pennsylvania

About Edraak

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.

Patrons

English Courses Offered by US Embassy