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.
- Proficient in working on Visual Basic & Marcos
- Having good command on the keyboard
- Skilled in number and different formatting types
- Capable of handling the large data
- Design your own User Defined Functions in easy steps using VBA
- Plotting various charts & tables using Excel & VBA
- Creating various reports using different features & functions
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:Â
- VBA can save you time by automating tasks that would otherwise be carried out manually.
- VBA can improve the consistency of your work by ensuring that tasks are carried out correctly every time.
- VBA can help you to better understand how Office applications work and can provide a foundation for learning more advanced programming languages.
- VBA is easy to learn for anyone who is already familiar with basic programming concepts.
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
- Participants get 500+ real-life scenarios and Complimentary & Exclusive 1 Month Post Workshop Support
- Key focus on Hands-on, practical, and projects
- After every class, you will get assignments & session recordings
- Flexibility to re-attend the Live Sessions
- Almost every industry is hiring employees with 1 or 2 years of experience in VBA (Marcos) than just only MS Excel, You will create a lot of opportunities for yourself after completing this course
- Companies are offering an average salary for a Data Analyst with VBA (Marco) skill is Rs. 4 lacs / Year according to Payscale
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)
•Object Hierarchy (Objects and Collections)
•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 - 4
•IIf, UCase, LCase, Date, StrReverse, Split, Remove Vowels, InStr, Date
•UDF with No, One, & Multiple arguments
•UDF to Sum Each Digit in a Cell
•UDF to extract only numbers from alphanumeric cell
•Function with an Array argument
•Trapping Errors (Ingoing Error or Jumping to specific section)
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
Why choose CQS Training for VBA Training?
- Unlimited access to CQS 250+ courses
- Industry Relevant Live Practical Training
- Specializations as per choice and Industry Relevant Certifications
- Ongoing Placement assistance every quarter
- Phygital Mode of Learning (Online + Offline)
- Strong Alumni Network of 30,000+
- 100+ Hiring Partners (Placed students in thousands of MNC over the years)
- Tie up with Tally Education, NASSCOM, Kanan International, CompTIA, EC Council, TSW (Times Group), NIELITS, etc
- Events conduct annually- Freedom scholarships, Chess competition, Best Brain Awards, Blood donation camp, CATQE, GET, NGO and CSR activities
- Most Intensive Course Content
- 105+ Qualified and Industry Expert Mentors
- Paid Internship Program
- 100% Placement Assistance. (*T & C Apply)
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.
- Proficient in working on Visual Basic & Marcos
- Having good command on the keyboard
- Skilled in number and different formatting types
- Capable of handling the large data
- Design your own User Defined Functions in easy steps using VBA
- Plotting various charts & tables using Excel & VBA
- Creating various reports using different features & functions
- Having strong knowledge of Advanced Formulas
- Able to analyze any data with Excel VBA
- Ability to create Good Looking and World Class Dashboards
- Recording and Cleaning Macros Easily