Microsoft Excel Macro Training
5 Star Rating 
485 Learners 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
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
Assistance
24 x 7
Expert Support
Certification
for Course
FREE
LIVE DEMO
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
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:
• 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
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
