Excel Automation using VBA

Course Overview

Microsoft Excel VBA (Visual Basic for Applications) provides the ability for Excel users to automate any Excel function. Basically, Excel tasks that would usually require a considerable amount of effort and time to complete can be streamlined and accomplished in a single click of a button. Going through the training will help you build the confidence and trust to simplify your Excel experience, saving your time and money.

At the end of the training, participants will be able to:

  • ● Explain the concept of VBA
  •  
  • ● Discuss the working of VBA with Excel
  •  
  • ● Discuss the components of the programming language
  •  
  • ● Explain modularization of the programs
  •  
  • ● Explainarrays and error handling
  •  
  • ● Describe access database and retrieving data from access to Excel

Pre-requisite

Foundational knowledge of MS Office, especially Excel worksheets

Duration

2 days

Course Outline

  1. What is VBA?
  2. Introduction to Macro Recording
  3. Introduction to IDE
  1. Working of Visual Basic Editor
  2. Excel Object Model
  3. Working of Excel Macro Recorder
  4. Explain VBA Sub and Function procedures
  1. Essential VBA Language Elements
  2. Working of Range Objects
  3. Commonly used Code Snippets
  4. Programming Constructs in VBA
  1. What is Procedures?
  2. Advantages of Procedures
  3. Types of Procedures
  4. Object and Memory management
  1. Single Dimensional Array
  2. Multi-Dimensional Array
  3. Error Handling
  4. Access Specifier
  5. Code Reusability
  1. Steps to Create a new table and Database in MS Access
  2. Steps to load data into Access Database
  3. ADO Concept

Data Science & Big Data Analytics for Business Transformation

Reviews