Learning the Magic of Macros

Who Should Attend

Managers and Executives who have a 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

Exercise to create macros for

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

Program Dates

• For inhouse runs only

Price and Duration

S$900 per pax for this 2 days course