Reference case
MS Excel Macro Dashboard Report template
Setting
An international management consultancy firm provides various products and services, inter alia focussed on organizational change.
They use e.g. an in-house developed management tool for generating various .xml report files, for further use in MS Excel.
Subsequently they perform many (post) manual changes in these reports, which are almost impossible to perform in a manual way.
Software
We used the following software in this project:
MS Excel
VBA
XML
Request
Advise together with the client about the possibilities within MS Excel to further optimize and professionalise its current reporting process.
In order to generate a standardized management report in MS Excel by means of a macro that is based on a random .xml report (source) file.
Products
This project resulted in the following products:
Standardized MS Excel Macro template
Predefined Standardized MS Excel Dashboard Report
Incl. Layout, Color Format Conditions.
Related Reference Cases
Experience what our professionals can do for you
Our professionals from your region possess specialized expertise and experience from your industry and help you realize your desired custom-tailored solutions, tools and systems of your choice!
With a MS Excel professional, you will get immediate and effective results.
Get the most out of your MS office software!
Would you like to hire one of our experienced Word specialists?
Please feel free to contact us for further information!