LEARNING THE MAGIC OF MACRO
Create your own worksheet functions

Experienced and seasoned users of Excel would definitely agree that Excel is a powerful desktop application that could solve a lot of business problems without enlisting the help of their IT department. Especially those who have attended and experienced its power in our Advanced Excel courses "Unleashing the Potential of Excel" or Sales Performance Analytics with Excel" would readily recognize that.

As you continue to discover what Excel could do, you probably would use it more and more for complex calculations, and this is when you might find that the over 300 built-in Excel worksheet functions could no longer cater to your needs. You know that VBA or macro is the solution to your problems, but thinking that macro is only for programmers, you may be hesitant to venture into it. If that's what you really think, read on.

Macro is not specially built for programmers; it is also for layman like you and me. By using macro, you can extend the power of Excel by creating your own worksheet functions and share these customized worksheet functions with other users who have the same needs as you, most probably your colleagues in your organization. Customized worksheet functions can simplify complex calculations such as computing commission or CPF. It can also be used to simplify manual tasks such as calculating the average score of specific coloured cells in a given range. This would be the sample case used in this course.

Through the process of creating a customized worksheet function, you will learn

1. the essential for creating a macro;
2. the commonly used codes that will unleash the power of macros;
3. sharing your customized worksheet function with others.

1. Creating your very first macro through recording;
2. Where are macros stored in the workbook;
3. Understanding how a specific set of codes does;
4. Writing to and reading from a specific cell;
5. Create a set of codes instantly without knowing what the codes are beforehand;
6. Making a set of codes run based on a set of pre-defined criteria;
7. How to repeat a set of actions
8. Allowing users inputs into the macros
9. Returning the results to the cell e.g. presenting the total in the cell when a sum formula keyed in
10. Sharing your customized worksheet functions with others
11. Installing, uninstalling and removing the customized worksheet functions from a computer
12. Providing description for your worksheet functions
13. Protecting your customized worksheet functions
14. Building your customized worksheet functions in double quick time.

This course is specially tailored for business managers and executives who have an extensive knowledge of Excel and need to simplify complex calculation using customised worksheet functions and/or automate manual tasks.

You must have at least intermediate to advanced knowlegde about Excel before you attend this course. Without it, you will not be able to experience the full power of Excel.

If you meet the pre-requisite, download the course details and registration form Now!

Course Dates

»Download Course Details and Registration form Now!

Jason Khoo is the founder of SynergyWorks, which specialises in spreadsheets and databases. He has helped companies draw out valuable information from databases from existing systems and saved these companies thousands of dollars from purchasing new systems by providing solutions using existing PC applications such as MS Office. Examples of such solutions are customer segmentation program, personalised email broadcast to targeted customers, sales lead generation program (mini CRM) etc.

Prior to setting up his own company, Jason has worked in local listed companies and foreign MNCs supporting the marketers in analysing their marketing plans and providing quality information for business decision-making. He was also a financial controller in a Fortune 500 company for a business unit which generates a total revenue of more than S$100 million per annum.

He has also conducted customised in-house Excel training for companies like Discovery Asia, Eltra Aeronactics, etc.