VBA Course Content
Introduction and Basics of VBA
Advantage of VBA
Recording and executing macros
Overview of VBA Editor, Project Explorer, Properties Windows
What are Objects, Methods, Properties ?
Overview and Display of Messagebox and Inputbox
Basics and Scope of Constants and Variables
Introduction and Basics of Data types, Storage and Data Size
Detailed discussion on If…Then…Else, Elseif Statements
Using Select Case Statements
Simple Arithmetic Operators (* / % ^ - +)
Relational or Comparison Operators
Concatenate Operators (+ , &)
Logical Operators (And, OR, NOT)
Sub Procedure vs Function Procedure
Using Functions in Formulas
With…End With Statements
Linking with Cells, Range, Worksheets & Workbooks
Open, Close & Save Workooks
Import data from multiple Rages and Worksheets using VBA
Classroom Project 1
Select, Add, Rename Workbooks and Worksheets
File Handling – Opening, Reading & Writing to files from VBA
Protect / Unprotect Workbooks and Worksheets
Consolidate Multiple Workbooks into one using VBA
Overview of Userforms and its advantages
Working With Command Buttons, List Box, Combo Box, Option Buttons, Check Boxes, Text Boxes, Labels
Debugging and Error Handling Techniques in VBA
Classroom Project 2
Reach out to us if you are looking for Corporate Training to Build The Next Generation Analytical Workforce with an in-depth understanding of Exploratory Data Analysis , Data Visualisation, Data Analytics , AI First , Machine Learning & Deep Learning Training & Consulting helping them to take Data Informed Decision at each stage of the business.
We understand that At the present times , the Entire Industry is in a Tranformation stage with the Softwares being rebuilt with Artificial Intelligence Capabilities .
We need SMART WORKFORCE for the SMART SOFTWARES to reap the maximum return .
Whatsapp at +91-9953805788 or email at - firstname.lastname@example.org if you would like to know more .