Microsoft excel with its built in functions is a solid base to start for many users, with needs ranging from simple calculation tools to advanced reporting and data analytics. We provide consulting and custom solutions for excel ranging from custom templates, VBA macro, addins, to .NET applications.
Leveraging Microsoft Office platform many common and advanced tasks can be automated, for instance:
- Repetitive tasks: copy workbooks, fill personal data, copy data, formatting, printing, exporting to other applications, etc.
- Collaboration: collect data from other users, send reports, etc.
- Interface other programs: send reports via e-mail, perform mail merge, export results or graphs form excel to a presentation in power point or to a word document, etc.
- Retrieve external data: query SQL databases, get data from ERP or other applications for reporting purpose, get data from the internet, etc.
- Visualization: dashboards, reports, etc.
