Logo Loading

MIM1001 – Basic Excel VBA Programming Training (2 Days)

OVERVIEW

This course is designed for those wishing to learn VBA programming as their first programming language without any prior knowledge in programming. The emphasis is on VBA language structure, common programming strategies, and several hands-on exercises. Towards the end of the course, participants will be introduced into Excel VBA programming.

Objectives

Upon completion of this program, the participants are expected to:

  • Write powerful Excel VBA code to automate processes
  • Understand, test and debug VBA errors
  • Fun and effective lessons including ‘real world’ Excel VBA projects to complete
  • Identify real world situations where you can apply your new VBA skills

Duration

  • Typically spans 2 days (9am to 5pm).
  • Nonetheless, we can customize both the program’s duration and schedule to cater to unique client requirements (e.g., compact 1-day workshops or extended sessions beyond 3 days).

Target Audience

  • Excel users who want to automate tasks and processes in Excel
  • Business professionals who work extensively with Excel and want to enhance their productivity
  • Data analysts and report builders who want to leverage VBA programming for advanced data manipulation and analysis
  • IT professionals who want to develop their programming skills specifically for Excel
  • Individuals seeking to expand their Excel knowledge and learn basic VBA programming for Excel automation

PROGRAM OUTLINE

Module 2: Scripting Strategies

  • Using Macro Recorder
  • Using Sub
  • Using Function
  • Using variable scopes
  • Creating readable code
  • Telling others about your code

Module 3: Working with Variables

  • Using variables
  • Using constants
  • Working with various data types
  • Using operators

Module 4: Programming Strategies

  • Selection statements
    • Using If…Then statement
    • Using If…Then…Else statement
    • Using If…Then…ElseIf…Else statement
    • Using Select Case…Case Else…End Select statement

 

  • Looping statements o Using Do While…Loop statement
    • Using Do…Loop While statement
    • Using Do Until…Loop statement
    • Using Do…Loop Until statement
    • Using For…Next statement
    • Using For Each…Next statement

 

  • Flow control
    • Using GoTo statement

Module 5: Error Handling

  • Discover various types of bugs
  • How to prevent bugs?
  • How to track down bugs?
    • Using Locals window
    • Using Watch window

Module 6: User Interactions

  • Creating forms
  • Using form controls
  • Creating connection between forms & modules
  • Input validation
  • Form events

Module 7: VBA Programming In Excel

  • Working with Excel-related objects
  • Accessing & using Excel objects
  • Modify cell contents
  • Creating custom functions

PROGRAM METHODOLOGY

  • Hands-on Activities: Practical exercises to reinforce theoretical concepts.
  • Group Discussions: Opportunities for peer-to-peer learning and exchange of ideas.
  • Role Plays: Simulations of realistic situations to build practical skills.
  • Feedback Sessions: Reviews and reflections to encourage improvement.
  • Problem-solving Exercises: Develop critical thinking and decision-making skills.
  • Experiential Learning: Learning by doing, promoting active involvement.
  • Interactive Lectures: Engaging presentations by experts in the field.
  • Case Studies: Real-world scenarios for learners to apply their knowledge.
  • Quizzes & Tests: Regular assessments to track learning progress.

CONTACT US

Our Experts Are Here to Help