VBA Training – Beginner Level

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have been supporting organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to develop your employees' competencies in the IT field.

Excel is commonly perceived solely as a spreadsheet. However, it offers users many additional capabilities. Deepening user skills will turn the spreadsheet into an efficient tool for achieving various goals related to data integration and processing. Programming in VBA opens up particularly wide possibilities. The set of lessons and exercises will equip participants with knowledge that allows them to program Excel for personalized and sophisticated purposes.

This training is designed for individuals who are familiar with the Excel environment from the user interface perspective and would like to achieve more through the automation of daily tasks. Basic knowledge of programming will be helpful but is not essential to master the material.

You will understand and learn to use object-oriented programming in VBA. You will create your own macros and functions and design user forms. You will be able to program and invoke operations that you previously performed manually.

• VBA Object Model

  • Introduction to the Object Model

  • Object-Oriented Thinking (Properties and Methods)

  • Objects and Their Types

  • Excel User Interface

  • Data Types

  • Workbook, Worksheet, and Cell Protection Options

  • Naming Cells, Ranges, and Constants

• Introduction to VBA Language

  • VBA Editor Environment (Explorer, Properties, Code, Immediate, Modules)

  • Sub and Function Procedures

  • Objects, Collections, Hierarchy, Active Objects

  • Recording Macros (Relative and Absolute Mode)

  • Editing and Correcting Macro Code

• Basics of VBA Programming

  • Variables, Data Types, and Constants

  • Arrays, Object Variables

  • Built-in Functions

  • With … End With Structure

  • For Each … Next Structure

  • If … Then Structure

  • For … Next Loop

• Creating Sub Procedures

  • Declaring, Creating, and Executing Sub Procedures

  • Examples and Use of Selected Commands

  • Error Handling and Management

  • Examples and Exercises

• Creating Function Procedures

  • Declaring, Creating, and Executing Function Procedures

  • Function Examples (with one argument, multiple arguments, and no arguments)

  • Detecting and Removing Errors

  • Examples and Exercises

• Using UserForm Forms

  • InputBox

  • MsgBox

  • Controls

  • Creating Forms

  • Events and Forms

  • Form Examples

16 hours/2 days

• Certificate of Completion
• Monthly access to the training recording (for online format)
• Customization of the training program to client needs