Excel Macro Training Course is delivered in classroom batches held on weekends.
Audience:
Course Objectives
Course Outline:
Getting Started
- Create a Macro with a Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize Quick Access Toolbars, Hotkeys
- Working with Macro Security
- Introducing Visual Basic for Applications
- Understanding the Development Environment
Working with Procedures and Functions
- Understanding Modules
- Creating a Standard Module
- Understanding Procedures
- Creating a Sub Procedure
- Calling Procedures
- Using the Immediate Window to Call Procedures
- Creating a Function Procedure
- Naming Procedures
- Working with the Code Editor
Understanding Objects
- Understanding Objects
- Navigating the Excel Object Hierarchy
- Understanding Collections
- Using the Object Browser
- Working with Properties
- Using the With Statement
- Working with Methods
- Creating an Event Procedure
Using Expressions, Variables & Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If…End If Decision Structures
- Using the Select Case…End Select Structure
- Using the Do…Loop Structure
- Using the For…To…Next Structure
- Using the For Each…Next Structure
- Guidelines for use of Control-of-Flow Structure
Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with the Label Control
- Working with the Text Box Control
- Working with the Command Button Control
- Working with the Combo Box Control
- Working with the Frame Control
- Working with Option Button Controls
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
Debugging Code
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run Mode
- Determining the Value of Expressions
Handling Errors
- Understanding Error Handling
- Understanding VBA’s Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Certification Details®
Course Name |
Exam |
No of (days) |
Oracle SQL |
SQL Certification Exam 12c or 11g |
1 |
Total |
1 |
Course/Exam Name |
Duration |
Fees |
SQL Course |
24 hours or 12 classes |
Rs. 5,900 |
SQL Certification Exam |
-- |
Rs.10,900 |
Total |
Rs. 16,800 |