Microsoft Excel Macro Training

450+

10+

60 Hrs

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

Key Features

Training from
Industrial Experts

24 x 7
Expert Support

Hands on
Practicals/ Projects

Certification
of Completion

100% Placement
Assistance

Free
Live Demo

MICROSOFT EXCEL MACRO TRAINING COURSE CONTENT

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.

Course Features

  • Duration60 hours
  • Skill levelAll level
  • Batch Strength15
  • AssessmentsYes
  • Mock InterviewsYes
  • Resume BuildingYes
  • PlacementsYes
  • Flexible TimingYes
  • Fee InstallmentsYes
  • LanguageTamil/English
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: Then Project Explorer
  • Using the Project Explorer
Section 4: Using Constants
  • Excel Constants
  • Variable Constants
Section 5: Excel Objects
  • Objects, Properties And Methods
  • Getting & Setting Properties
  • Calling Methods
  • Passing Arguments
  • Singular Objects & Collections Of Objects
Section 6: Using Visual Basic Functions
  • Inputbox Function
  • Msgbox Function
  • Using A Set Statement
Section 7: 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
  • While...Wend Statement
Section 8: Running Code
  • Run Mode And Design Mode
  • Running Code From The Development Environment
  • Running Code From The Host Application
Section 9:The Properties Window
  • Changing A Property
Section 10: Variables
  • Dimensioning A Variable
  • Using Variables In Routines
  • Object Variables
Section 11: Userforms
  • Designing & Creating Forms
  • Working With Controls
  • Creating Custom Dialog Boxes
  • Userform Properties Methods & Events
Section 12: Event Handling
  • Vba Editing & Debugging
  • Auto Macros
  • Error Handling
Section 13 : Connect Excel To Outlook
  • Connect To Outlook Using Vba
  • Query To Retrieve Mail From, To And Cc Address
  • Retrieve Mail Subject And Time
  • Retrieve Mail Attachment
  • Practice Sessions

You will be going through detailed 2 to 3 months of Excel Macro Hands-on training

  • Detailed instructor led sessions to help you become a proficient Expert in Excel macro.
  • Build a Excel macro professional portfolio by working on hands on assignments and projects.
  • Personalised mentorship from professionals working in leading companies.
  • Lifetime access to downloadable Excel macro course materials, interview questions and project resources.
Valchery pic

Credo Systemz - Velachery, Chennai
Call Us +91 9884412301

Omr

Credo Systemz - OMR, Chennai
Call Us +91 9600112302

Check here for candidates feedback on Excel macro Training through

FAQ

• Any Graduates
• Willing to work for office administration, Account Management.
No prior knowledge is required for Microsoft Excel Macro Training
Yes, Sure, We will conduct three Mock Interviews for You and also our placement team will assist for your Interview Preparation.

Related Trainings

Nearby Access Areas
Our Velachery and OMR branches are very nearby access to the below locations.
Medavakkam, Adyar, Tambaram, Adambakkam, OMR, Anna Salai, Velachery, Ambattur, Ekkattuthangal, Ashok Nagar, Poonamallee, Aminjikarai, Perambur, Anna Nagar, Kodambakkam, Besant Nagar, Purasaiwakkam, Chromepet, Teynampet, Choolaimedu, Madipakkam, Guindy, Navalur, Egmore, Triplicane, K.K. Nagar, Nandanam, Koyambedu, Valasaravakkam, Kilpauk, T.Nagar, Meenambakkam, Thiruvanmiyur, Nungambakkam, Thoraipakkam, Nanganallur, St.Thomas Mount, Mylapore, Pallikaranai, Pallavaram, Porur, Saidapet, Virugambakkam, Siruseri, Perungudi, Vadapalani, Villivakkam, West Mambalam, Sholinganallur.

Right Side icons