Learning The Magic of Macros

Based on 2007/2010 (Excel VBA).


In-House sessions are available upon request.


Course Overview:

Learning the Magic of Macros makes use of real case examples. Unlike most Excel macros courses which are designed for programmers, this course is specially designed for advanced Excel users who do not have any background in programming. Two groups of Excel users are likely to benefit from this course:

  1. Those who are keen to explore macros to automate and speed up tedious and repetitive Excel tasks, and
  2. Those who like to modify existing macros built by someone else and customize them for their own use.

Using case examples to constantly engage the participants on the technical topic of programming, this course aims to help users create macros that are able to significantly reduce the amount of time spent on a time-consuming Excel job and make complicated Excel jobs simple enough for those without advanced Excel skills to handle.


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 Curriculum

Section 1: Record and run macros
Section 2: Where you can store the macros
Section 3: Reading from and writing to cells
Section 4: Find values in worksheets
Section 5: Adding and counting values using macros
Section 6: Referring to different worksheets
Section 7: Referring to different workbooks
Section 8: The power of Looping in macros
Section 9: Creating your own worksheet function
Section 10: Protecting your codes
Section 11: Sharing your codes as Addins
Learning The Magic of Macros (2-Day) 14:00:00

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • SGD 700
  • 2 days
  • 1 Units
  • 840 Minutes
  • Wishlist

Enrol With Confidence

PayPal Acceptance Mark

Registration Support

If you require further assistance on registration matters, email to

In-House Enquiry

Achieve higher ROI with your training budget with In-House trainings, email to
everydayExcel Business Lab is a training company offering Professional Microsoft® Excel Courses with a Business Perspective. We tailor-made Excel courses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resource, administration, business development, etc. Our excel course trainers are not just Masters of Excel who teach people how to use Excel. They are business analysts who can naturally appreciate the decisions made in businesses and the common business problems encountered and at the same time able to make expert use of what is available in Excel to solve analytic and reporting issues in business. Bottom-line for our client is always about how we can use Excel in a way to save a great deal of time and resources for the business. At EverydayExcel, we don't teach people how to use Excel as an end in itself. We teach people how to use it as a means to an end; that to apply the skills and techniques in solving solve their various business problems. For us, there is a huge difference in the two. We do not set out to train people to become gurus in using Excel who are unable to apply it to real-life business situations. We engage with our training participants in such a way that they are triggered to relate what they learn in Excel to their business problems that they face, and then go step by step to tell them how to approach them by creating powerful solutions in Excel. About Your Chief Trainer: Jason Khoo is the author of the two books "Excel Secrets for Highly Effective Marketers", "Hidden Secrets of Data Analysis with Excel" which are sold in all the major book stores in Singapore and in online Amazon. An expert in spreadsheets and databases, Jason also founded SynergyWorks, a consultancy firm which has helped many companies extract valuable information from databases using Microsoft® Excel. He has helped companies save significant amount of money by providing solutions using existing PC applications such as MS Excel instead of purchasing new systems. His clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Nippon Paint Singapore, Heinz Asean, Tanah Merah Country Club, and etc.
More Courses by everydayExcel Business Lab

Students Who Viewed This Course Also Viewed