Microsoft Excel Macro Training

STAR 5 Star Rating 485 Learners 

Course Content



Call us

Microsoft Excel training at Credo Systemz will help you to develop your excel skills from which you can easily create charts, invoices, formulas, worksheets and impress your team.

Learn Excel from best Microsoft Excel Training Institute in Chennai either you are a newbie or looking for an advanced knowledge, we will be guiding to towards excellence

About Excel Macro Course

What is Microsoft Excel Macro?

Microsoft Excel Macro is an application that helps to create dynamic spreadsheets. An Excel Macro is recording a set of Programming instructions. Marcos in Excel is written in Excel Visual Basic for Application.

Key Features

Training from
Industrial Experts


100% Placement

Expert Support

24 x 7
Expert Support

for Course



Section 1: Creating Record Macros

  • Recording a Macro
  • Running a Macro
  • Running a Macro from the Macros Dialog Box
  • Creating a Short-cut key to run a macro
  • Running a Macro with a Shortcut key
  • Assigning a Macro to a Menu or Toolbar
  • Editing a Macro with Visual Basic

Section 2: Visual Basic Editor

  • Objects
  • Methods
  • Properties
  • Programming Tools
  • The Menu Bar

Section 3: Excel Objects

  • Objects, Properties And Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections Of Objects

Section 4: Using Visual Basic Functions

  • Inputbox Function
  • Msgbox Function
  • Using A Set Statement

Section 5: Building Formular Control Structures

  • If Then Decision Structures
  • Logical Operators
  • Select Case Decision Structures
  • Case Else
  • Comparison Operators With Select Case Structure
  • For Loops
  • Do Loops

Section 6: Running Code

  • Run Mode And Design Mode
  • Running Code From The Development Environment
  • Running Code From The Host Application

Impressed with our Course Content?
Attend a Free Demo Session to Experience our Quality!

Section 7:The Properties Window

  • Changing A Property

Section 8: Variables

  • Dimensioning A Variable
  • Using Variables In Routines
  • Object Variables

Section 9: Userforms

  • Designing & Creating Forms
  • Working With Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events

Section 10: Event Handling

  • Vba Editing & Debugging
  • Auto Macros
  • Error Handling

Section 11: Connecting To Database(Person Should Be Familiar With Basics Of Sql)

  • Connect To Ms Access
  • Access Database & Retrieve Data From Ms Access
  • Create Table & Query Data Filter Db Using Query
  • Update And Modify Db
  • Create Single And Multiple Mapping Tables
  • Filter Db Using Query
  • Query Data Grouping
  • Retrieve Data Using Logical Access Query

Section 12 : Connect Excel To Outlook

  • Connect To Outlook Using Vba
  • Query To Retrieve Mail From, To And Cc Address
  • Retrieve Mail Subject And Time


Queries You May Have:

Who should take Microsoft Excel Macro Training?

• Any Graduates
• Willing to work for office administration, Account Management.

What are the Prerequisite to Join Microsoft Excel Macro Training?

No prior knowledge is required for Microsoft Excel Macro Training



Will you help me for interviews?

Yes, Sure, We will conduct three Mock Interviews for You and also our placement team will assist for your Interview Preparation. 

Related Trainings


  • Microsoft Excel Macro Training in Velachery
  • Microsoft Excel Macro Training in Adyar
  • Microsoft Excel Macro Training in Guindy
  • Microsoft Excel Macro Training in Taramani
  • Microsoft Excel Macro Training in OMR
  • Microsoft Excel Macro Training in Pallikarnai
  • Microsoft Excel Macro Training in Saidapet
  • Microsoft Excel Macro Training in Vadapalani
  • Microsoft Excel Macro Training in Koyambedu
  • Microsoft Excel Macro Training in Porur