About me

Welcome to The Excel Factor

If you are here to find a solution for your business data and analytics, then you are at the right place.  We can help you with all things related to spreadsheeting.

Who I am

Hello, The Excel Factor is a small advanced Excel spreadsheet solutions and financial modelling business.  Very small!  In fact, its mainly just me, John Hackwood, a passionate Excel Financial Modelling Consultant & Excel Analyst .  My wife Nupur, a dentist and PhD sometimes works with me especially if the task is medical related, but she also is a clear ‘out of the box’ thinker and many times come up with a unique solution.

I have a strong finance & international resource marketing background after working many years in 3 of the world’s top 5 mining houses namely BHP, Anglo American and Rio Tinto (Comalco) as well as in the manufacturing sector much earlier in my career (Rheem Australia). 

I have a Bachelor of Business (Accountancy) degree from  QUT and a Graduate Diploma in Applied Finance and Investment from the Financial Services Institute of Australia (formerly the Securities Institute of Australia).  So I started my career as an accountant in manufacturing, then moved into resource commodity marketing reporting, export contract administration, trade finance and credit management roles.  

In 2001 I moved to Singapore with the then BHPBilliton to take on a Senior Credit Controller role for Carbon Steel Materials (coking coal, iron ore and manganese).   I of course used spreadsheets and Excel throughout this career, in fact that’s an understatement, using Excel was like breathing, just ‘part and parcel’ of my job day in day out.

We returned to the Redlands in 2004 and then my wife Nupur, a Dentist, by this time wanted to own her own dental practice which we did in 2005 starting small with a one chair in Redland Bay and growing this to a very busy and successful 4 chair practice.   I moved into this our own business in 2008 full time and due to a lack of systems turned to advanced Excel and especially VBA and pivot tables to gain efficiencies and functionality expensive dental software just did not have.  I started The Excel Factor in 2010 working for companies as a contractor and also HR hire firms to gain experience doing work I loved.

We sold our practice in 2016 and I have continued on with The Excel Factor business and my wife helps me on certain jobs especially if dental or medical related and she also designed and built this website.

I am a Queenslander, although these days live just over the border in the fantastic Tweed Shire NSW.  I work with clients from all over Australia with many typically being located on the Gold Coast, Yatala, Logan and Brisbane, QLD Australia as well as Far North Coast NSW clients in on the Tweed Coast and Lismore NSW and even some companies overseas.

There is some more detail about my earlier resources marketing career at my Credit Management & Trade Finance page.

What I do

I do advanced Excel spreadsheeting including Excel VBA / macros, Excel Power Query and all the other advanced tools outlined in my site for mainly local Australian businesses large and small.  I have been doing this work as a contractor under my The Excel Factor business name since 2010.   

I work as a contractor under my simple terms sheet and depending on the complexity of the job on an hourly basis with a reliable estimate or fixed price if the client requires this and this is feasible.

I do nearly all my Excel work from my  home office but outside of Covid times I have visited clients for meetings on large projects.  Really happy the business world embraced MS Teams and Zoom as I find for Excel spreadsheet work this is actually a more effective meeting.

Tabs VBA 

Why I do

Excel work is fun for me.   I love what I do, happy to stay small and work from home wherever I can. 

I can help you get a handle on your business financial modelling projects, reporting and spreadsheet problems or Excel automation for admin task or Excel data projects quickly.  

I love helping people solve problems and increase their effectiveness and productivity with what I know works so well.

Who we are

I also work at times with my wife Nupur, a dentist and the designer of my website and she has a Dental Training & Consulting business under the business name Just Excel.

John in purple shirt

John Hackwood

Chief Excel Officer - CEO

Dr Nupur Hackwood

Nupur Hackwood

What's Higher than a CEO?

A little spreadsheet history...

Lotus 123

 

Anyone interested in a little spreadsheet history might enjoy my blog post that has Dan Bricklin’s TED Talk who along with along with Bob Frankston were the creators of VisiCalc in 1979.   Before Visicalc there was no spreadsheet except the paper kind  to the right where most of the effort went into the calculating not the thinking behind the numbers.  It’s easy to forget the imagination these guys had to envisage such a revolutionary idea now taken for granted by 600 million people.   If you were making a list of the top 20 inventions of the 20th Century I reckon Visicalc should be there.

At 6:05 in this video Dan Bricklin says “The act of making a simple, working version of what you are trying to build forces you to uncover key problems.  And lets you find solutions to those problems much less expensively.”  He was talking about the benefit of using an electronic spreadsheet – refining your thinking about what you are modelling not just the output itself.

Visicalc was the first commercially successful spreadsheet then and of course the world still had the even more successful Lotus 123 to embrace for about 10 years before Microsoft saw that Lotus 123 was being improved much and so a better featured Excel became the world’s spreadsheet.

To be honest, I have been doing spreadsheeting a very long time, using Lotus 123 and 20/20 (a mainframe spreadsheet) and I was so hooked on these tools I would come to work on Saturdays to play around and learn them as there were no home PCs in those days.   But it was just so much damn fun compared to the tedium of handwritten spreadsheets and a tape calculator when calculating stock take values or the monthly result and volume, price and mix variances for a manufacturer (Rheem) that I worked for. 

So this love for spreadsheeting came from kind of growing up with them and I think I gained a deep understanding along the way and loved them for the tedious work they replaced that otherwise could have been the way I spent my days.   Even so, don’t think I haven’t kept up.   I love the latest Office 365 version, the new Power Query, PowerPivot, Power BI and Dynamic Array formula enhancements and I am very quick to dump old ways for new.

Recent Courses and Seminars

Power Query Academy Advanced

2021, Skillwave (Ken Puls / Miguel Escobar / Matt Allington)

Online Course

Power Query Academy Fundamentals

2020, Skillwave (Ken Puls / Miguel Escobar)

Online Course

Building BI with Modern Excel

2019,MVP Ken Puls XLGuru

Wellington, New Zealand

Unlock Excel
Course

2017, Ken, Puls, Roger Govier, Jon Peltier

Brisbane, Australia

MS Access to Advanced Level

2016, Richard Rost

Online Course

The Excel Summit South

2016, Charles Williams including Bill Jelen, Ken Puls

MS Dev Team

Power Pivot and Power Query

2014, Matt Allington

Online Course

VBA Programming

2012, MVP Chandoo

Online Course

Some Numbers...

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!

1
Years doing advanced Excel work for Clients
1
Satisfied Clients
1
Tasks & Projects Completed