VanPUG - Vancouver Power BI & Modern Excel User Group

Practical AI for Excel: Real-World Use Cases | Fay Bordbar

Thu, Sep 3 · 9:00 AM PDT

·

Online

Online

SESSION TRACK:
Excel

SESSION OUTLINE:
AI is changing the way we work with data — but where does it actually fit alongside Excel? In this session, Fay Bordbar will walk us through practical, real-world use cases where AI tools and Excel work together, from speeding up everyday tasks to tackling problems that used to feel out of reach. You'll leave with concrete ideas you can apply straight away, whatever your current Excel level.

SPEAKER PROFILE:
Fay Bordbar is a digital skills trainer, passionate about building skills for the future. Fay trained and studied for her ACA at Deloitte, working predominantly in audit analytics. When she was challenged to recreate some SQL scripts in Excel, she realised how much she didn't know about Excel, which motivated her to learn more and her enthusiasm for Excel started there!
Now, as Managing Director of Excellence AI, Fay takes that mission further. Excellence AI delivers future-ready corporate training in Excel, AI Literacy, and AI tools such as Copilot and Claude, helping teams build the technical skills they need in an AI-ready world.
Outside of work, Fay co-hosts the Global Excel Summit and is co-founder of Excel on the Road, a community bringing in-person Excel events to people across the world. You can follow the journey and pick up training content along the way on Substack, Instagram, and LinkedIn, @ExcelOnTheRoad.
Fay's goal remains the same as it always has been: give people the confidence and capability to solve their own challenges, and keep building from there.

Connect with and follow Fay online at:

• LinkedIn: https://www.linkedin.com/in/fay-bordbar-396280a3/
• Website: www.excellenceai.co.uk

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.

How to Split Without Making a Mess | Melissa de Korte

Thu, Sep 17 · 12:00 PM PDT

·

Online

Online

SESSION TRACK:
Power BI & Excel

SESSION OUTLINE:
Joseph Yeates will start things off by showing us some of the latest and greatest in Power BI. Then, Microsoft MVP Melissa de Korte will explore cool ways to split our data. Power Query has a family of splitter functions built for text problems that go beyond a simple Split Column transformation. You can split text by much more than a comma or a space. Splitters can work with changing delimiters, character transitions, lengths, positions, ranges and other patterns. In this session, we'll use some of these functions to solve practical problems.

SPEAKER PROFILE:
Melissa de Korte is a Microsoft MVP, Community Super User, speaker, and co-author of The Definitive Guide to Power Query (M). She shares Power Query tutorials and M explanations on YouTube that help Excel and Power BI users solve data challenges and develop a stronger understanding of M.

Connect with Melissa:

• LinkedIn: https://www.linkedin.com/in/melissa-de-korte-64585884/
• YouTube: https://www.youtube.com/@melissa_de_korte/
• GitHub: https://gist.github.com/m-dekorte
• Book: https://www.amazon.com/Definitive-Guide-Power-Query-Transformation/dp/1835089720/

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

• 11:45am Teams Meeting opens to attendees to begin joining
• 12:00pm-12:05pm Welcome and Meeting Overview
• 12:05pm-12:20pm What's New in Power BI
• 12:20pm-1:20pm Feature Presentation
• 1:20pm-1:25pm 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 11:45am on the day of the event. The link will be visible only if you RSVP beforehand.

Once the event gets underway at 12:00pm, 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.

A link to the recording will be posted here on the event page and on the Excelguru social media channels once it is available (usually a day or 2 after the event).