Automation and application development in Microsoft Excel

Automation, Application development in Excel, VBA programming, Macro programming
Excel1 offers automation & application development and corporate training courses in Microsoft Excel

Application development & automation

We work together with small & medium business and multinational corporations on the field of automation and process redesign to free up capacity within their organizations.

Large number of companies do not have an integrated ERP solution, or their current ERP setup is not sufficiently tailored to appropriately support changing business requirements. These circumstances usually result in excessive manual work which can be reduced by process automation in Microsoft Excel.

Ineffective processes greatly vary in size and complexity. Sometimes it means creating regular analysis from fragmented raw data which requires manual clean-up every single time. Often more complex procedures are ineffective like creating quotations including complex budgeting algorithms, tens or hundreds of products and format & layout settings or an HR new-comer administration process where all paper-based documents are filled in manually one-by-one.

It is common in these processes that very often they can be automated and therefore precious human capital can be allocated more effectively.

We plan each our projects with much attention to details. Understanding the present-day processes and deliverables is key to success. After processes are mapped and future state design is agreed & documented, we start the development. Working with frequent checkpoints we enable our clients to give feedback on the progress of the application design and to initiate building amended functionality into the programs. We take part in deployment and offer maintenance as part of the service.

Feedback from our customers:

“We worked together with László Varga from Excel1 Kft. on the development of our quotation automation process. We had a former version of the application from ages ago, but it was slow, unreliable and missing quite a few functionalities which we wanted to have.The new application was delivered within the deadline and with meeting all our expectations. Throughout the whole project we could count on László Varga’s expertise and support, he was always available for our questions and asks, and proactively aided the development process with propositions and recommendations.It was great pleasure working together with someone who always arrives on time, who shares the language we speak and who pays attention to the project documentation, too. We strongly recommend him for future projects.” – András Neményi, CEO, A.MeCoD Zrt.

“We worked together with László Varga in creating the client facing data input application for our salary and benefit benchmarking application at SmartScale Kft. Our expectation was to create a system that is not only logical and easy to use but also automatically carries out the initial statistical data validation algorithms which helps to prevent erroneous data entry and upload. To enable this, László had to program a comprehensive data model, which he delivered not only in a truly creative way but also efficiently. It was great to work together with a person who is not only proficient in his area of expertise but also understood our requirements to the best and helped our work with tailored solutions and recommendations.” – Iris Kassim, Managing Director, SmartScale Kft. & Society of Management Innovators

“Working with László Varga was very easy, he quickly understood my needs related to the reporting system we developed, and he also quickly managed to translate those requirements into the language of functions and formulae. It’s been my long-awaited dream to have a comprehensive, yet visual report that has all the required metrics and requires only little effort to have it refreshed from week to week. It is a very scarce combination that someone can deliver very complex development requirements and in parallel he can make the client understand the logic behind the functions and formulae.” – Ildikó Jankovich, Managing Director, Magyar Duty-Free Kft. (Heinemann)

We managed to reduce a nearly 8-hour long, monthly process to practically a 5-minute process with the support of László Varga. Not only that we automated that process, but we also learned several tools, so from now on we can develop further automation on our own in Microsoft Excel” – Katalin Nagy, Accountant, Wärtsilä Hungary Ltd.

Call +36-30-289-2050 or write an e-mail to info@excel1.hu for free consulting.

Major clients of Excel1:

Corporate training courses

We teach how to become more efficient in Excel right from the entry level up through to advanced formulae & dashboard building, to automation with macro programming. We see training as a service, with wide variety of elements in each package:

Various forms of knowledge & development need assessment
Creating separate groups based on the assessment
Tailoring training material to the groups
Interactive classes with case studies
Printed training material for each participant
Additional online training exercises with video-supported resolutions after the classroom training
Summary of the participants’ anonymous feedback from results

Call +36-30-289-2050 or write an e-mail to info@excel1.hu for free consulting on corporate training.

László Varga, chief developer & trainer of Excel1 Ltd.

My name is László Varga. I founded Excel1 in 2015 to support organizations becoming more efficient through automation of processes and training of their employees.

I have been working on developments and teaching the efficient usage of Microsoft Excel for the past 15 years to multinational corporations, small and medium-sized businesses, to my colleagues and to the students of the Corvinus University of Budapest.

I am convinced that instead of using manual force, we should outsource more and more tasks to the computers, letting the machine do the heavy lifting for us. The more steps we delegate, the more we can use our intellect and perform higher value-added tasks during our work.

Prior to managing Excel1 I spent more than a decade in multinational companies (IBM, Acelity), which helped me understand how large organizations work and how corporations manage their processes. As a Lean and Six Sigma expert I took significant part in improving and transitioning back-office processes especially in the Finance, Administration and HR area.

One of the reasons why clients enjoy working with me is my devotion to find out what exactly their needs are. I passionately go for understanding the processes I need to work with, so I can offer & deliver great solutions for their benefit.

Call +36-30-289-2050 or write an e-mail to info@excel1.hu for free consulting
Automation, Application development in Excel, VBA programming, Macro programming

Excel képzések és fejlesztések

Személyes és szervezeti hatékonyságnövelés