Pivot Tables with Excel, Dynamic Array, Power Query, Python & Copilot|Bill Jelen

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.

🎁 GIFT ALERT: Bill Jelen will be giving away two digital copies of his new book "Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot" to two of his live session lucky attendees.

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

AGENDA (Eastern Time)
5:30 PM - 5:45 PM - Introduction by Celia Alves
5:45 PM - 6:45 PM - "Pivot Tables With Excel, Dynamic Array, Power Query, Python, and Copilot" by Bill Jelen
6:45 PM - 7:00 PM - Q&A + Closing by Celia Alves and Gráinne Duggan

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