About us
We are a group of Power BI and Modern Excel enthusiasts. This group is dedicated to running monthly meetings to share techniques and inspire incredible data analytics and dashboards using Power BI and the Modern Excel tools (Power Pivot and Power Query).
View recordings of past meet-ups on YouTube: https://www.youtube.com/playlist?list=PLIRJFbuwYskLKHIWt9OBVpeMs-NZ_jvS_
Interested in Presenting?
Do you have a topic you’d like to share with the group? We are always looking for people to speak at upcoming meet-ups, and love to hear about the projects you are working on! If you are interested, fill out our online form: https://xlguru.ca/speakatvanpug
Upcoming events
2
How to Split Without Making a Mess | Melissa de Korte
·OnlineOnlineSESSION TRACK:
Power BI & ExcelSESSION 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).
95 attendees
Stunning Reports. Smarter Workflows. | Jakob Nielsen
·OnlineOnlineSESSION TRACK:
ExcelSESSION OUTLINE:
We're excited to have Jakob Nielsen (a member of Microsoft's Excel design team) presenting the second in his series of 3 sessions for us!Formatting the same report repeatedly is a time sink, especially when the data changes. In this session, we’ll take a deep dive into Flow, an Excel add‑in by Make Digital Solutions (https://bit.ly/flowaddin) that automates layout and styling so you can produce dynamic, visually compelling reports without repetitive formatting work.
We’ll walk through practical patterns for building consistent outputs such as dashboards, heat maps, calendars, timelines, and product catalogs, and show how Flow helps keep results polished and consistent as your data updates.
Stay tuned for Jakob's third presentation at the end of the year!
SPEAKER PROFILE:
Jakob Nielsen is passionate about helping people become more productive and achieve better results with spreadsheets. He is the founder and CEO of Make Digital Solutions ApS and a Principal Designer in the Excel team at Microsoft.Connect with and follow Jakob online at:
- Email: jakob@makedigitalsolutions.dk
- LinkedIn: https://www.linkedin.com/company/makedigitalsolutions
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-10:05am Feature Presentation
- 10:05am-10:10am 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 day 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.
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).
54 attendees
Past events
177
