Thursday, November 11, 2004

When To Automate Excel

(Reprinted from AutomateExcel)


Note to Office Managers: If your employees print something out of Excel to type the printout back into Excel, and do this consistently, you might need to automate.

Even Broader Scope: If your employees print anything out of the computer, to type the printout back into Excel, and do this consistently, you might need to automate.

Automate Excel: To make a process in Excel operate by VBA code, in order to reduce the amount of work done by people, increase the accuracy of the work done, and reduce the time taken to do the work.I bet you're very intelligent and can guess the final decision comes down to cost/benefit analysis(cost to automate vs. cost of doing the same), however this example is some of that "low hanging fruit" when looking for areas of improvement, incredibly easy to identify, and also a classic and sometimes hilarious example of when to automate.


Email me for a quote if you have any upcoming automation projects.


Posted by: Jethro | 1:24 AM |