Advance Excel with Macro | VBA Programming
Advance Excel with Macro | VBA Programming
Learn Advance Excel with VBA Programming and master the skill of automation. Increase your knowledge, create User Defined Functions and automate you day to day work effectively using Excel Macros | VBA Programming.
Accomplished experts and excellent option for employees and job aspirant graduates
No matter whether you are looking for better recognition at work or improved job opportunities; our VBA Programming course in Mumbai and Navi Mumbai is the best choice available. You can learn from highly accomplished experts who have vast experience in this field. Our program meets the requirements of experienced professionals, beginners and aspiring graduates in a perfect way.
The modern complex business environment demands expertise in Microsoft Excel along with Macro | VBA Programming. Our course helps you add this skill set in an easy and affordable manner. Our VBA Programming Training cost is highly affordable and you can expect a systematic approach with us.
Weekend and Weekdays batches available.
For classroom advanced excel training and certification. Kindly click “Contact us” button and fill the form. Our representative will contact you with all the details.
Syllabus
- Introduction
- Accessing VBA Editor
- Debugging
- Option Explicit
- VBA Excel Macros
- Modules
- Procedure
- Apostrophe Comments
- REM Comments
- Syntax for MsgBox
- MsgBox Button Constant
- MsgBox Icon Constants
- MsgBox Return Value
- Syntax for InputBox
- Numeric Data Types
- Non-Numeric Data Types
- Syntax for Constants
- Mathematical / Arithmetic Operators
- String Operators
- String Operators
- Logical Operators
- IF…Then Statement
- IF…Then…Else Statement
- IF…Then…Elseif…Else Statement
- Select….Case Statement | Switch Statement
- For … Next
- For Each… Next
- Do…While Loop
- Do…Until Loop
- While…Wend
- InStr Function
- InstrRev Function
- LCase Function
- UCase Function
- Left Function
- Right Function
- Mid Function
- Len Function
- Trim Function
- LTrim Function
- RTrim Function
- Space Function
- Replace Function
- StrComp Function
- String Function
- StrReverse Function
- Date Function
- CDate Function
- DateAdd Function
- DateDiff Function
- DatePart Function
- DateSerial Function
- FormatDateTime Function
- IsDate
- Day Function
- Month Function
- Year Function
- MonthName Function
- WeekDay Function
- WeekDayName Function
- Now Function
- Hour Function
- Minute Function
- Time Function
- TimeSerial Function
- Declaring an Array
- Assigning values to an Array
- Multi-Dimensional Arrays
- ReDim Statement – Dynamic Arrays
- Array Functions
- Split Function
- Join Function
- UBound Function
- LBound Function
- ISArray Function
- Filter Function
- Erase Function
- Workbook Events
- Worksheet Events
- Syntax Error
- Compile Error
- Runtime Error
- Error Handling
- On Error Goto 0
- On Error Resume Next
- On Error Goto <label>
- Objects
- Properties
- Methods
- Application Objects
- Workbooks Objects
- Worksheet Objects
- Range Objects
- UserForm
- Controls
Project for practical knowledge
Course Features
- Lectures 0
- Quizzes 0
- Students 0
- Assessments Yes