فرصة

Excel Programming Using VBA Course

Learn the basics of Excel programming using VBA

  • English and Arabic
  • With Certificate

Tutor Name

Edraak
Excel Programming Using VBA Course

About the Course

Excel Programming Using VBA is a free course offered by إدراك and falls under the Excel Mastery specialization. This course aims to clarify the basics of Excel programming through Visual Basic for Applications. Learners in the course are required to have a good knowledge of Microsoft Excel and may also benefit from knowledge of pivot tables if possible.


The Excel Programming Using VBA course complements what was presented to learners during the Excel Functions and Tricks course. It is followed by the following courses: Excel Dashboards, Data Analysis Using Excel, Excel Spreadsheets, and Advanced Excel Skills (Microsoft Excel).


Learners will learn about Excel classes and the objects needed to create VBA scripts to automate the program. Participants in the course will create procedures and functions using this language and Excel objects. The Pivot Table object is used to create macros that add interactivity to the standard Pivot Table. Error correction and handling techniques are also reviewed.


During the Excel Programming Using VBA course, you will be able to learn the Visual Basic for Applications language, how to create functions through this language, how to deal with its work environment components, store the file with its presence, and the types of data inside it. You will also learn how to deal with macros through the quick toolbar and how to link two files using Excel VBA programming.


The topics that the Excel Programming Using VBA course focuses on include: VBA macros, translating logical code instructions, iteration statements, conditional and nested conditional statements in Excel VBA, navigation and selection techniques, and error handlers. In addition to For, Do, While, and LOOP loop statements necessary for programming in Excel, cell references within it, and how to deal with Range.


In addition, the Excel Programming Using VBA course explains how to use programming in business and report development, how to deal with Excel functions through VBA, follow command lines, how to create and edit code, call macros, use Excel VBA programming to develop data analysis tools, and how to deal with constant variables.


You will find that this course explains the concepts of programming in Excel using VBA in a simple way that is easy to understand. The course includes an immediate display window to test commands, data type errors, an input dialog box and message boxes, error tracking and handling, macros, how to add the developer ribbon, creating and naming objects, recording macros, and the work environment in this program.


Join us in this free course to learn Excel programming using VBA, the basics of Excel programming, how to deal with variables in the Excel VBA environment, add comments, how to work with the object model, and deal with Excel Objects, rows, columns, and cells through this language.

Who is this course for?

This course is suitable for anyone who has a basic knowledge of Excel and wants to learn Excel programming using VBA.

Course Requirements

It is essential to have a basic knowledge of Excel before starting this course.

What you will learn?

  • You will learn about the basics of Excel programming using VBA.
  • You will learn about Excel classes and the objects needed to create VBA scripts.
  • You will learn how to create procedures and functions using VBA.
  • You will learn about VBA macros.
  • You will learn about For, Do, While, and LOOP loop statements.
  • You will learn about cell references and how to deal with Range.
  • You will learn about using programming in business and report development.
  • You will learn how to deal with Excel functions through VBA.
  • You will learn how to create and edit code and call macros.
  • You will learn about using VBA programming to develop data analysis tools.
  • You will learn about dealing with constant variables.

After completing this course you will be able to:

  • Program Excel using VBA.
  • Automate Excel tasks using VBA.
  • Develop data analysis tools using VBA.
  • Improve your efficiency in using Excel.

Course Costs

This course is free.

What is included?

The course includes a set of videos, exercises, and interactive activities.

Taught by

Edraak

إدراك هي منصة إلكترونية عربية للمساقات الجماعية مفتوحة المصادر (MOOCs)، حيث تم تأسيسها بمبادرة من مؤسسة الملكة رانيا للتعليم والتنمية والتي تحرص على بذل كافة الجهود للمساهمة في وضع العالم العربي في مجال التربية والتعليم كونهما حجر الأساس لتطور وازدهار الشعوب. تهدف إدراك إلى توفير مساقات تعليمية عالية الجودة يقوم على تطوير محتوياتها نخب من خبراء وأكاديمي العالم العربي والعالم، بالإضافة إلى تقديم بعض المساقات العالمية المترجمة للغة العربية وذلك تماشيًا مع إيمان الملكة رانيا العبدالله بأهمية التعليم وما له من أثر في تحسين نوعية حياة المجتمعات والدول والأفراد على جميع المستويات.

Read more.