Introduction
We help ensure that your company’s administration is smooth and fast, with as little human work as possible.
With 20 years experience we offer:
- Improvement and acceleration of existing Excel-based data recordings
- Creating custom reports, developing automatic data processings
- Replacing repetitive administrative tasks with programming
- Establishing connections between systems (AS/400, SAP, Symbol, etc.)
- Application of advanced techniques (SQL, Power Query/BI, KPI dashboard, etc.)
Effective administration: data management with programming
I started my professional career in 1999 in the field of Financial Controlling. From the very beginning I was interested in optimising the workload – in the positive sense of the word of course. The target was not purely work less: the emphasis was on making the task with as much computer support as possible, getting rid of the boring, repetitive parts..
An early memory of this era is of 4 computers in the Finance dep’t were running my programme parallel carrying out product costing to meet the deadline
During the decades I worked in Finance and Logistics, so I learnt not only the theoretic aspects of efficient procedures necessary for financial activities. In Logistics these are real life examples, where the situations are not always black or white. Logistics incorporate really complex material and information flows, where a great number of people are involved who come from different levels of education, background or culture – especially in a multinational environment.
Here I understood that the solutions you provide must be easily understandable and usable, preferably fool-proof.
Sometimes alone, sometimes in a team we improved the financial or logistics procedures in a number of companies I worked at. I was part of a 3 person strong team which created a complete shop floor system at a middle-sized multinational company with the help of a programming staff – I am really proud of this achievement.
As my true calling is the managing of computerised processes, we decided to make this available for the public.
We offer support for improving the administration flows, processes in your company in order to optimise human workload.
What we do:
- Clean up the process, identify the core functions, get rid off the frills
- Use only the necessary admin processes
- Exploit the hidden features of Excel
- Use modern connectivity methods between systems or any data sources
- Automatize what can be or worth doing.
What you will get with our tailor-made solution:
- A more robust, clean and straightforward procedure which
- gives the same results as before, but
- is more accurate,
- is delivered in less time
- with decreased admin workload!
We are familiar with the following IT techniques:
- Excel in a professional level
- Power Query: an Excel add-on, targeting mass data processing
- Visual Basic: Excel's legacy programming language
- SQL: standard query solution for MySQL, MSSQL, Oracle or PostgreSQL databases
- Power BI: Microsoft's online, dynamic KPI/scorecard/chart deploying service
- Sharepoint, Power Automate: Microsoft's data sharing and automation solutions
- Power Apps: Microsoft's new cloud-based programming environment
- SAP: Industry-standard Enterprise Resource Planning (ERP) system
Accomplished projects in Administration support
Beside the various solutions we created for the companies working at, these projects were delivered for external clients. Check out our latest works to have an initial idea what can be achieved by Excel automation and programming!
Our satisfied customers
