Automation, Application development in Excel, Excel VBA programming, Excel Macro programming
We offer automation and application development in Microsoft Excel

We can help you free up capacity within your organization with automation and VBA Programming in Microsoft Excel.

What processes do we work with?

Often a company’s systems are not adequately designed to meet changing business requirements. We can provide the bridge between your present state and more efficient processes using powerful tools like Visual Basic (VBA) and the powerful features of Microsoft Excel.

We offer flexible application design so if your processes change, it is simple to configure the Excel-based automation to change with you. Our solutions require modest resources compared to ERP implementation or ERP tailoring, while productivity gain is immediate after implementation. And, of course, we do not cause disruption in the business operation during implementation.

What happens after you contact us?
Click here to find out more.

What areas can we help with?

Ineffective processes vary in size and complexity. It can often mean creating regular analysis from fragmented raw data which requires manual clean-up. Often more complex procedures are inefficient like creating quotations with complex budgeting algorithms, hundreds or even thousands of products and format settings. Or a HR new-hire administration process where all paper-based documents are filled in manually one-by-one.

Want to see case studies of automation projects?
Click here to check out our examples.

How do we ensure your success?

We place a lot of emphasis on the safety of your processes and data. We fully comply with GDPR and prior to receiving any data from you, we sign a Data Protection and Confidentiality Agreement with an EU-compatible electronic signature. We plan each our projects with attention to detail. Understanding the present-day processes and designing the correct deliverable is a key to our success.

After processes are mapped and future state design is documented and agreed, we begin the development. Working with frequent checkpoints we enable our clients to give feedback on the progress of the build and so initiate amended functionality to the solution. We provide end-to-end service from design to deployment as well as ongoing maintenance.

For more details about what happens after you contact us, click here or:

Call +36 30 289 2050 or write an e-mail to info@excel1.co.uk for consulting.
All contacts are replied within 24 hours

Major clients of Excel1 Ltd.:

Feedback from our customers

“We worked together with Excel1 Ltd. in creating the client facing data input application for our salary and benefit benchmarking application at SmartScale Ltd. 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 Ltd. & Society of Management Innovators

“We worked together with László Varga from Excel1 Ltd. 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 Inc.

“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, Heinemann Duty Free

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.

We were extremely satisfied with the Excel courses László Varga provided. The courses were really enjoyable, useful and made our day-to-day work significantly more efficient. László Varga was carefully monitoring each participant and supported them one to one as required; he left nobody behind. In addition, he answered all of our questions as they occurred during the course. – Andrea Kész, CFO
Heinemann Duty Free

The Excel course took place in 2018 and we opted for the preliminary, on-site knowledge assessment too. The Hilti Szerszám Kft. is entirely satisfied with the services László Varga provided. We greatly value his flexibility, accurate ways of working and the exquisite attention to individual needs. In addition, he fully complied with our internal audit criteria. Considering the details above, we highly recommend Laszlo Varga as a professional Excel trainer.” – Gyula Takács, Managing Director, Hilti Szerszám Kft.

Call +36 30 289 2050 or write an e-mail to info@excel1.co.uk for more information.
Contacts are replied within 24 hours.

Training in MS Excel

We deliver high quality classroom or online training from beginner level to advanced programming.

Excel Basic training

We offer this course to participants with very limited or no experience with the Microsoft Excel program.

We introduce the essence of how to work with Excel efficiently to reduce waste and unnecessary work.

During this course participants will receive a solid foundation on the principles of Excel and a thorough understanding of the basics required to further grow/improve their skills. This includes the structure of the program’s menus, its primary rules, worksheet operations, and ready-to-use, practical knowledge on references, charts, sorting, filtering and much more.

By completing this course, participants will learn how to handle big data tables efficiently and build basic summary tables on these; how to apply professional formatting to aid the understanding of the results. All-in-all, how to complete tasks in a more efficient way in higher quality.

Excel Intermediate training

We offer our Excel Intermediate courses to participants who are already using Microsoft Excel for solving simpler tasks, and would like to decrease waste in their processes.

During this course participants will receive an overall understanding of the principal logic behind Excel and how its functions are built up. They will learn how to build formulae and the basics of combining those together, how to create summary tables with built-in switches and effective ways to identify errors in data tables. They will also gain practical knowledge how to efficiently lookup data with functions, how to identify and correct items which do not show the right results, how dates and date functions work, how to format and build simple and meaningful charts, how to apply filtering and formats to support the straightforward understanding of the results.

The Pivot table is a great tool to create complex summary tables in seconds – we are providing opportunity to gain knowledge of this excellent tool in one of our optional modules. In another optional module we teach the basis of how to automate regular tasks using advances formulas.

Excel Professional level training

We offer the Excel Professional training for users who regularly use the program for solving more complex tasks and would like to take their skills to the next level. With completing our training, participants will be able to efficiently outsource repetitive tasks and processes to the computer.

Participants will learn how to automate regular tasks using formulas and how to create nested functions to model complex scenarios. We will teach creating built-in automated error detecting functions to reduce time on validating results. To enable creating complex summary tables in seconds will thoroughly discuss the Pivot table and charting options. With the in-depth discussion of the lookup functions we will give effective tools to our participants to compare tables and results. Supporting the meaningful presentation of the data we will share broad knowledge on conditional formatting and on creating charts.

To support fully automated processes we offer an optional macro module in the professional training. With this, our participants will get started on how macros work and will also be able to create their own macro code. In addition, we offer an optional module to support creating error-proofing forms for manual data gathering which significantly reduce the time spent on building a data table from the information collected from individuals.

Excel1 Macro and VBA programming training

We offer this training for users who has extensive knowledge in Microsoft Excel and would like to do automations beyond using functions and formulae.

During this training we introduce how to create macros and practice those with solving real life examples. We teach how to pull together information from different sources into one single data table in an automated way, how to split data from one table into multiple worksheets or workbooks with a single click, what it means to work with variables in macro codes, and how to amend the code already written in an effective way. We also introduce how to assign macros to certain application events, like opening or closing workbooks or even on clicking on a given cell. Combining Loops (for each, for next, do while, do until) and scenarios (if, else, elseif, select case) will help building useful tools to further automate the participants’ own processes.

A whole new world opens up after getting familiar with VBA. It can create more efficient and higher quality solutions to support business decisions and streamline processes.

Automation, Application development in Excel, Excel VBA programming, Excel Macro programming

Copyright © 2021 Excel1 Ltd.