VBA with Microsoft Excel

نظرة عامة

أتمت Excel بـ VBA خلال يوم واحد. تسجّل وحدات الماكرو، وتكتب شيفرة VBA مباشرة، وتحلّ المشكلات بالشيفرة، وتحسّن جودتها.

ما ستتعلّمه

المحتوى التقني أدناه معروضٌ باللغة الإنجليزية كما ورد في منهاج الدورة، حفاظاً على دقّة المصطلحات.

• Identify general components of VBA and their appropriate use in solving business solutions.
• Record VBA macros to automate repetitive tasks.
• Write VBA code to create VBA subroutines and functions.
• Use various programming elements to solve problems through code, including variables,objects, conditional statements, and loops.
• Eliminate, avoid, or handle errors in VBA code, and optimize its performance.

المنهاج

لمن هذه الدورة

مستخدمو Excel المستعدّون للأتمتة.

قبل أن تبدأ

• To ensure your success in this course, you should be an experienced Excel user who is comfortable creating and working with Excel workbooks, including tasks such as entering worksheet formulas, using absolute and relative addressing, formatting cells, and creating pivot tables and charts. This level of skill could be acquired by taking the Microsoft Excel for Office 365 (Desktop or Online) courses, Parts 1, 2, and 3.