Advance Excel

COURSE FEATURES
Max Students 20 Students
Skill Level Foundation
Duration 6 Weeks
Course Fee INR 9500
Certificate Yes
Practical Training Yes
Certified Instructor Yes
Note: Please bring your laptop along with you for this class.
SESSION 1 : GETTING STARTED WITH VBA MACROS
SESSION 2 : WORKING WITH MODULES AND PROCEDURES
SESSION 3 : UNDERSTANDING OBJECTS WITH PROPERTIES
SESSION 4 : USING THE VARIABLES AND CONSTANTS
SESSION 5 : WORKING WITH OPERATORS
SESSION 6 : CONTROLLING PROGRAM EXECUTION
SESSION 7 : WORKING WITH STRINGS
SESSION 8 : DATE-TIME FUNCTIONS IN EXCEL VBA
SESSION 9 : WORKING WITH ARRAYS
SESSION 10 : USER-DEFINED FUNCTIONS
SESSION 11 : EVENTS IN EXCEL VBA
SESSION 12 : HANDLING ERRORS
SESSION 13 : WORKING WITH THE PIVOT TABLE
SESSION 14 : WORKING WITH FORMS AND CONTROLS