Microsoft Excel Macro Training


STAR 5 Star Rating 485 Learners 

Course Content

FAQ’s

Reviews

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

Hands-on
PRACTICALS/PROJECT

100% Placement
Assistance

Expert Support

24 x 7
Expert Support

Certification
for Course

FREE
LIVE DEMO

MICROSOFT EXCEL MACRO TRAINING COURSE CONTENT


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


MOST POPULAR REGIONS


  • 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