Advanced Excel Training in Gurgaon(Sector 14)
Kamal
9650740760
kamalg.mmt@gmail.com
Gurgaon - IFFCO Chowk
Education and Learning - Professional Courses
Ads Description
1. Introduction to VBA
2. Built-in Functions
a) Interaction Functions - Msgbox, Inputbox
b) String Manipulation Functions - ASC, CHR, INSTR, INSTRREV, LCASE, UCASE, LEFT, RIGHT, MID, LEN,
LTRIM, RTRIM, TRIM, STRCOMP, REPLACE
c) Data Type Validation Functions – ISDATE, ISNUMERIC, ISEMPTY, ISNOTHING
d) Array Functions – UBOUND, LBOUND, SPLIT, JOIN
e) Logical Functions – And, Or, Not
f) General Functions – All Sheet, workbook and cells related functions
3. Loop Statements: For-Next, While-Wend, Do While-Loop, Do Until-Loop
4. Conditional Statements: If-EndIf, If-Else- End If, Select Case-End Select
Note : Examples on each topic will be covered in detail.
EXTREME PROGRAMMING
5. Charts : Examples using VBA
6. UserForms
7. Event Driven Programming: Workbook Events, Worksheet Events, Other Events.
8. Import/Export: Text Files
9. Import/Export: Excel,csv files
10. Dashboards
11. Outlook Integration
12. Practical – Business cases