Session – 1
Introduction to Spreadsheet
Automation and Fundamentals
Session- 2
Understanding Variables, Data Types, and Constants
Procedures Subroutines and Functions
Session – 3
Debugging in VBA
Decision Making and Repeating Actions
Session – 4
Manipulating Files and Folders with VBA
Working with The Excel Object Model
PROJECT PART I
Session 5
Working with Cells and Ranges
Defining Ranges
Working with Worksheets
Session – 6
Working with Other Workbooks and Files
Using Built-In Functions and Statements
Session -7
Customizing Dialog
Working with Charts
Session- 8
Automating Procedures with Excel Events
Controlling Other Applications with VBA
PROJECT PART II
There will be exercise & assignment after every session
HEMANT KAJARIA
SENIOR CORPORATE TRAINER FOR INDIVIDUALS | GROUP | CORPORATE
(+91) 9821 041 860 | 9820 625 162
Email: hkajria@gmail.com
www.hemantkajaria.com
