VBA Excel Course

Lecturer
admin
Category
0 Reviews

Course Description

VBA (Visual Basic Application) Training helps the Data Analysts, MIS Executives, Data Mining sectors & even in the Work Automation office. We train the employees on how to work on an Excel Workbook using VBA and enable one to make Dashboards.

Pre-Course Requirements

  • Basic Knowledge of Computer
  • Personal Laptop (if possible)
  • Positive Attitude
  • Know-How to serve on the internet
  • Self Learning Skill
  • Willing to learn Attitude

Course Objective:-

  • Introduction to VBA
  • Visual basic editor
  • Variables in VBA
  • Messagebox and input box functions
  • VBA with statements
  • If statements
  • Looping in VBA
  • For next loops
  • For each loop
  • Creating functions
  • Arrays in VBA
  • Working with sheets
  • Working with workbooks
  • Errors handling and debugging
  • Working on actions/events
  • Filter and reporting
  • Form controls
  • Mail functions – outlook
  • Working with databases
  • Working with web APIs
  • Interview preparation
  • Training certification

Course Content Covered

INTRODUCTION TO VBA

  1. What Is VBA?
  2. What Can You Do with VBA?
  3. VBA IDE
  4. Recording the Macro

VISUAL BASIC EDITOR

  1. The Project Explorer
  2. The Properties Window
  3. The VB editor windows
  4. Creating and Removing Modules
  5. Renaming Modules

VARIABLES IN VBA

  1. What is Variables?
  2. Using Non-Declared Variables
  3. Variable Data Types

MESSAGEBOX AND INPUTBOX FUNCTIONS

  1. Customising Msgboxes and Inputbox
  2. Concatenating Boxes
  3. Using Multiple Lines
  4. Reading Cell Values into Messages
  5. Asking Questions with Msgboxes / Inputbox

VBA WITH STATEMENTS

  1. Writing a Simple With Statement
  2. Creating More Complex References
  3. Referencing other Objects

IF STATEMENTS

  1. Simple If Statements
  2. Single line Ifs
  3. The Elseif Statement
  4. Nesting Ifs
  5. Combining Logical Tests

LOOPING IN VBA

  1. Introduction to Loops and its Types
  2. The Basic Do Loop Statement
  3. Exiting from a Loop
  4. Advanced Loop Examples

FOR NEXT LOOPS

  1. Using Loop Counters
  2. The Step Keyword
  3. Exiting from a For Next Loop
  4. Looping Through Items in a collection

FOR EACH LOOPS

  1. The For Each Next Statement
  2. Looping Over Cells
  3. Nesting for Each Loops

CREATING FUNCTIONS

  1. Writing a Simple Functions
  2. Calling Functions
  3. Creating Parameters
  4. Optional Parameters
  5. Rewriting Code to use Functions

ARRAYS IN VBA

  1. Array Declaration
  2. Assigning Values to an Array
  3. Types of Array
  4. One dimensional, Two dimensional and multi dimensional arrays

WORKING WITH SHEETS

  1. Sheets and Types of Sheets
  2. Manipulating Sheets:
  3. Inserting and Deleting
  4. Copying and Moving
  5. Hiding and Unhiding

WORKING WITH WORKBOOKS

  1. Referring to workbooks
  2. Opening and Creating workbooks
  3. Saving Workbooks

ERRORS HANDLING AND DEBUGGING

  1. Types of Error:
  2. Syntax Errors
  3. Compile Errors
  4. 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

  1. AutoFilter
  2. Filter Object and Criteria(s)
  3. Advanced Filters
  4. Creating a PivotTable Report
  5. PivotCaches and Naming
  6. Adding PivotFields
  7. Adding Fields for Calculation
  8. Creating and Editing Charts

FORM CONTROLS

  1. Understanding User forms and References
  2. Combo box, Radio Button, Check box
  3. Built in Dialog Boxes, Calendar
  4. Working with Spin Buttons, Images
  5. Reading data from Excel Sheets
  6. Writing data to Excel Sheet
  7. Project Study on GUI Pattern

MAIL FUNCTIONS – OUTLOOK

  1. Using Outlook Namespace
  2. Send automated mail
  3. Outlook Configurations, MAPI
  4. Filter Mails into Folders
  5. Creating Contact
  6. Create and Schedule Task
  7. Export Mails Attachments in a specific location

WORKING WITH DATABASES

  1. Introduction ADO
  2. Various Connection Drivers
  3. Database Connection and Recordset Object
  4. Excel – Access Connectivity – Select, Retrieve, Insert Data Operations
  5. Excel –SQL Connectivity – Select, Retrieve, Insert Data Operations

WORKING WITH WEB APIS

  1. Form submissions, ROBOTs programming
  2. Fill automated forms
  3. Fill HTML Form using VBA
  4. Robots programming

Interview Preparation

Training Certification

What Will You Achieve

  • Improve the chances of success in getting a job
  • This practice techniques will enable you to tackle interviews question for jobs
  • This course will help to identify or understand the requirements of the recruiters
  • Help you to do research work
  • Help you to identify what questions you may be asked at the interview
  • This course will help you to understand how to approach answering different types of interview questions
  • These practice techniques will help you to understand your strengths, skills, and key selling points to tackle interviews with confidence
  • Help you to understand and tackle different types of interviews, from telephone and video interviews to non-standard interviews, and how to tackle them

Reviews

0
0 Ratings
stars 5
0%
0
stars 4
0%
0
stars 3
0%
0
stars 2
0%
0
stars 1
0%
0

There are no reviews yet.

Leave a Review

Be the first to review “VBA Excel Course”