Excel VBA Macros Course

inteligeneit@gmail.com Tiwary
Last Update September 7, 2022
0 already enrolled

About This Course

Excel VBA programming can seem baffling, especially when you don’t fully understand the code you are asked to write. Learn to write Excel VBA macros, from scratch, to automate Microsoft Excel tasks and operations.

This course is aimed particularly at Excel users without much programming experience, who struggle to remember the syntax and structure of the VBA (Visual Basic for Applications) programming language.

During the course, we will use a style of programming that emphasizes the significance of each line of code that you write. This means that when you revisit the code, the meaning of each line is apparent from the syntax, rather than becoming more and more unfamiliar. The course also demonstrates how to get the maximum benefit from IntelliSense, Microsoft’s code completion feature.

Whether you are looking to enhance your career prospects by adding Excel VBA to your C.V., saving your company money, or increasing your productivity, this course will provide you with all the knowledge you need to get started.

You can download all of the materials used in the lectures so that you can follow along. (Please, remember to unzip the downloaded files.)

INTRODUCTION TO VBA

  • What Is VBA?
  • What Can You Do with VBA?
  • VBA IDE
  • Recording the Macro

VISUAL BASIC EDITOR

  • The Project Explorer
  • The Properties Window
  • The VB editor windows
  • Creating and Removing Modules
  • Renaming Modules

VARIABLES IN VBA

  • What are Variables?
  • Using Non-Declared Variables
  • Variable Data Types

MESSAGEBOX AND INPUTBOX FUNCTIONS

  • Customizing Msgboxes and Inputbox
  • Concatenating Boxe
  • Using Multiple Lines
  • Reading Cell Values into Messages
  • Asking Questions with Msgboxes / Inputbox

VBA WITH STATEMENTS

  • Writing a Simple With Statement
  • Creating More Complex References
  • Referencing other Objects

IF STATEMENTS

Simple If Statements

  • Single line Ifs
  • The Elseif Statement
  • Nesting Ifs
  • Combining Logical Tests

LOOPING IN VBA

  • Introduction to Loops and its Types
  • The Basic Do Loop Statement
  • Exiting from a Loop
  • Advanced Loop Examples

FOR NEXT LOOPS

  • 1 Using Loop Counters
  • The Step Keyword
  • Exiting from a For Next Loop
  • Looping Through Items in a collection

FOR EACH LOOP

  • The For Each Next Statement
  • Looping Over Cells
  • Nesting for Each Loop

CREATING FUNCTIONS

  • Writing Simple Functions
  • Calling Functions
  • Creating Parameters
  • Optional Parameters
  • Rewriting Code to Use Functions

ARRAYS IN VBA

  • Array Declaration
  • Assigning Values to an Array
  • Types of Array
  • One dimensional, Two dimensional, and multi-dimensional arrays

WORKING WITH SHEETS

  • Sheets and Types of Sheets
  • Manipulating Sheets:
  • Inserting and Deleting
  • Copying and Moving
  • Hiding and Unhiding

WORKING WITH WORKBOOKS

  • Referring to workbooks
  • Opening and Creating workbooks
  • Saving Workbooks

ERRORS HANDLING AND DEBUGGING

  • Types of Error:
  • Syntax Errors
  • Compile Errors
  • Runtime Errors

WORKING ON ACTIONS / EVENTS

1. Worksheet Level Events
2. Workbook Level Events
3. Application.OnTime
4. Working with Excel Range and Data
5. Worksheet and Workbook Operations,
6. Using Excel Functions in VBA
7. Volatile Functions

FILTER AND REPORTING

  • AutoFilter
  • Filter Object and Criteria(s)
  • Advanced Filters
  • Creating a PivotTable Report
  • PivotCaches and Naming
  • Adding PivotFields
  • Adding Fields for Calculation
  • Creating and Editing Charts

FORM CONTROLS

Understanding User forms and References
Combo box, Radio Button, Check the box
Built-in Dialog Boxes, Calendar
Working with Spin Buttons, Images
Reading data from Excel Sheets
Writing data on Excel Sheet
Project Study on GUI Pattern

MAIL FUNCTIONS – OUTLOOK

  • Using Outlook Namespace
  • Send automated mail
  • Outlook Configurations, MAPI
  • Creating Contact
  • Create and Schedule Task
  • Export Mails Attachments in a specific location

WORKING WITH DATABASES

  • Introduction ADO
  • Various Connection Drivers
  • Database Connection and Recordset Object
  • Excel – Access Connectivity – Select, Retrieve, Insert Data Operations
  • Excel –SQL Connectivity – Select, Retrieve, Insert Data Operations

WORKING WITH WEB APIS

  •                                                         Form submissions, ROBOTs programming
  • Fill out automated forms
  • Fill HTML Form using VBA
  • Robots programming
  • Interview Preparation
  • Training Certification

Learning Objectives

By the end of this course, you will be confidently writing VBA macros which automate procedures in Microsoft Excel.
You will fully understand the purpose and syntax of each line of code that you write.
You will not simply be entering lines of code because you have been told they will produce a certain result.
You will gain a solid understanding of both the VBA and Excel object models which underly VBA programming.

Requirements

  • Experienced Excel users who are new to Excel VBA programming.

Target Audience

  • Anyone wishing to learn professional Excel VBA programming techniques.

Your Instructors

inteligeneit@gmail.com Tiwary

0/5
6 Courses
0 Reviews
0 Students
See more

9,999.0011,999.00

17% off
Level
Intermediate
Subject

Related Courses

-6%
Data Analysis Course
Data Analytics Course

45,000.0048,000.00

-20%
Python +Django Framework Training
Python +Django Framework Training

19,999.0024,999.00

-25%
data science
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar
Compare

Don't have an account yet? Sign up for free