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 online 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