Microsoft Excel Programming for real world challenges

Lumen is an experienced developer and software consultant in all versions of Microsoft Excel.

MS Excel as part of Microsoft 365 is the world’s most powerful and widely used Spreadsheet software.  We have decades of experience using the platform, from it’s origins in the 1980s up to today’s cloud version.  However, many companies may not have the in-house experience in how to use vital components of Excel like Visual Basic (VBA).  


Lumen designs, develops and implements Excel automation and application development for SMBs and enterprise clients

Excel Programming experts in New Zealand, Australia or globally, We have the team that can find some surprising answers to your problems

Save time and money with advanced VBA functions

Excel allows you to automate almost anything, by using VBA programming. Lumen can automate repetitive tasks, and accomplish more with additional functionality.


Excel VBA can be used for many tasks, for example Sales Analysis, Forecasting, Graphics, Charting, Budgeting and much more. Your team can gather actionable information in a matter of seconds.

Easy to run macros

Eliminate human errors and allow even someone with no Excel experience to run perform tasks by running a macro.

Redeploy resources to high value functions

By automating common and repetitive keystrokes, your team can focus on more advanced tasks and on showcasing insights from the data.

Data Driven Decisions

With a modest investment, you can have an immediate productivity gain

Finance, Health, Manufacturing, Retail or any industry you desire, we will customise solutions for our Australian and New Zealand clients.  

We can also work with you in presenting your excel data in Power BI to deliver stunning interactive reports.

Excel programming expertise

Lumen is powered by automation, formulas and functions. Clients have trusted our software development agency for over 25 years.

"Whether you need Excel Programming in New Zealand, Australia or globally, Lumen have the team you need for getting the most out of Excel. With hundreds of happy clients, we work quickly and efficiently to maximise your investment"
Our principal consultant Ilan Gross
Ilan Gross
Principal Consultant
Microsoft Excel

Contact Lumen to discuss advanced Excel Programming

We work with businesses of all sizes to solves a wide range of problems.  If you are wondering how we can help you use technology to help your business perform better, please get in touch with us.

Find Us at the Office

17 Cockburn Street, Grey Lynn, Auckland 1021, New Zealand

Unleash Excel

Most businesses know how essential Microsoft Excel is to running their business. It is a piece of software than can be used to learn your patterns, organize your business data, and increase your efficiency. It is capable of performing powerful functions and in the process can make your company’s data meaningful.

That being said, even though Excel has been around since the 1980s, very few people know how to use it well enough to capitalize on the software’s potential.

To truly unlock the potential of Excel, a company needs to combine the skills of a financial analyst with that of a computer programmer. By bringing these two skill sets together more powerful spreadsheets can be made and run. The financial analyst can make sense of the financial dimension, while the programmer can build the spreadsheet with efficiency and skill.

Two key reasons for needing programming experience is firstly that of debugging, and second is database management.

Debugging can be a challenge that can prove fatal to many Excel projects. The is especially the case when dealing with large data sets. It is very easy to make a simple error in building a function Excel sheet that derails the entire project. From there, finding the problem and addressing it can prove to be a complex task. A programmer with some experience can prevent these bugs from arriving in the first place, and second, to address them effectively when they do arise.

As for data management, proper management of data with Excel is vital for maintaining the integrity of database. Without this it is difficult for the company to be able to trust the data.

At Lumen we provide comprehensive Excel programming services. By combing our financial and programming skill sets we can save your company large amounts of time and money.

To see how we can help your business use Excel, contact us now.

Click here to book a live demo

Ideal CRM Customer

If your business is looking to find productivity increase that drive revenue growth then Lumen can help you.  Click here to learn about whether you would benefit from our services.

The Lumen difference

Our methodology and holistic solutions have real world application, quick implementation, and proven results. To learn more about what makes Lumen unique click here.

Problems that we solve

You are not alone. Many other businesses are trying to solve issues such as how to intelligently increase productivity and boost customer retention. To discover more issues that we have to skills to solve click here