Who Should Attend

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

Our Trainers

Our trainers are practitioners of spreadsheets and databases and have extensive knowledge in applying the different functions and formulas in Excel to real business needs and scenarios. They are specially hand-picked and trained by our Chief Trainer, Jason Khoo, based on their experiences in training and the business knowledge they possess.