Excel / VBA Programming and Audit Services

Argos provides a full range of Excel and VBA consulting services, including database programming, report automation, Excel VBA (macro) automation, data conversion, data mining, time series forecasting, and financial modeling.

Based on our extensive experience with I/T and financial audits, we understand the importance of reliable, efficient and accurate task automation.

Our Excel consultants have years of professional experience in data analysis, with advanced business and technical degrees.

Our consultants can:

• Audit and validate your existing Excel / VBA automated solutions
• Suggest process improvements and enhancements
• Modify and extend your current Excel applications
• Create applications for one-time needs (e.g. data import or conversion), or for ongoing task automation
• Develop new applications, using Excel, VBA macros, and database design and programming, to meet your business needs and increase your productivity
• Generate audit trails from Excel applications to comply with Sarbanes-Oxley requirements

The Importance of Accuracy

According to The Use of Spreadsheets: Considerations for Section 404 of the Sarbanes-Oxley Act (Price Waterhouse Coopers, July 2004), “Anecdotal evidence suggests that 20% to 40% of spreadsheets have errors, but recent audits of 54 spreadsheets found that 49 (or 91%) had errors, according to research by Raymond R. Panko, a professor at the University of Hawaii.”

The Journal of Property Management on July 1, 2002 stated, “30 to 90 percent of all spreadsheets suffer from at least one major user error. The range in error rates depends on the complexity of the spreadsheet being tested. In addition, none of the tests included spreadsheets with more than 200 line items where the probability of error approaches 100 percent.”

Perform an online search for spreadsheet errors or spreadsheet audit, and you will find a number of major failures attributed to spreadsheet inaccuracies that hit the press in the past year alone.

At Argos, our focus is on creating Excel / VBA macros and applications that improve your productivity, your accuracy, and your auditability.

For more information or a quote on our Excel programming services, contact us today.