About the Course
Users who use Microsoft Excel in their day to day tasks knows the importance of learning some basic macros to simplify the tasks. This course is targeted to those who would like to use Excel in a smart way.
Course Duration : 16 hours (2 days) on Weekends. Contact us if you are looking for other days.
Batch Size: 10-15
We are Certiport Authorized Testing Center. People who are interested in becoming Microsoft Office Specialist can take up a crash course and take up the Exam to become MOS.
Topics CoveredDifference Between Macros and VBA Programming
Is VB different from VBA? How?
Understanding Macro Security
Working with Record Macros
Setting Up Digital Certificate for VBA Projects
Understanding Excel Object Model
Edit Macros in VBE
Working with I/P and O/P functions
Working with predefined functions in VBA
Working with Objects, Methods, Events and Properties
Integrating conditions and loops with objects
Executing macros via controls, events, menus/tools etc
Difference between a Template and an Add-in
Creating Macro-enabled Template
Debugging the code
Understanding types of errors and error handling techniques
Who should attendPeople having good knowledge in Excel, people looking for automation who would want to enhance and speedup the mundane tasks, repeated and manual functions
Pre-requisitesBasic to Intermediate knowledge of Microsoft Excel
What you need to bringLaptop with MS Office installed
Key TakeawaysCreate customized programs to speed up daily routines, Excel Automation, in-depth understanding of functions in VBA and logics to innovate work around.