Chapter PD: What’s New in Excel

September 14, 2019

Photo by: MillefloreImages / iStock / Getty Images Plus

How up to date is your knowledge of Excel’s newest features? Are you aware that we can have multiple people working in the same Excel workbook at the same time? That you can automate the refresh of data imports very easily? How about the fact that there are new data types – beyond just text and numbers – in Excel today?

Do you understand what Office 365 really is, and why you should never buy a 4 digit version of Office ever again? Microsoft has been investing heavily in Excel and the entire business intelligence suite of product.  In this session, participants will get an in depth look at Office 365, Excel 365’s newest features and how it will impact your workflow in the future.

Date:Saturday, September 14, 2019
Time:Registration & Buffet Breakfast: 8:00 am to 9:00 am | Speaker: 9.00 am to 12.00 pm
Location:Coast Langley City Hotel & Convention Centre, 20393 Fraser Hwy, Langley BC
Cost:$90+ GST (includes buffet breakfast)
CPD | Level:3 hours | General
Register:Click here


Ken Puls, FCPA, FCMA, has held the Certified Management Accountant (CMA) designation since 2000. In the corporate world in his dual role as an accountant and IT support, Ken was exposed to a vast array of business systems, including point-of-sale systems, databases, and analysis tools. In his career, Ken led the installation of over a dozen systems conversions and implementations of various types, as well as created a full business intelligence and budgeting system. None of this would have been possible without truly mastering Microsoft Excel.

Ken has also been an active participant in many web forums since 2002, and hosts a website at, which provides code samples for working with Excel, other Microsoft Office applications and free utilities. In fact, NASA has even made use of this site, using some of Ken’s PDFCreator examples to automate the production of PDF reports which monitor the power supply levels on the International Space Station.

In addition, his technology blog (where Ken shares much of his experimentation and observations of different technologies, particularly Power Query) can also be found at, and his free help forums can be found at recognition of his contributions to the online community, Ken has been awarded the prestigious Microsoft Most Valuable Professional (MVP) annually since 2006. 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 fewer than 4,000 active Microsoft MVPs and Ken is one of less than a dozen to do so in Canada.

In March of 2013, Ken was also recognized as one of the “Top 20 Under 40” Business and Community Leaders on Vancouver Island, and in November 2014, he was honoured as a Fellow in the CMA Society, a distinction given to less than 2% of CMAs in their lifetime.In addition to his other technical works, Ken is co-author of RibbonX – Customizing the Office 2007 Ribbon and M is for Data Monkey: The Excel Pro’s Definitive Guide to Power Query.

Ken decided to pursue a full-time career as an independent consultant with Excelguru Consulting Inc. in May 2015. Building on his experience teaching dozens of hands-on Excel training courses, (Beginning Excel, Building Spreadsheets That Last, Financial Modeling Techniques, Charting & Dashboarding, Introduction to VBA, Power Query and PowerPivot, to name just a few) Ken is now also offering his unique accounting and IT skillset to help interested businesses fix existing business intelligence models and design new ones..


Posted in pd Tagged with: ,