About the Course
Offering training on Excel VBA to automate any excel reporting. Teaching from the scratch of programming to advance techniques to master the concept.
Topics CoveredTopics Covered
VBA will be Project Base Learning.
Introduction to Visual Basic
Object Orient Programming concepts and Illustration
Excel Object Model
VBA Data Types
Basic Excel Operations
Dialogs in VBA screen
Defining Global Variables
Defining Static Variables
Working with Functions
Creating Functions using Optional Arguments
Creating Private Functions
Creating Public Functions
Working with Subroutines
Creating Functions using Arguments
Creating Functions using optional Arguments
Creating Private Subroutines
Creating Public Subroutines
Working with Message Box
Working with User Forms
Files Automation through VBA
Files Automation real time scenarios
VBA Sample Project Report preparation
Who should attendMS Office Specialist, MIS Personals, VBA Programmer, Accounts Personal, Project Managers, Developers, Technical/ Test Leads, Program Managers, Project Managers, Research Workers, Freelancers, Data analysis departments, HR Managers, Students
Pre-requisitesBasic Knowledge of Excel is required.
What you need to bringNotepad, Pen,
Key TakeawaysSkill to write excel macro's.