Home

 

Eppert Consulting
Eppert Consulting

Professional Excel Business Solutions

We are Eppert Consulting Limited, the Excel consultant. We provide consulting and development services to markedly increase the efficiency of your business activities.

In order to achieve your objectives, we create bespoke Excel macros, applications and spreadsheets.  Microsoft Excel and Excel VBA programming are the tools we use to achieve this. 

Software Solutions and Services Based on Microsoft Excel

We specialise in developing our solutions based on Excel. Please have a look at our case studies. These give you an idea of what solutions we have developed in the past.

Contact Us

We provide …

Analysis, Design, Development and Installation of Custom-made Excel Tools and Apps

We design custom made Excel tools from the start. We analyse the clients needs, design, develop and program the tools and applications.

Excel Macro and Add-In Programming

We develop macros and add-ins to automate your repetitive spreadsheet tasks.

Spreadsheet Design

We design new spreadsheets for you or improve your existing spreadsheets to a level which is robust and easy to use.

Database Solutions

We provide database solutions using Microsoft SQL server, Oracle or other databases as the backend for the handling and analysis of large amounts of data in a single user or multi user environment.

Excel Support

We provide Excel support for all business needs be it design of spreadsheet, debugging or developing of specific formulas.

Re-Engineering of existing custom made Excel tools and applications

We provide the re-design and re-programming services, when existing applications are no longer fit for purpose or need to be adapted to new circumstances and technologies.

Excel Interfaces to Existing Business Software 

We provide links and interfaces to existing business software like SAGE or SAP. We can automate imports and exports of data to reduce time consuming manual work.

Excel Front End Solutions and Analysis Tools to Existing Databases

We provide Excel front end tools and solutions to work with databases to provide a familiar user experience.

Software Maintenance of Excel Applications

We provide software maintenance and support services for both our own developments and also third party developments.

No Job Too Big or Too Small

The size of our projects ranges from 1 hour excel debug as a one off for a sole trader to a as much as multi-year project for an international businesses group.

How We Work …

Our work usually starts with an analysis of the client’s needs and a detailed  cost estimate ensues. This quote is free of charge for new clients.

Our services are usually billed at an hourly rate but special arrangements are possible. We sometimes offer special introductory rates to new clients.

Contact Us

 

Case Studies

We develop bespoke Excel based applications, tools, add-ins and macros. With the help of our clients we designed all of them with the purpose of improving the efficiency of their businesses.  Here are some examples of solutions we have developed in the past:

While the above is an incomplete list of past Excel VBA programming examples, we are ready to meet new challenges.

Some recent clients.

References are available upon request.

Blog

Office Scripts vs. VBA: Programming Excel for the Web and Desktop

Microsoft Excel has long provided the ability for users to write “macros”—pieces of programming code that let people automate both simple and advanced tasks. The official name of these macros is Visual Basic for Application (VBA) because they use Microsoft’s Visual Basic programming language. VBA macros are extremely powerful, and we’ve used Excel macros and …

How to Combine Macro-Enabled Excel Workbooks with Microsoft Forms

One of the questions we are commonly asked is whether a Macro-enabled Excel workbook is better than Microsoft Forms for collecting and processing data. The answer isn’t the same for everyone. In some cases, Microsoft Forms might be better. In others, a macro-enabled Excel Workbook is crucial. Often, a combination of both technologies is the …

Connecting Excel to SQL Server: Adventures in an Almost Legendary Project

We were hired to convert a large UK accountancy firm’s many interconnected Excel spreadsheets into a robust SQL Server database project. Part of the project included exporting data from Excel to SQL Server. The intricacies of doing this were immense. The London accountancy firm The accountancy firm is a large, respected company based in London. …