A large and complex Excel spreadsheet with custom functions and macros was used by a company to track suppliers and clients’ rebate payables. The data entered into the spreadsheet was also manually entered into the ERP system to invoice relevant parties, resulting in duplicated data entry. This spreadsheet was critical for the company’s budgeting forecasts and business decisions but had become slow and outdated, and needed drastic improvements to incorporate new features and requirements.
Solution: I was tasked with reverse-engineering the current spreadsheet, understanding its purpose, and identifying what worked well and what didn’t. Staff received financial data in Excel format from the suppliers and clients and manually entered the data monthly for each supplier and client figures.
Improvements Implemented in the rebuild:
We take the stress out of websites for you and offer quick, easy web design so you can get your business online as quick as possible. Start growing and get exposure now!
Below is what you get when you sign up to our site:
*Content and images need to be supplied