Ken is one of the world’s leading experts in Microsoft Excel, Power BI, Power Query, Power Pivot, Data Platform, master of VBA programming, and financial modeling, Data cleansing and reshaping specialist.

The president of Excelguru Consulting Inc., blogger, author, and trainer with over 20 years of experience. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them.

His website hosts a large knowledge base of help articles, a blog, and an active forum dedicated to helping users with their Excel and Power BI issues.

A distinguished 18-time Microsoft MVP, Ken has been recognized every year since 2006 for his exceptional contributions to the Microsoft community. His accolades include being named one of Vancouver’s “Top 20 Under 40” Business and Community Leaders in 2013, a testament to his impact both professionally and socially.

Ken has spent many years providing both public and private training, speaking at conferences and events around the world, and running the Vancouver Power BI and Modern Excel User Group.

In 2020, Ken co-founded Skillwave Training, a leading platform dedicated to delivering top-tier online courses on topics such as Power Query, Power BI, Excel, Power Pivot, and Dimensional Modeling. Through this initiative, he has reached thousands of learners worldwide, equipping them with the skills needed to thrive in the data-driven economy.

Ken is also a prolific author, having co-written several influential books, including “RibbonX – Customizing the Office 2007 Ribbon”, “M is for (Data) Monkey: The Excel Pro’s Definitive Guide to Power Query”, and its highly acclaimed second edition, “Master Your Data with Excel and Power BI”. These works are celebrated as essential reading for data professionals looking to elevate their expertise.

Beyond his professional endeavors, Ken remains dedicated to inspiring and empowering others, driven by his unwavering passion for turning data into actionable knowledge.

Ken Conference topic:

Automating Excel Without Code

Automating repetitive tasks in Excel can certainly be done using VBA or Office Scripts, but with so many companies blocking these technologies, is there a way to accomplish automation without using these languages? Join Ken as he looks at a real-world example, showing how he’s been able to eliminate the manual steps in 95% of his solution using native Excel functionality, without writing (or recording) a single line of code.