Part of Data Analysis, Business Modelling and Automation - 1 group

MS Excel Toronto

North York, ON, CA

5,746 members · Public group

Organized by Alves, Celia and 2 others

What we’re about

Do you love to work with Excel? Or maybe you are just looking to learn what you need to do better at work or apply for a new job. In either case, this group is for you.
Because it is impossible for any of us to know everything about Excel, this group is meant to be a space for sharing what we know with each other. In each session, we bring a guest to tell us about their best tips, tricks, techniques, and thoughts about an Excel-related topic. We are very proud of the amazing content that we have delivered to our Group Members so far.

Registration as a member has no cost, and all the sessions are FREE.

We are running two different session series to address everyone's needs.

EXCEL ESSENTIALS: focusing on essential functions and features, fundamental core concepts for data analysis, and practical tips for everyday use.
This series will offer shorter sessions delivered by Excel Trainers, Power Users, and Experts to help you build your foundational Excel skills and become a stronger and more confident Excel user.

Presentation time: about 30 minutes
Total session duration: about 60 minutes

EXCEL EXPANDED: because Excel keeps evolving and expanding in so many directions and can integrate with so many different technologies, we will continue to invite the best experts in the world to share their knowledge and best tips with us, leading us to expand our Excel skills and understanding of what Excel can do.
These sessions will follow our usual format.

Presentation time: 45-60 minutes
Total session duration: about 90 minutes

Anyone can attend any of the sessions by clicking a link provided to those who register (RSVP Yes) for the session.

Sessions are currently happening online through Microsoft Teams. There is no need to install Microsoft Teams. You can use your browser on your computer or mobile device to join the session.

We would love to hear what you have been up to with Excel. What kind of problems do you solve with it? What kind of solutions do you build with it? What are your favourite techniques, features and tools? What is your advice about best practices for working with Excel?

If you want to learn more about using Excel to your maximum potential, this group is for you. Let's all get together to connect and learn from each other.

VIDEO RECORDINGS:
The session video recordings are made available a few days after the session on the YouTube channel MS Excel Toronto Meetup - YouTube.

ACCESS TO EXERCISE FILES:
You can access the exercise for any previous session by going to "DISCUSSIONS" and finding a post there with the link to a shared folder.

A SPECIAL THANK YOU to our lead sponsor - Sheetcast - for covering the administrative fees to run the MS Excel Toronto meetup group on this platform.

A SPECIAL THANK YOU to our volunteers Antony Pihut, Licínia Isabel Marques, Phil Roth and Valeriia Esaulenko

STAY ON TOP OF ALL THE EXCEL NEWS:
Subscribe to the most comprehensive newsletter about the Excel world: snapreportschamp.com/subscribenewsletter.

CHECK THE DISCUSSIONS AREA FOR PERKS AND DEALS
You need to log in as a member first to access this information.

Upcoming events (2)

See all

Wed, Jul 9, 2025, 9:30 PM UTCDynamic Arrays in Action: Transform Your Excel Workflow | Jakob Nielsen
Link visible for attendees
SESSION DETAILS

Join Jakob Nielsen for a hands-on session exploring how dynamic arrays are reshaping the way we work with data in Excel. You’ll learn how functions like FILTER, UNIQUE, and SEQUENCE can simplify your formulas, reduce errors, and make your spreadsheets more responsive. Whether you're building dashboards or cleaning up data, this session will show you how to work smarter with modern Excel tools.
A brief look at the Flow add-in will also demonstrate how to enhance your reports with dynamic layouts and formatting.

ABOUT THE SPEAKER

Jakob 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.

Find more about Jakob's work and connect with him:
Website: https://www.makedigitalsolutions.dk/
LinkedIn: https://www.linkedin.com/in/jakobnielsen/
https://www.linkedin.com/company/makedigitalsolutions

AGENDA (Eastern Time)
5:30 PM - 5:45 PM - Introduction by Celia Alves
5:45 PM - 6:45 PM - "Dynamic Arrays in Action: Transform Your Excel Workflow" by Jakob Nielsen
6:45 PM - 7:00 PM - Q&A + Closing by Celia Alves

REGISTRATION
This session will be hosted on Microsoft Teams and recorded to share with others who could not attend live. You must register for the event to access the Teams Meeting link, which will become visible after you RSVP Yes.

JOINING THE EVENT
The link will be visible only if you RSVP beforehand.
During the speaker's presentation, we ask that attendees ensure they are on MUTE to avoid background noise and distractions.
Attendees can type questions and comments into the chat, which will be monitored by the event hosts.
At the end, there will be time for Q&A, where attendees can unmute their mic and even share their video to ask questions.

**NOTE: As mentioned, this event will be recorded and shared on YouTube and other social media platforms; therefore, attendee information may be visible in the recording.

We are looking forward to meeting you there!

A SPECIAL THANK YOU note to our lead sponsor: Sheetcast
156 attendees+151
Wed, Jul 23, 2025, 9:30 PM UTCYour Manager Thinks You Already Know These Excel Features | Bill Jelen
Link visible for attendees
SESSION DETAILS

In an August 2021 comic, XKCD noted that “even when trying to compensate for it, experts in anything wildly overestimated the average person’s familiarity with anything in their field.” In this 30-minute session, Bill Jelen will cover 7-10 basic but important concepts that you might not know about Excel. Possible topics:

Absolute vs. Relative References $A$1 versus A1.

Slicers to quickly filter

Goal Seek to back into an answer

Flash Fill to Clean Data

DATEDIF hidden function to calculate the difference between dates

Number formatting - both in formulas with TEXT and custom number formatting in cells

Summarize Data using an English sentence

And more!

ABOUT THE SPEAKER

Bill Jelen is the host of MrExcel.com on YouTube and the author of 69 books about Microsoft Excel including “Excel Gurus Gone Wild”, “Excel 2019 Inside Out” and “Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot.”

He was an ESPN commentator for the World Excel Championships, has made over 80 guest appearances on TV's Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show.
He writes the Excel column for Strategic Finance magazine and has produced over 2500 episodes of his video podcast Learn Excel from MrExcel.

Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company.
For all his contributions to the Excel community, Bill has been awarded Excel MVP for the past 20 years.

Find more about Bill's work and connect with him:

Website: https://www.mrexcel.com/
LinkedIn: https://www.linkedin.com/in/billjelen/
Facebook: https://www.facebook.com/MrExcelSpeaker
YouTube: https://www.youtube.com/@MrXL
Twitter: https://x.com/MrExcel
New Book: https://www.amazon.ca/Microsoft-Crunching-Including-Dynamic-Business-ebook/dp/B0DNQ3TZKT/

AGENDA (Eastern Time)
5:30 PM - 5:45 PM - Introduction by Celia Alves
5:45PM - 6:15 PM - "Your Manager Thinks You Already Know These Excel Features" by Bill Jelen
6:15PM - 6:30 PM - Q&A + Closing by Celia Alves
REGISTRATION
This session will be hosted on Microsoft Teams and recorded to share with others who could not attend live. You must register for the event to access the Teams Meeting link, which will become visible after you RSVP Yes.

JOINING THE EVENT
The link will be visible only if you RSVP beforehand.
During the speaker's presentation, we ask that attendees ensure they are on MUTE to avoid background noise and distractions.
Attendees can type questions and comments into the chat, which will be monitored by the event hosts.
At the end, there will be time for Q&A, where attendees can unmute their mic and even share their video to ask questions.

**NOTE: As mentioned, this event will be recorded and shared on YouTube and other social media platforms; therefore, attendee information may be visible in the recording.

We are looking forward to meeting you there!

A SPECIAL THANK YOU note to our lead sponsor: Sheetcast
117 attendees+112