We offer consultancy services for a variety of operational and analytical work
in the corporate sector.
All companies use Microsoft Excel for their day-to-day tasks; as such we are able to provide spreadsheet solutions on a stand-alone basis or in combination with your existing systems
An international freight forwarding company headquartered in Canada
The client, an international shipping company, maintains his customer list and shipping container information in separate MS Word files.
The client would like a database solution to enable tracking of his customers and shipped items.
The client also wants to track how much customers have paid and what amounts are outstanding.
A database solution in MS Excel is being built.
This involves building an input screen for the client to enter Customer and Recipient details, items being shipped and the container number.
When this solution is complete, the client will have all the customer and shipping data at his fingertips. No more papers being filed.
The Global & Technology Operations division of Canada's largest financial institution
Employees did their budgeting and forecasting manually in Excel and Word.
The client requested a solution which would consolidate all the financials from the various departments and summarise the results in a master dashboard.
We developed an application called eBudget.
An input form was created which collected all the necessary budgeting information (cost center, fiscal year, item description, cost etc). The data was uploaded into a master database built in MS Access. The analysts were able to retrieve and parse the data to create executive summary reports.
A further development of the solution was to move the application online which enabled managers to remotely perform their planning and budgeting exercises.
A leading diversified media and communications giant in the North American telecoms space
The client needed a summary of a large volume of data.
The data was downloaded from several sources to MS Excel, and needed to be combined in one file and formatted and summarised for readability.
We developed a macro to reduce the cycle time from 4 hours to 30 seconds!
Yes, 30 seconds
The macro went through all the worksheets and formatted the text and date fields in the various columns for consistency. It then consolidated all the data in one worksheet and summarised all the required information in a one-page dashboard.