02 / Excel & VBA
Excel and VBA solutions that reduce manual effort
Custom VBA tools can turn recurring spreadsheet tasks into repeatable workflows and connect Excel with other systems.
Typical challenges
- Time-consuming monthly spreadsheet routines
- Manual copying and formatting of data
- Existing workbooks requiring maintenance
- Links to databases and other Office tools
Services
- VBA macros and custom workbooks
- Data imports, transformations and checks
- Optimization of existing Excel tools
- Reporting and Office automation
Technologies and practical experience
- Excel/VBA forms, repeatable workflow automation and configurable reporting tools.
- Data reconciliation and reporting with SQL Server, Power Query and Power BI.
- Experience with SAP BW and SAP Analysis for Office for planning data import and preparation.
Example: E.ON
A recurring monthly Excel task was reduced from approximately two working days to about two minutes with a custom VBA tool.