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
