Issue - March 2015
The primary purpose of writing a Macro is to automate tedious processes and speed up processing time, leading to increase in productivity. For example, you may need to copy data from one Excel worksheet to another but the layout stops you from copying all at one go. In this case, a Macro can be written to perform the process, especially if the process has to be carried frequently.
If you are now capturing the details of your company transactions using the accounting
approach of double entry. You may be entering the details of each transaction into one single row,
duplicate the row and modify some of the details in the second row for the second transaction.
For one transaction, this is a simple task and takes no more than a minute. But if you
have many transactions to capture, it would be too time-consuming to do all the entries.
To speed up the process, a macro can be used to replicate the process. This can save you a
minute for each transaction. And for 100 transactions, you would save 100 minutes! That is a
huge time saver. Of course, writing the Macro will need some time but in the long run, the time
savings would justify the time spent creating the Macro.
Our training business grew and a new accounting staff was required for the double entries because of the need to identify whether the transaction should be treated as Revenue, Cost of Goods Sold, Operating Expenses, Assets or Liabilities. However, it was not easy to find the candidate with the right skills for the job. When no suitable person could not be hired quickly enough, we finally decided to modify the Macro further and incorporate the knowledge of the double entries into the new Macro. Instead of having one Macro for all the entries, subsets of the Macro were created, one subset for one type of transaction. With the modification, there was no need for the new staff to have accounting knowledge. All the person has to do is to capture the expenses using some basic layman rules and the Macro will take care of the rest of the processes. This modification allowed us to widen the pool of candidates for the role and even reduced our cost as it was cheaper to hire staff with no accounting background.
The above example clearly demonstrated that Macro can be used to simplify processes and re-design jobs. With the current tight
labour market condition in Singapore, writing Macro could very well be a highly feasible solution to your staffing problem.
To find out whether you have the second bad habit, try this:
Click on this link to post your question.
With the newly introduced PIC bonus, you are now paid (not paying) 60% of the course fees for sending your staff to our courses. Check out now in this IRAS PIC Link.
Hidden Secrets in Data Analysis with Excel 2007/2010 - 30 & 31 Mar 2015 (confirmed)
The Hidden Key to Excel Reporting and Charting - 19 & 20 Mar 2015 (confirmed)
Unleash the Power of Excel Power Pivot for Data Insights - 6 & 7 Apr 2015 (confirmed)
Learning the Magic of Macros 2007 (Excel VBA) - 5 & 6 Mar 2015 (confirmed)
Breakthrough Performance for HR in Excel 2007/2010 - 12 & 13 Mar 2015 (confirmed)
Dynamic Real-Time Forecasting with Excel 2007/2010 - 23 & 24 Mar 2015 (confirmed)
For the details of the courses, please refer to our Excel courses page.
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.