Objective: 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 Covered
Contents 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. • Automation • Security and many more.
Who should attend
Who 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-requisites
Advanced Knowledge or expert in ms excel formulas and functions required.
What you need to bring
Laptop
Key Takeaways
Sample exercise with VB Scripts. Readymade UDF tools.
View this Course
Certified
You have 
