Excel Toronto Meetup -Pivot Tables With Excel, Dynamic Array, Power Query, Python - Bill Jelen

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 - https://www.linkedin.com/in/celiajordaoalves/ Gráinne Dugan - https://www.linkedin.com/in/grainneduggan1/ Keep up with the Excel News by subscribing to Celia’s newsletter: https://snapreportschamp.com/subscribenewsletter Learn how to automate your Excel reports – FREE Masterclass here: https://snapreportschamp.com/course About this session: Session Title: Pivot Tables with Excel, Dynamic Array, Power Query, Python & Copilot|Bill Jelen Session recorded live on April 16th, 2025 SESSION DETAILS When Lotus Improv brought the concept of pivot tables to the spreadsheet world, it was seen as ground-breaking. Today, we still have pivot tables in Excel, but also the ability to create cross-tab reports with Dynamic Arrays, Power Query, Python, and Copilot. Take a tour through the various methods available and why you might want to use one over the other. 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/ YouTube: https://www.youtube.com/@MrXL Twitter: https://x.com/MrExcel Instagram: https://www.instagram.com/mrexcelbill/ Facebook: https://www.facebook.com/MrExcelSpeaker