Upping Your Excel Efficiency Game | Ken Puls

SESSION TRACK:
Excel

SESSION OUTLINE:
Tired of hunting through old workbooks or a messy Notepad file for that formula, query, or DAX measure you know you've written before? Join us for a practical look at speeding up the parts of Excel that usually eat your time - without leveraging AI.

Some of the items Ken Puls will cover in this session:

• Never lose a formula again - build a searchable personal library of your go-to Excel LAMBDAs, Power Queries, DAX measures, and more, complete with smart prompts so you can drop them into any workbook in seconds
• Instant formula indentation - a keyboard shortcut that turns a wall-of-text formula into something readable, on demand
• LET-ify your formulas instantly - turn a long, repetitive formula into a clean LET version automatically, no manual rewriting required
• Name it as you make it - create Tables, Named Ranges, or Dynamic Array names right at the moment of creation, instead of renaming after the fact and breaking your Power Query in the process

From formula writers to Power Query builders to data modelers, there's something here to speed up your everyday Excel work.
Whether you're a Power Query devotee or still living in formula-land, you'll walk away with practical techniques to speed up your everyday Excel work.

SPEAKER PROFILE:
Ken Puls, FCPA, FCMA, is the president of Excelguru Consulting Inc, a company dedicated to helping users get the most from their data. His passion lies in exploring tools to turn data into information, and teaching others how to benefit from them. Ken is a blogger, author and trainer with over 20 years of corporate accounting and IT experience. He is one of the world’s leading experts in Microsoft Excel, Power Query and Power BI, and provides live and online training to clients around the world, including on the Skillwave Training learning platform that he co-founded in 2020.

In recognition of his contributions, Ken has held the prestigious Microsoft MVP distinction since 2006 in both the Excel and Data Platform categories. He was a Global Excel Awards finalist for Training Provider of the Year in 2026 and for Best Excel Add-in in 2025 and 2026.

Connect with and follow Ken online at:

• Excelguru Website: excelguru.ca
• Skillwave Training Website: skillwave.training
• LinkedIn: https://ca.linkedin.com/in/kenpuls and https://www.linkedin.com/company/excelguruconsulting/
• Bluesky: [@xlguru.bsky.social](https://bsky.app/profile/xlguru.bsky.social)
• Facebook: @xlguru

TENTATIVE AGENDA (subject to change, all times listed are in Pacific Time):

• 8:45am Teams Meeting opens to attendees to begin joining
• 9:00am-9:05am Welcome and Meeting Overview
• 9:05am-9:20am What's New in Power BI
• 9:20am-10:20am Feature Presentation
• 10:20am-10:25am Meeting Wrap-up

REGISTRATION:
This meet-up will be hosted on Microsoft Teams, and will be recorded to share with others who were not able to attend live. You must RSVP for the event in order to access the Teams Meeting link.

JOINING THE EVENT:
Attendees can join the Teams Meeting starting at 8:45am on the night of the event. The link will be visible only if you RSVP beforehand.

Once the event gets underway at 9:00am, we ask that attendees make sure they are on MUTE, so background noise and distractions are minimized.

During the presentation, attendees can type questions and comments into the chat area, which will be monitored by the event hosts. There will be time for Q&A at the end, where attendees can un-mute their mic and even share their video to ask questions.

**NOTE: As mentioned above, this event will be recorded and shared online, so attendee information may be visible in the recording.