The author of Advanced Excel Resource Centre
My name is Jason Khoo. I am the author of this advanced excel resource centre and
excel book titled
"Excel Secret for Highly Effective Marketers".
Other than this website, I also have a
blog at blogger.com. Currently, I am running my
excel business and
excel training in Singapore.
We provide solutions to business problems, primarily using MS Excel macro
programming or VBA. It started when I realized that I have created a
business model that is capable of streamlining the entire budgeting
process and reduces the number of files used by 90%. Yes. 90%, it
is not a typo error.
I am also providing advanced excel training to excel business users.
It started with the intention to raise the awareness of excel uses in
business. It was so well received that the course is now sold mainly
through referrals. At the same time, I have also set up an
training centre so that my past participants can continue to
learn about Excel.
Prior to setting up my own company, I was working in local listed
companies and foreign MNCs supporting the marketers in analysing their
marketing plans and providing quality information for business decision-making.
I 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.
I was constantly asked where did I learn my Excel from. I told them that
I learn it all by meself as I tried to solve every problem that I encounter.
The next question that follows is "Which book do I recommend?". I didn't
have an answer to that question initially. Then I realized that there is
one particular book that I read and also refer to when I encounter a macro
programming problem. And that is book
Excel 2000 VBA Programmers Reference
by John Green.
The book as shown on the left is a good excel resource book for those
who are interested in Macro Programming. It is written in the form of
a tutorial and covers the various mechanisms available for referring
to particular files, sheets, cells, and ranges of cells. It also
addresses the graphical representation of data--particularly in charts--and
explains the most important aspects of controls and the events they generate.
One of the key benefits for owning this book is in understanding the
internationalization issues in considerable depth. This is the best
VBA book on the market for those planning to write programs for a
multilingual usage of Excel. There is also a VBA primer that covers
critical VBA syntax and the essentials of object-orientation as it
applies to the Excel environment. I will recommend more excel resource in future.
Back to Advanced Excel Resource Center Home Page