learning the magic of macros course(VBA)

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