
VBA Excel Course
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
- 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 is Variables?
- Using Non-Declared Variables
- Variable Data Types
MESSAGEBOX AND INPUTBOX FUNCTIONS
- Customising Msgboxes and Inputbox
- Concatenating Boxes
- 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
- Using Loop Counters
- The Step Keyword
- Exiting from a For Next Loop
- Looping Through Items in a collection
FOR EACH LOOPS
- The For Each Next Statement
- Looping Over Cells
- Nesting for Each Loops
CREATING FUNCTIONS
- Writing a 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
- Worksheet Level Events
- Workbook Level Events
- Application.OnTime
- Working with Excel Range and Data
- Worksheet and Workbook Operations,
- Using Excel Functions in VBA
- 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 box
- Built in Dialog Boxes, Calendar
- Working with Spin Buttons, Images
- Reading data from Excel Sheets
- Writing data to Excel Sheet
- Project Study on GUI Pattern
MAIL FUNCTIONS – OUTLOOK
- Using Outlook Namespace
- Send automated mail
- Outlook Configurations, MAPI
- Filter Mails into Folders
- 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 automated forms
- Fill HTML Form using VBA
- 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
Course Info
- Start Course: 01/12/2020
- Duration: 15 Days
- Prerequisites: No
There are no reviews yet.