Excel Macro Course

 

Training & Certification

Excel Macro Training Course

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

If you have more Comments or questions then you are welcome to our center.


Accordions

The commonly asked questions pertaining to PMP Certification exam are -

There are no mandatory Prerequisites for taking the ITIL Certification exam - however the following helps to facilitate the process

  • Atleast one year of work experience in IT Service Management is recommended

    OR

    Understanding of the processes relating IT Service Management is helpful for successful certification

  • Yes, we recommend all participants to do our training as that will help them to assimilate all aspects of this domain and make their certification more meaningful - what is the use of certification if you cannot explain basic concepts.

  • We will provide you access to an Online Question Bank which has 4 mock exams. As you start with the first mock exam and move towards the other ones then you will find your score improving.

  • One can take either the online or the paper mode of exam. If you opt for online then we will provide you with the exam voucher and book your slot for the online proctored exam and you can appear for the exam. If however, you want to take the paper exam then the same will be held on the second day of the exam.

  • The exam will be conducted at our center under examination conditions in the presence of an invigilator.

Chat with Expert
CONTACT US +91-8420594969 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things to Love!

  • Experienced Training Partner
  • Certified /Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customize Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Send us Your Query