Macros | Sikhiya

Macros(VBA) Course Description

  • 100% Practical Oriented Training
  • 30 Hours Duration
  • Weekdays / Weekends

Download brochure

Learn More About The Program

Classroom Training

Online Instructor-Led Training

Corporate Training

What is this course about?

VBA ( Macros) enables the professionals to gain proficiency in handling basic Programming command and tools. This certification training helps the users to enhance their understanding of the basic to Advanced level of macro program for organizing, visualizing, calculating and Segregation/ Consolidation of  data in MS Excel 2013. It is ideal for those who are looking to improve their job prospects by adopting Advanced Macros fundamental skills and knowledge.

During this course you will build a foundation of working with  VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

Real-time Scenario

The real time updated scenarios will be provided at the end of each topic. It helps you to apply the concepts taught during the class in Real-Time work.

Placement Assurance

Get placed at leading Analytics firms with interview prep and opportunities

Time Flexibility to Learn

We offer flexible batch timings for Students and IT Professionals to choose to join our weekday, Weekend.

100% Practical Oriented

Our state of the art practical oriented training helps candidate to learn the practical approach of a content.

Course Details

Introduction to Macros
  • Introduction to Macros
  • Introduction to VBA
  • Importance of Developer Tab and VB window
  • Path to get into VB window
  • Introduction to different windows in VB
  • 1. Project Explorer
  • 2. Property Window
  • 3. Code Window
  • Types of Code windows
  • 1. Sheet Code Window
  • 2. Workbook Code Window
  • 3. Module Code Window
  • 4. Userform Code Window
  • Enabling the Macros to run the program
  • Saving Macro Workbook
Introduction to Object Model
  • Introduction to object
  • Introduction to property and methods
  • Importance of arguments
  • Object Browser
  • Procedures
  • 1. Sub Procedure
  • 2. Function Procedure
  • Coding Structure
  • Introduction to Cell Reference
  • Usage of different property and methods with cells
  • Introduction to sheet reference
  • Usage of different property and methods with sheets
  • Assigning Comments & BreakPoint
Declaration of Variables
  • Introduction to workbook reference
  • Usage of different property and methods with workbook
  • Introduction of variable declaration
  • Importance of different data types
  • Different levels of declaration of variables
  • Different ways of declaration of variables
Loop Statements
  • Introduction to Message Box
  • Introduction to Input Box
  • Introduction to different Loop statements
  • 1.For Next
  • a. Forward Loop
  • b. Reverse Loop
  • c. Step Value
  • 2. Multi loop
Decision Making Statements
  • Introduction to conditional statement
  • 1. IF , AND , OR
  • 2. Case Statement
  • Activity on different conditional statement
  • Activity on different conditional statement with LOOP
  • Select case decision structure
  • Activity on select case structure
Go To Command
  • Introduction to GOTO label command
  • Activity on GOTO label command
Loops
  • Introduction to TO_DOLOOP
  • DO_WHILE LOOP
  • Activity on DO_WHILE LOOP
  • DO_UNTIL LOOP
  • Activity on DO_UNTIL LOOP
  • Introduction to FOR EACH NEXT LOOP
  • Usage of SET statement
  • Usage of WITH Command
  • Activity on FOR EACH NEXT LOOP
Data Segregation
  • Segregation of data in static way
  • Introduction to Last row number and last column number
  • Segregation of data in dynamic way
  • Consolidation of Data in dynamic way
VBA & WorkSheetfunction
  • Introduction VBA & WorksheetFunctions
  • Error Handling Concepts.
User Defined Functions
  • Introduction to USER DEFINED function
  • Activities on USER DEFINED function
  • UDF on extracting numbers
  • UDF on extracting data
Recording of Macros
  • Record Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a short key to run Macro
  • Running a Macro with a short key
  • Assigning a Macro to a menu or tool bar
  • Editing a Macro with VB
User Forms
  • Designing and Creating Forms
  • Working with controls
  • Creating custom dialog boxes
  • User forms properties, Methods and Events
Activities
  • Connection with Other Applications
  • 1.Using Early Binding
  • 2.Using Late Binding
  • Connection with
  • 1. Access Application
  • 2. Outlook Application
  • 3. Internet Explorer
  • Real time activities