The client asked us to create a tool that would allow to report, analyse and forecast sales data taken from an SQL database. The fast growing client wanted to replace a manually kept spreadsheet, which was just not good enough any longer.
- Design of a ‘database’ and lookup tables (in Excel, which could later be maintained in SQL server or Oracle databases)
- Building CSV interfaces, so that actual data can be imported on the touch of a button.
- Menu driven navigation
- Professional look and feel
- Design of templates for the different functions (e.g. forecast, budget, analysis, reports)
- Multi user capable
- Programed in Microsoft Excel VBA
- Use of cell protection to avoid accidental overwriting of formulas
Are you interested in our services? Please contact us for a free quote.
Excel Software Solutions