Microsoft Excel and VBA Development

Microsoft Excel and VBA Specialists

We specialise in Excel spreadsheet development and VBA programming. We help with everything related to Excel: from simple spreadsheets to complex business models and powerful applications.

These are our specialist areas:

building robust and flexible formulas
designing easy-to-use and great-looking spreadsheets
connecting Excel to databases, the Internet and other applications
automating repetitive, laborious or manual tasks and processes
customising Excel with tailor-made features and functions
developing bespoke Excel/VBA tools and applications
analysing data and creating compelling reports
cleaning, organising and processing raw data

We also assist with everyday Excel issues and answer the odd question to keep you going when you get stuck. No matter how small or complex your issue, contact us to see if we can help. Enquiries and initial consultations are free with no obligation.

Is Excel working for you?

We have met a lot of people who keep doing the same things in a laborious and error-prone way. Using Excel efficiently and safely is not about learning the 95% of functionality you will probably never need. It is about mastering a few principles and finding the 5% of features that help you do the job much better. It is not about knowing how to use a single function, it is about the skilled combination of functions and formulas to make them work together. Sometimes writing a few lines of VBA code works wonders and does what you thought impossible.

We can help discover the features that work for you. If you think what you do in Excel could be done easier, faster or more safely, contact us to find out.

What is VBA?

VBA stands for Visual Basic for Applications – applications are the tools of the Microsoft Office suite like Excel, Word, Outlook, etc. VBA is the programming language behind these applications and is readily available to their users. Each application has its own VBA variation. Chunks of VBA programming code are often referred to as 'macros'.

VBA allows users to customise and control these applications in almost any way they like. Regarding Excel they can make it accomplish tasks that are not possible by using formulas and functions alone. They can alter Excel's default behaviour, add new features, automate entire processes or develop complex applications. When people talk about automating Excel they often refer to manipulating it with VBA code.

For free tools and
samples of our work
check the Downloads page