Programming with Excel VBA

Automate Calculations in Excel

4.9(91)3h 54m14 lectures2 sections

What you'll learn

  • Learn the basics of programming with Excel VBA.
  • Understand tools and events within Excel.
  • Create macros to simplify processes.
  • Understand algorithms to improve efficiency.
  • Apply codes to automate calculations.
  • Manage repetitive tasks effectively.

About this course

The Excel VBA programming course is ideal for users looking to enhance their Excel skills and learn how to automate various tasks within Excel using Visual Basic for Applications (VBA). This course covers many important topics, such as the fundamentals of Visual Basic, programming within Excel, creating and editing macros and custom functions, designing and modifying forms, controlling buttons and fields, as well as creating menus and dashboards. With VBA techniques, you will also handle data in advanced ways, including searching, sorting, filtering, and generating custom reports and charts.

Expected outcomes

  • Automate processes within Excel using VBA.
  • Create custom software solutions to meet business needs.
  • Enhance productivity by writing code and executing algorithms.
  • Develop programming skills to solve problems and increase efficiency.

تقييمات المتدربين

التقييمات هنا من المتدربين الذين اشتروا الدورة وأكملوا50٪من المحتوى على الأقل — لا توجد تقييمات من شخص لم يطلع على المحتوى.
4.9
★★★★★
91 تقييم
5★
79
4★
11
3★
1
2★
0
1★
0
    كن جزءا من تقييمات هذه الدورة

    كل تقييم هنا يساعد متدربا جديدا على الاختيار — شاركنا تجربتك بعد إكمال الدورة.

    Course content

    1

    Programming with Excel VBA

    12 lectures
    1. Introduction and Course Overview3:14
    2. Icebreaker and Writing the First Program18:38
    3. Events and Tools in VBA15:55
    4. Understanding Tools and Their Properties20:35
    5. Excel Objects and Conditional Statements24:25
    6. Variables and Message Box Programming17:44
    7. Adding Tools to Excel Worksheets20:51
    8. How VBA Handles Excel Cells19:29
    9. Understanding Algorithms and Building a Code Writing Plan27:32
    10. Understanding the Concept of Iterative Loops23:25
    11. Best Supplier Identification Program22:57
    12. Macro Units19:38
    2

    Attachments

    2 attachments
    1. Uploading the Work File
    2. Downloading Applications

    Instructor

    Dr. Eng. Mohamed Al-Khodour

    Dr. Eng. Mohamed Al-Khodour

    PhD in Communication Engineering with several published research papers in peer-reviewed journals. Lecturer and trainer in computer science.
    2,214 students5 courses