Grow Your Excel Toolbox Today!

Excel is a great tool.  An experienced operator can do awesome things by applying some advanced techniques. You can even record Macro’s allowing you to play them back for repetitive tasks. The macro language built into Excel can do a whole lot more than just record and playback actions however. It is a very robust full featured programming language; Visual Basic for Applications (VBA). Some pretty amazing things can be accomplished with some programming know-how. That is where I come in. I have been programming VBA for Excel for over 15 years and have developed some very effective tools that have resulted in significant time savings as well as reduce errors. Up until now these benefits have been restricted to the company I worked for, however I am now in the position to offer VBA programming services. I believe there is a real need but the benefits may not always be known or obvious. Feel free to contact me if you have any questions.

excel_dashboard2Want to save time? By automating repetitive or cumbersome activities, valuable personnel time can be saved each time these activities are executed. This can have a significant impact on your business.

Want to save money?  When you are using a more expensive software to perform a task Excel can be enhanced to accomplish then money can be saved by reducing the burden on the more expensive software. Example: An expensive CMM program is used to visualize inspection results graphically. A utility could be built in Excel to export the inspection results in IGES which can be imported into just about any CAD package for evaluation.

Want to reduce errors? Anytime we can reduce manual input or at least validate the input we will reduce the potential of operator input errors. One way to do this is to create user input forms for data entry. This will potentially speed up the process but also can include functionality to double check and validate values entered as well as verify all necessary input is complete. The other way to reduce operator input errors is through automating retrieval of the data in the first place.

Want to automate a process? Just about any task consistently performed in MS-Excel can be automated. If you are generating the same data or results time after time, the activity is most likely  a candidate for automation. Example: you are importing .csv files and using excel to sort, review, and report the data in some way. This process could be automated and the only thing the user would have to do is select the file for input.

Want to add functionality to Excel? Let’s face it Excel does not do everything. Example: you would like Excel to remove all leading and trailing spaces in an entire worksheet . A program could be written to do this in a single button click.

The tools I have developed have saved companies a lot of software cost and countless hours in time. I am happy to evaluate your processes to see where my services might benefit you. If you have a project you would like a proposal on or would like me to evaluate your process and usage of Excel to see where I can help feel free to contact me.

Comments are closed.