ExcelGuru.ca is run by Ken Puls, CMA. I'm a Certified Management Accountant, who never remembers life without spreadsheets and computers.

Since mid 1999, my career has been spent in the hospitality and tourism industry, in the finance and IT field. Starting as the Accounting Supervisor and Systems Administrator at Fairwinds Community & Resort on Vancouver Island, BC, I was promoted to Controller/Director of IT in September 2007. To this day, I dedicate a significant portion of my time to developing automated solutions and internal controls for the golf course, 400 berth marina, and two food and beverage outlets that make up the resort, as well as focusing time and energy on improving the Business Intelligence systems that run our real estate development. During this time, I've found that my true passion is designing and developing new systems, using such technology as Excel spreadsheets, databases built with Microsoft Access, and Palm technology for taking inventory.

When I first started at the resort in 1999, the Microsoft Office systems in the resort were all upgraded to Office 97, and my users panicked as the "macros" that the resort used all stopped working. I passed the problem to the head office's IT department head in Toronto, and had to explain what they did, step by step. As it turned out, the resort's users weren't using macros at all, but rather had memorized the lotus keystrokes to copy and paste instead of using a mouse! In July of 1999, the IT department sent me a file that actually did use a macro, built by a summer student.

As happens with summer students, this one went back to school, and then it became necessary to change something. Being the only systems oriented individual in the company who knew Excel at all, (even the head office didn't have anyone at that point,) I got nominated to fix the macro. After a bit of experimentation, I managed to fix it, and then basically just updated the file whenever it needed it.

In early 2001, I began recording simple macros, mainly just to copy closing balances to opening balance columns and clear out data entry fields. This continued in until late 2002.

In the fall of 2002, the resort's management company decided to cut labour costs in the administration department. Overall, 2.5 full time equivalent positions were cut out of a 7.5 person office (yes 33% of the labour used) within one month, with the department expected to produce the same amount and quality of work. (As an added complication, due to the management company being absorbed into another in early 2002, the Resort's IT department had become a one man show -- me!) During a desperate shuffle of tasks to other departments, and dropping of tasks that were low priority, I realized that automation was going to be the only answer.

From there, I launched himself into VBA (Excel's programming language) full force. Automating as many tasks as possible, the administration office has been able to perform virtually the same task load as before the cuts, and the annual labour savings can be estimated somewhere between $20,000 and $40,000 per year. Suffice it to say, I loves VBA, and is still amazed by the things it can do.

I live my business life automating as many of my, my staff's, and my co-workers tasks, so that they can focus on what is truly important: Running the business. I am a firm believer that properly set up, a computer can process numbers and data far more efficiently and accurately than any human, and that human brainpower should be devoted to solving problems, not data input.

I volunteer at several online forums, as well as brainsharing with friends and colleagues from around the world.

If you'd like to know more about where my past experiences come from, as well as read up on some of my accolades, check my "Experience & Accolades" page.