Automate Excel with VBA programming to reduce errors

Having worked as a business analyst I always have this fear of undiscovered errors when I present my Excel reports to my management. Recently, while working on an Excel project, I uncovered about 10 cells of calculation errors in a forecasting spreadsheet.
Error

My fear of errors

Having worked as a business analyst I always have this fear of undiscovered errors when I present my Excel reports to my management. Recently, while working on an Excel project, I uncovered about 10 cells of calculation errors in a forecasting spreadsheet. The executive manually compiles this forecast for a logistic oriented company. He needs to manually calculate 30-50 values using pivot tables and copy them into an Excel report template.

Studies have shown that Excel spreadsheet errors are extremely common. Humans appear to have an error rate floor (ERF) that exists even when they are working very carefully. Everyone has a similar error rate floor, and working more carefully can decrease one’s error rate only modestly. Not a very comforting thought when you are working on an important spreadsheet.

Excel VBA can eliminate costly spreadsheet errors

My strongest advice to clients is to automate the most tedious and error prone parts of your Excel spreadsheets to reduce such calculation errors. I always argued that such revamped Excel application can be proven to give productivity gains. The calculated savings will be a key decision factor in whether you find it worthwhile to go forward in this project. Key variables in estimating cost of your present reporting process can include: (reporting frequencies per month) * (time needed) * (no of people involved) * (potential costs in reporting errors). The future gains will certainly exceed the present costs.

One Response

  1. Dear Sir/Madam,

    Please introduce I am freelance mobile developer. Currently we are preparing mobile community website with target platform of Android, BlackBerry, and Windows Mobile System.

    It is nice to see your website, and it would be nice if you can contribute with our project by giving us access to your website content by Rss so we can delivering it to our user.

    Nice to know you

Leave a Reply

Your email address will not be published. Required fields are marked *

Contact Us

Drop us a message even when it’s late because the best ideas can come at night.

About Aeternus Singapore

aeternus consulting singapore logo
Aeternus Consulting is the premier consultancy firm for analyst-grade Microsoft Office training courses in Singapore. ACRA: T14LL0891K

Microsoft Office training solutions

corporate training course chair
We work with businesses and individuals who need effective Microsoft Office training solutions.

Analyst-Grade Training Courses

analytics with microsoft excel chart
Premium Training for Business Analysts, Data Analysts & Information Specialists in Singapore.

Our Services Include

Our Microsoft Office-centric services include:
* Full range of Microsoft Excel Training Courses in Singapore.
* Microsoft Office PowerPoint Training Courses.
* Consultancy in Excel, Access, VBA Application Development & PowerPoint Presentation Design Projects.
* Personal coaching & corporate bespoke Microsoft Office training sessions for employees.

Training Course List

Excel Basic, Intermediate, Advanced Levels
Excel PivotTables Inside Out
Data Management & Data Analysis in Excel
VBA Programming with Excel
Advanced VBA Programming with Excel
Essential Microsoft Excel for HR Professionals
Up to Speed with Microsoft PowerPoint
PowerPoint Design & Animation Ideas for Business
Microsoft SharePoint Training Workshop

Instagram (@aeternusconsulting)