Learning the Magic Of Macros (Excel VBA)

Course details

Managers and Executives who have good working knowledge about Excel and have a need to automate repetitive tasks in Excel.

Learning Objectives

Upon completion of the course, participants will be able to:

• Edit existing macros
• Create macros on the fly
• Share your macros with other colleagues

Course Outline

• Record and run macros
• Where you can store the macros
• Reading from and writing to cells
• Find values in worksheets
• Adding and counting values using macros
• Referring to different worksheets
• Referring to different workbooks
• The power of Looping in macros
• Creating your own worksheet function
• Protecting your codes
• Sharing your codes as Addins

Exercise to create macros for

• Comparing 2 worksheets results
• Consolidating data from multiple workbooks
• Splitting data into multiple workbooks