CERTIFICATION IN VBA

VBA can help you save time by automating repetitive tasks, and can also help you achieve more consistent results by ensuring that tasks are carried out correctly every time.

DOWNLOAD COURSE BROCHURE

Program Objective

VBA, or Visual Basic for Applications, is a powerful programming language that allows you to automate tasks in Microsoft Office applications such as Excel, Word, and PowerPoint. VBA can help you save time by automating repetitive tasks, and can also help you achieve more consistent results by ensuring that tasks are carried out correctly every time. VBA is easy to learn for anyone who is already familiar with basic programming concepts, and there are many online resources available to help you get started. Some of the benefits of learning VBA include: 

If you are looking to save time and improve your workflows, learning VBA is a great place to start. Join CQS to help you get started, so there is no excuse not to give it a try!

Students' Benefits Learning VBA

COURSE CURRICULUM

Duration: 16 Hours + 50 Assignment Hours
Case Studies & Assignments: Workshop Study Material (Shared with all participant, Workshop Live Case Studies and Multiple sample databases with live case studies along with real-life situations.
Delivery Mode: Classroom Sessions & Online Sessions

MODULE - 1

Quick Recap of Microsoft Excel
Introduction to Developer Ribbon Tab
Introduction to VBA
What is VBA / Macro in Excel?

•Difference between VBA and Macros

Open Visual Basic Editor (VBE)

Project Explorer
•Immediate Window
•Run Button
•Reset Button

Project Explorer
•Immediate Window
•Run Button
•Reset Button

Recording Your First Macros in Excel
•Steps to record a Macro
•Relative References vs Absolute Reference in Macro Recording
•Ways to Run Macros
•Live Project: Dynamic Cell Selection (Using Excel Go to Feature)

MODULE - 2

  • Power BI Architecture
  • Power BI Introduction and Overview
  • Introduction Power BI Desktop and Power BI in Excel

•Declaring Procedures
•Procedures’ Scope (Public/Private Procedures)

•Working with Object Properties
•Working with Object Methods
•Live Case Study –Working with Comment Object

•Selecting, Copying, Pasting ranges

•Rules for Naming Variable
•Declaring & Initializing Variables
•VBA built-in data types
•Variable Scope and Working with Constant

MODULE - 3

•Use of Simple and Nested IF conditions
•IF with AND, OR & NOT
•Alternative of IF, a Select CASE statement

•For Next Loop (aka Counter Loop)
•For Each Loop
•Normal Do-Loop
•Do Until
•Do While Loop
•While Wend Loop

With-End with Constructs

•Use of GoTostatements

•Declaring arrays

•Static Arrays vs Dynamic Arrays

MODULE - 5

•Basics of UserForm
•Creating, displaying and unloading UserForms
•Understanding the settings of UserForm’sProperties

•List Box Control
•Scroll Bar Control
•Check Box

•Customizing control toolbox
•Filling Data into controls
•Adjusting UserFormcontrols

•Relevant UserFormEvents
•Control Events

MODULE - 6

•Recording & Modifying macro to create Pivot Table
•Writing codes to create Pivot Table Report
•Working with Pivot Table Fields and Items
•Updating Pivot Tables
•Generating multiple Pivot Table reports using VBA

Difference between embedded chart and chart sheets
•Understanding the Chart object model
•Creating an Excel Chart using VBA
•Changing Chart Type and Series Type
•Modifying Charts
•Creating Spark-line Chart in Excel using VBA
•Looping through all charts available in worksheet
•Adjusting Size and Aligning Chart Objects

•Recording a macro to sort the table
•Understanding and modifying the recorded macro
•Performing Simple sorting
•Dynamic and multilevel sorting
•Filter and display relevant information

MODULE - 7

•Introduction to Add-Ins
•Add-Inn vs COM Add-Ins
•How to Create Add-Inn
•Installing an Add-Ins

•Workbook Events (Open, Activate, Sheet Activate, Before Save, New Sheet, Deactivate etc.)
•Worksheet Events (Activate, Before Right Click, Calculate, Pivot Table Update etc.)

•VBA Shell function to launch other programs
•Creating a new Word Document

•Opening a Word Document
•Opening Outlook
•Launching PowerPoint

Looking For Some More Details? Let's Get In Touch On

Why choose CQS Training for VBA Training?

Start With A Free Demo Session

OUR STUDENTS ARE WORKING AT

100+ PLACEMENT PARTNERS

LEARNING OUTCOMES OF THE PROGRAM

Our expertise programs will make an integral turning for the trainees as it will sharpen their skills in VBA and make them glory in your professional era.

DOWNLOAD COURSE BROCHURE

Looking For Some More Details? Let's Get In Touch On

Follow us to get Regular Updates on New Trends in IT Sector