Learning the Magic of Macros

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

  • 19-20 Mar 2020
  • 14-15 May 2020
  • 06-07 Aug 2020
  • 15-16 Oct 2020

Price and Duration

S$700 per pax for this 2 days course

AI Chatbot Avatar
⚠️ Welcome to our chatbot! Please note that this chatbot is designed to provide general information about our Excel and Power BI courses, and should not be relied upon as legal or financial advice. Any personal information collected by the chatbot will be handled in accordance with our privacy policy. By interacting with the chatbot, you agree to our terms and conditions.