Hire Excel expert in Australia to solve your business Excel spreadsheet problems
Automate, clean, organise, & visualise data easily. Reduce stress, get home earlier, enjoy life more!
Looking for professional Excel based spreadsheet solutions or services for your business?
I am a local Excel expert helping Australian businesses large & small with their Excel spreadsheet problems & Excel based processes, automation projects, data cleaning & analysis, reporting, you name it! I use powerful modern advanced Excel functionality such as macros or VBA programing, Power Query, PowerPivot, Pivot Tables , advanced formulas & charts.
Hi I am John Hackwood
Excel expert solutions in Business
The art of spreadsheeting
I am a local Excel expert, based near the Gold Coast QLD and Northern NSW, providing businesses (large and small) from all across Australia, with solutions to their Excel spreadsheet problems and projects.
This often involves automation, data cleaning & analysis, reporting, you name it! I use powerful modern advanced Excel functionality such as macros or VBA programing, Power Query, PowerPivot, Pivot Tables , advanced formulas & charts. Sometimes even Google sheets.
Organize data in such a way that formulas are simpler, data can more easily be re-used, sliced and diced and able to be summarized in powerful tools like Pivot Tables, PowerPivot and Power BI. Excel solutions are used through out business large and small because they work, can deliver what people need to do their jobs, can be implemented quickly and can be tailored to your business. These days modern Excel from Office 365 especially in the hands of an Excel Expert is surprisingly powerful.
My clients have come from varied industries
So far my valued clients seeking help with their spreadsheets come from industries such as Energy Retailer, Civil Engineering, Engineering, Property Development, Chartered Accounting, Hospitality, Mining, Agricultural Laboratory, Horse Racing, Building, Programmed Maintenance, Boutique Beer, Veterinary, Electrical Contracting, Dental, Laboratory, Solar, Oil Exploration, Drilling
I always appreciate the trust clients place in me
How my Excel expertise has helped clients
The humble spreadsheet actually has many powerful features...
Advanced Excel tools an Excel expert uses
Some of my recent blog posts ...
So in my previous post I was banging on about the new Dynamic Array formulas only fairly recently released to Office 365 Excel. I reckon
Here is a quick but really useful coffee break dynamic sum formula tip. I used this handy INDEX + MATCH based formula the other day
Here is a little demo on a great way to place macro buttons out of the way
I have been doing this work since 2010 part time and this full time since 2016. By now I have seen a wide variety of Excel situations & challenges to solve!