learning the magic of macros course vba 2007

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

Exercise to create macros for

  • Comparing 2 worksheets results
  • Consolidating data from multiple workbooks
  • Splitting data into multiple workbooks
Dates:
Excel 2007/2010/2013
26 & 27 Mar 18Confirmed
11 & 12 Jun 18Confirmed
04 & 05 Oct 18Confirmed

Time: 9am - 5pm
Duration: 14 Hours (2 days)

Venue: International Plaza
10 Anson Road #26-02A

Course Fees: S$700 per pax

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.

Download Macro course Registration Form

« Back to Excel courses