Excel Toronto Meetup - How to use the FILTER function for Dynamic Reports in Excel - Mike Thomas скачать в хорошем качестве

Excel Toronto Meetup - How to use the FILTER function for Dynamic Reports in Excel - Mike Thomas

The MS Excel Toronto Meetup group was founded in May 2019 and has had monthly sessions since then. Sessions are currently offered for free online, with a different topic presented by an Excel Expert each month. Members are from all over the world, totaling more than 4,000. ATTEND THE MS EXCEL TORONTO MEETUP GROUP SESSIONS LIVE 👇 Register for free as a member of the group: https://www.meetup.com/MSExcelToronto Thank you to Sheetcast for sponsoring the MS Excel Toronto. Sheetcast allows you to build web applications with Excel. Small teams can use it for FREE. https://sheetcast.com ACCESS THE EXERCISE FILES shared by the presenter available to the group members in the discussions area on Meetup. The MS Excel Toronto Meetup group sessions are organized and run by Celia Alves -   / celiajordaoalves   Gráinne Dugan -   / grainneduggan1   Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscrib... Learn how to automate your Excel reports – FREE Masterclass here: https://snapreportschamp.com/course About this session: Session Title: How to use the FILTER function for Dynamic Reports in Excel | Mike Thomas Session recorded live on February 12, 2025 SESSION DETAILS This session explores one of Excel's most versatile tools: the FILTER function. Designed for intermediate users, this presentation demonstrates how to extract, organize, and analyze data dynamically, saving you time and effort while enhancing your productivity. Whether you’re managing large datasets or simply want a smarter way to retrieve information, the FILTER function is a game-changer. Discover practical examples, learn how to handle errors effectively, and see how this function can integrate seamlessly with others to take your Excel skills to the next level. Don’t miss this opportunity to unlock the true potential of dynamic data filtering in Excel! ABOUT THE SPEAKER Mike Thomas is a leading UK-based IT Trainer and Content Creator renowned for his expertise in Microsoft Office, particularly Excel and Power BI. Throughout his distinguished 35-year career, Mike has delivered thousands of courses and produced an extensive library of written and video tutorials, available on his blog and YouTube channel. As a Microsoft MVP and Fellow of The Learning and Performance Institute, Mike has collaborated with numerous global and UK-based companies, providing tailored training and developing innovative Microsoft Office solutions that streamline business processes. His passion for teaching, knowledge-sharing and technology makes him a sought-after speaker and trainer, continually inspiring others to harness the full potential of Microsoft Office tools. Find more about Mike's work and connect with him: Website: https://theexceltrainer.co.uk LinkedIn:   / thomasmik   YouTube: https://theexceltrainer.co.uk/youtube Timestamps: 00:00:00 Celia Alves MS Excel Toronto news and upcoming events 00:09:20 Celia Introduces Mike Thomas 00:11:07 Mike Thomas introduces the FILTER function, explaining its basics, syntax and uses, filter data based on specific criteria 00:19:20 Multiple FILTER functions on the same sheet, handling spill errors, examples of filtering data with data validation lists, manage multiple filters effectively. 00:24:50 Filter guest lists based on table assignments, with RIGHT function 00:27:25 Separate credits and debits from a list of transactions, find the top three highest Credit using FILTER with CHOOSECOLS, CHOOSEROWS and SORT 00:36:55 Filter data based on multiple conditions using logical operators (AND, OR), combine functions such as SORT, CHOOSECOLS, and TAKE to create more complex filters and extract specific data, filter data that is not in a table 00:43:00 Combine FILTER with VSTACK to summarize data across multiple sheets and remove blank rows 00:49:20 Questions: discussion about additional use cases, best practices, and new Excel functions like TRIMRANGE. Wrap up