About the Course
If you think that creating macros is too complicated or beyond your capacity, don't worry, this course is intended for those of us who are just starting out in programming, so it starts from zero. Hence Excel4all has designed a two days’ workshop not only to empower the participants with the basics of macro but also to train in designing and customising the macro program with simplified logic as much as possible so that it's easy to learn VBA.
Topics CoveredContents in Brief:
• MS Excel Overview.
• Recording a Macro. Reviewing the macro code,
• Overview of VBA & Office
• Objects , methods and Properties,
• Form Designing and Control
• Loops and Creating reusable VBA Code
• Creating User Defined Functions ( UDF)
• Error handling, Debugging.
• Security and many more.
Who should attendWho Can Attend:
This workshop would be very useful to participants who are well versed with excel and would like to step in to the world of automation and would like to do the process improvements by learning Excel VBA & Macro. Various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration folks can attend the program.
Pre-requisitesAdvanced Knowledge or expert in ms excel formulas and functions required.
What you need to bringLaptop
Key TakeawaysSample exercise with VB Scripts. Readymade UDF tools.