What are you going to learn from this course?

The list of learnings from this course is long, it starts from basic understanding of VBA, using data types, writing codes, performing complex calculations using VBA and automating rule based tasks in Excel. The course further helps you to understand different problems that you may face during coding along with their solutions. See below full topic list that we are going to cover in this course.

Course Requisites

Basic knowledge of
MS Excel

Install MS Office 2010
or above version

Ready to spend some time
to solve practice questions

Chapter 1

Introduction to VBA

In this chapter, we are going to understand what is VBA, why we need VBA. We will also cover different sections of VBA Editor and finally record our first VBA macro.

Chapter 2

Data types and Variables

In this chapter, we will learn different data types used in VBA, their usage and practical examples of declaring variables.

Chapter 3

Operators

In this chapter, we will learn how to perform basic calculations using VBA. We will also see practical examples in each section.

Chapter 4

Functions and Sub-Procedures

In this chapter, we will understand definition of Functions and Sub-Procedures. Also we will learn how to call a Function and Sub-Procedure

Chapter 5

MsgBox and InputBox

In this chapter, we will learn how to use common Input and Output methods in VBA. We will also see practical examples of each method.

Topic List

Chapter 6

Excel Object Model

In this chapter, we will learn how to read and write values in Excel Cells, Range, Worksheets, Workbooks and Application Objects.

Chapter 7

Conditional Statements

In this chapter, we will learn Conditional Statements commonly used in VBA. We will also see practical example of each statement.

Chapter 8

Loops

In this chapter, we will learn different types of Loops used in VBA. We will also see practical example of each type of Loop.

Chapter 9

Build-in-functions – String

In this chapter, we will learn different types of string build-in-functions used in VBA for string manipulation. We will also see practical example of each string function.