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.
WORKSHOP OBJECTIVES
Through the process of creating a customized worksheet function, you will learn
- the essential for creating a macro;
- the commonly used codes that will unleash the power of macros;
- sharing your customized worksheet function with others.
WORKSHOP OUTLINE
- Creating your very first macro through recording;
- Where are macros stored in the workbook;
- Understanding how a specific set of codes does;
- Writing to and reading from a specific cell;
- Create a set of codes instantly without knowing what the codes are beforehand;
- Making a set of codes run based on a set of pre-defined criteria;
- How to repeat a set of actions
- Allowing users inputs into the macros
- Returning the results to the cell e.g. presenting the total in the cell when a sum formula keyed in
- Sharing your customized worksheet functions with others
- Installing, uninstalling and removing the customized worksheet functions from a computer
- Providing description for your worksheet functions
- Protecting your customized worksheet functions
- Building your customized worksheet functions in double quick time.
WHO SHOULD ATTEND
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.
PRE-REQUISITE
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!
Testimonies from our courses' participants
Photos of our Participants
WORKSHOP SCHEDULE
The course is 2 days long.
COURSE FEES
Price:$700 per pax
Computers and Course materials will be provided by everydayExcel Business Lab Pte Ltd.
Course Dates
15 & 16 Mar 2010
28 & 29 Jun 2010
7 & 8 Oct 2010
»Download Course Details and Registration
form Now!
VENUE
10 Anson Road #26-02A
International Plaza
Singapore 079903
|
ABOUT THE TRAINER
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.
|
Keep me updated on your course dates!
Remember: Your privacy is safe
and you may stop further mailings at any time.
PS: We need you to click on the link in our confirmation email to
confirm your name and email address
so we can verify you are a real person. Please look out for it.
|
|