Microsoft Excel Macro Training
450+
10+
60 HrsMicrosoft 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
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: 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
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.
Credo Systemz - Velachery, Chennai
Call Us +91 9884412301
Credo Systemz - OMR, Chennai
Call Us +91 9600112302
Check here for candidates feedback on Excel macro Training through
