La Courses

Log In

MIM1001 Basic Excel VBA Programming Training (2 Days)

Description

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.

  • 98% positive reviews (231)
  • 671 students

This program can be tailored to your specific business needs.

A little bit of personalization goes a long way. Ask us for a no-obligation Training Needs Analysis (TNA) so we can tailor this, or any other CSG program to meet your learning outcomes.

Contact Us
Objectives

At the end of the training, participants would be able 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

2 Days

  • 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
Module 1: Introduction to VBA
  • Introduction to VBA
  • Using Macro Recorder
  • Using Sub
  • Using Function
  • Using variable scopes
  • Creating readable code
  • Telling others about your code
  • Using variables
  • Using constants
  • Working with various data types
  • Using operators
  • Selection statements
  • Looping statements
  • Flow control
  • Discover various types of bugs
  • How to prevent bugs?
  • How to track down bugs?
  • Using Locals window
  • Using Watch window
  • Creating forms
  • Using form controls
  • Creating connection between forms & modules
  • Input validation
  • Form events
  • 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.

Choose a Training Partner that Stays Invested.

CSG is here for you before during and post trainings. Contact Us for customized training solutions or Explore our Programs.

Read our FAQs

Tell Us What You Need, We’ll Make it Happen

Welcome Back

Sign In

New here? Create an account.