• About Us RSS Feed

    by Published on 2011-08-26 05:14 AM     Number of Views: 276972 

    ExcelGuru.ca is run by Ken Puls, FCPA, FCMA. 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 hand-held scanner technologies 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 of my own, 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 myself 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 love VBA, and am 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've been an active participant in many Web forums since 2002, and built this website, which provides code samples for working with Excel, other Microsoft Office applications, as well as some free utilities. (In fact, NASA has even made use of this site, using some of my PDFCreator examples to automate the production of PDF reports which monitor the power supply levels on the International Space Station!)

    This site also hosts my technology blog where I share much of my experimentation and observations of different technologies.

    In recognition of my contributions to the online community, I was awarded the prestigious Microsoft Most Valuable Professional – Excel award in October 2006; a distinction I holds to this day (I was awarded in the Data Platform category in 2017). The Microsoft MVP Award recognizes exceptional technical community leaders from around the world who voluntarily share their high quality, real world expertise with others. In Microsoft's words, "MVPs are a highly select group of experts representing technology's best and brightest who share a deep commitment to community and a willingness to help others." Worldwide, there are over 100 million participants in technical communities; of these participants, there are fewer than 4,000 active Microsoft MVPs. Of this pool of MVP's, less than 200 hold the distinction of MVP-Excel globally, and I am one of less than a dozen to do so in Canada.

    In addition to my other technical works, I am also co-author of RibbonX – Customizing the Office 2007 Ribbon, published by Wiley Publishing, Inc. This book is the definitive guide for all users who wish to put their own touch on Office 2007's new user interface, providing clear step by step instructions and examples of the code required to manipulate the RibbonX API.

    I've also worked as a freelance Microsoft Office developer, and completed many consulting projects, mainly in Excel, but also with Access, Word, and Outlook. While consulting offered many great learning opportunities and challenges, I have changed my focus to concentrate on my true passion – sharing my knowledge about Excel, and teaching people how to get the most from it.

    To this end, I opened up my own web forum and also lead Excel training sessions for those companies or groups interested in having a live instructor with courseware customized to their attendees.

    I take a lot of pride in filling this site with accurate and helpful content, and hope you find it useful for your needs. And if you can't find the exact answer to the question you have, don't hesitate to drop by the forum for help. It's completley free!

    by Published on 2011-11-02 06:31 AM     Number of Views: 40195 

    I am quite grateful for all the great feedback I've received from my many years in the community working on projects and training. Below are a few excerpts/quotes from some of my particular favourites.

    NASA - International Space Station Power Systems

    • The team has created a tool that takes their analysis info and puts it all into excel. This has allowed them to chart their information, making


    by Published on 2006-09-30 07:04 AM     Number of Views: 36680 

    Microsoft MVP
    Data Platform (2017)
    Excel (2006-2016)

    One of the biggest honours I've received is to be awarded the Microsoft MVP award for Excel

    The following quote best explains the MVP award:
    Quote Originally Posted by Rich Kaplan and Sean O'Driscoll of Microsoft
    The Microsoft Most Valuable Professional (MVP) Program recognizes and thanks outstanding members of technical communities for their community participation and willingness to help others. The program celebrates the most active community members from around the world who provide invaluable online and offline expertise that enriches the community experience and makes a difference in technical communities featuring Microsoft products.
    MVPs are credible, technology experts from around the world who inspire others to learn and grow through active technical community participation. While MVPs come from many backgrounds and a wide range of technical communities, they share a passion for technology and a demonstrated willingness to help others. MVPs do this through the books and articles they author; the Web sites they manage; the blogs they maintain; the
    by Published on 2017-10-30 08:41 PM

    Excelguru Privacy Policy

    1. What information do we collect and what do we do with it?
    We collect the personal information you give us, including your name and email address, as part of the registration process when you subscribe to our newsletter email list, enroll as a student or subscriber to one of our courses, and/or email us directly with a question or comment.

    Email Marketing:
    If you subscribed to our email list, we may send you emails about our monthly newsletter, our site, current or new courses, or other information that we think may be of interest to you.

    If you registered for one of our courses, we may send you emails about our site and related course(s), registration, course content, your course progress, or other updates. We may also use ...
    by Published on 2018-06-06 12:00 AM


    This site, excelguru.ca, and all its sub-areas (“Website”) is owned and operated Excelguru Consulting Inc. Excelguru makes no representation or warranty that the information displayed on the website is appropriate or available for use in other jurisdictions.

    Intellectual Property Rights ...