With over 20 years’ experience, and 3 bestselling books on Excel under his belt, Carl Nixon is your ideal VBA/Python partner. Over the past 20 years, clients of all sizes (including PepsiCo and Walmart) have trusted me with their VBA development.
I offer a wide variety of Excel, VBA and Python related services. Here are just a few of them.
VBA & Python Programming
With VBA and/or Python you can build incredibly powerful bespoke applications for your business. No longer will you be limited to the limitations of spreadsheets in Excel or mini databases in Access. Over the past 20 years, I have built a wide range of VBA applications including;
- Production planning applications for the food and pharmaceutical industries.
- A hedge fund management application monitoring $500m of hedge funds.
- A soil analysis application analysing data gathered by drones.
- A pricing comparison / analysis application checking 50m prices.
- A tide analysis and prediction tool for a leading European university.
Spreadsheet Based Applications
Building a bespoke application for your business does not have to be a major financial investment. Excel VBA applications can be as powerful as fully bespoke software, but it doesn’t need anywhere near the same amount of financial outlay.
Applications developed using Excel and VBA can go far beyond what a normal spreadsheet can do. Some of the more powerful features we can incorporate include;
- Windows forms for data entry and validation.
- File handling and manipulation.
- API Connections to external services
- Working with other Microsoft Office applications (Word, Outlook, Access etc)
- Connecting to databases (SQL etc) and other data sources.
Having a spreadsheet fail on you can turn in to a disaster very quickly – it can prevent you getting the vital information you need to run your business. In worst-case scenarios, it can even destroy the source data.
I provide a fast and reliable spreadsheet repair service that will turnaround your spreadsheet in the shortest possible time.
While I repair your spreadsheet, and where possible, I will try to improve your spreadsheet in the process.
Robotic Process Automation (RPA)
Imagine an employee that works 4 times faster and works 24/7 without the need for a break. That employee would be doing the work of 12 people, making them a highly valued employee. That is what RPA offers your business.
At its heart, RPA is a piece of software that operates other software such as Excel, Sage, browsers, FTP software or anything else you will find on your PC. RPA does not need expensive software, it can be achieved with VBA, Python and other software.
RPA Solutions programmed in VBA and Python can;
- Open software
- Locate things visually on the screen
- Click on buttons
- Type/copy/paste text
- Browse for websites
- Scrape data from websites
- Work with APIs
- And much more.
As a result, it can act as a human being sat at the keyboard. You can even watch it work and if it wasn’t for its speed, you wouldn’t be able to tell if you were watching a human or a robot at work.
Thanks so much for your hard work on this, I’m really impressed and have sent your details around to the whole team here. Hope to work with you in the future.
Katy Ball, Fever PR
Big up to Carl for applying some kind of crazy voodoo to my spreadhsheet. In and out in lightning fashion, my client could hardly even see the joins! Cheers Carl.
Neil Pie, Neil Pie PHP
What a star. I had no idea of the power of spreadsheets before I started talking to Carl. He has developed a sheet for me that brings together all the information contained in about 12 separate sheets previously and made me far more efficient. Many thanks Carl.
Geoff Davis, GRD Credit Control Service
I would recommend the excel-expert to anyone. I would be very surprised if there was a business anywhere that couldn’t become more efficient or save money with his help.
Craig Hutton, CarLeasing-Online.co.uk
Whilst many people have a basic understanding of how Excel can work it’s good to know that there is an ‘expert’ out there who really knows the ins and outs of the software. Carl is one of those people. I have sought Carl’s advice on a number of occasions and I now confidently refer him into my clients who need to work more intelligently as regards the data they manage and work with. Carl really is the Excel Expert.
Rob Warlow, Business Loan Services