About the Course
This workshop is applicable for participants who want to learn advanced Excel VBA (Visual Basic for Application)/Macros writing in details. Workshop is aiming professional people who work in corporate and looking to learn Excel VBA (Visual Basic for Application)/Macros writing which can be used in their day to day activities. This workshop will enhance efficiency and power use of Excel automation in daily activities. It will improve productivity and speed of work.
Topics CoveredRecording and running macros
Understanding naming convention
Recording in personal macro book
What is VBA and VBE
Writing your own UDF (user defined functions)
IF, AND, OR, Loops and their types
Understanding debugging techniques
Msgbox and Inputbox techniques
Use of Activecell and Offset
Usage of Windows like immediate etc
Error handling techniques
Writing your first procedure using sub and function
Working with sheet and workbook object
Working with complete methods and properties
Interacting with Other Applications like word, outlook et
Creating user forms and converting them to addins
and other user required functions and features and many more...
Who should attendAny person who has basic and intermediate understanding of excel and looking for automated functions and features in excel. Workshop can be customized as per need of participation
Pre-requisitesSome basic knowledge about excel and programming aptitude but not necessary
What you need to bringLaptop, Notepad, Pen and pen drive to carry and copy training material (all optional)"
Key TakeawaysFair idea about macros
All useful shortcut keys knowledge
How to write UDF (user defined functions)
Usage of right tool and function in urgent scenario and situation
Automation and power of recording and writing independent macros
Power tips and tricks
Creation of user forms and independent application/utility and many more..