Interactive dashboards & analytics in Excel
Duration: 60 Minutes
As data grows exponentially, analytics are becoming increasingly important, here Excel MVP & YouTuber David Benaim, contributor to Microsoft’s what’s new in Excel monthly blog will show you how to use PivotTables to build interactive dashboards which are updated from ever changing data. David will also cover how to use Excel’s built in AI feature Analyze data plus new charts worth knowing about such as map charts, Waterfall, box & whisker, Pareto charts and sparklines. This demo heavy session will have useful insights for anyone along the spectrum of experience, from those who have never seen PivotTables to those who are veteran to PivotTables. We will showcase the most recent tools including the brand new GROUPBY functions which replicate PivotTables using formulas, but even those using older versions of Excel will benefit from this session.
- Understand how PivotTables work as well as their formula equivalents (GROUPBY and PIVOTBY)
- Learn which data visualisations work best in which context
- Create dashboards with interactive charts using slicers and timelines
- Identify how the source data should be set up for optimal use of analytics
- Learn built in AI features to help, such as Analyze data, Copilot and more
- Learn how to make charts inside cells with sparklines and data bars
- What makes a good dashboard
- Which chart for what
- Using charts inside cells
- Aggregations in Excel using PivotTables and GROUPBY
- PivotTables tips and tricks
- Adding interactivity with slicers and timelines
- Using Excel’s AI to tool auto-analyze data
Most of us store data of various kinds, but very rarely analyze the data. This session will show how use Excel’s built in tools to analyze data and create concise charts from the data, and furthermore, how to make the charts interactive so users can click to select different date periods or regions and adjust the charts accordingly. We will also showcase how to ensure the data is stored so it can best be viewed in a dashboard. Even those familiar with PivotTables will learn some tips and tricks and other modern tools such as AI auto-analysis or the new GROUPBY and PIVOTBY functions which have certain capabilities which PivotTables do not.
- Understanding these tools is very useful for high level and middle management, but anyone needing to aggregate data will find it helpful. People working in sales, HR, marketing, finance or operations who work with data will find this useful, essentially anyone using Excel for 20 minutes or more per day on average.
David Benaim is considered by Microsoft to be in the top 100 or so Excel users worldwide by holding the Microsoft MVP award, he has a YouTube channel with tech tutorials with over 18,000 subscribers under his name David benaim and does 50+ webinars/presentations per year on Excel/public speaking.
David keeps up to date with new Excel features so much that he contributes to every official Microsoft Excel monthly blog post and he also runs Xlconsulting where he assists with process automation and analytics via Excel.
Upcoming Webinars
By David Nettleton
Date: March 18, 2025
By Edlyn McGarity
Date: March 18, 2025
By Bruce Lee
Date: March 18, 2025
By Margie Faulk
Date: March 18, 2025
By Melveen Stevenson
Date: March 19, 2025
By Susan Fahey Desmond
Date: March 19, 2025
By Rebecca Farabaugh
Date: March 19, 2025
By Nancy Amert
Date: March 20, 2025
By Dr. Susan Strauss
Date: March 20, 2025
By Carolyn Troiano
Date: March 20, 2025
By Meredith Crabtree
Date: March 21, 2025
By Edwin Waldbusser
Date: March 21, 2025
By Pete Tosh
Date: March 21, 2025
By Wendy Sellers
Date: March 24, 2025
By Diane L. Dee
Date: March 24, 2025
By Erica Chisolm & Vanessa Hardiman
Date: March 25, 2025
By Dr.Isaac Gottlieb
Date: March 25, 2025
By Melveen Stevenson
Date: March 26, 2025
By Marcia Zidle
Unlock Employee Loyalty: Stay Interviews Will Keep Them Engaged Before They Start Looking Elsewhere!
Date: March 26, 2025
By Charles H. Paul
Date: March 26, 2025
By Don Phin
Date: March 27, 2025
By Beverly Beuermann-King
Date: March 28, 2025
By Dr. Susan Strauss
Date: March 28, 2025
By Cathy Horwitz
Date: March 31, 2025
By Dev Strischek
Date: March 31, 2025
By Ginette M. Collazo
Date: April 2, 2025
By Jonnie Keith
Date: April 2, 2025
By Marcia Zidle
Date: April 3, 2025
By Meredith Crabtree
Recorded Session
By Bob Verchota
Recorded Session
By Margie Faulk
Recorded Session
By Diane L. Dee
Recorded Session
By Paul J. Cline
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Jonnie Keith
Recorded Session
By Gary Heppner
Recorded Session
By Marcia Zidle
Recorded Session
By Cathy Horwitz
Recorded Session
By Kelly Thomas
Recorded Session
By Rachelle D Souza
Recorded Session
By Charles H. Paul
Recorded Session
By Edwin Waldbusser
Recorded Session
By Bruce Lee
Recorded Session
By Beverly Beuermann-King
Recorded Session
By Dr. Susan Strauss
Recorded Session
By Cathy Horwitz
Recorded Session
By Marcia Zidle
Recorded Session
By Mike Thomas
Recorded Session
By Mark Gorkin
Recorded Session
By Edwin Waldbusser
Recorded Session
By Charles H. Paul
Recorded Session
By Deb Schaffer
Recorded Session
By David Nettleton
Recorded Session
By Justin Muscolino
Recorded Session
By Charles H. Paul
Recorded Session
By Marcia Zidle
Recorded Session
By Richard E Cascarino
Recorded Session
By Edwin Waldbusser
Recorded Session
By William J. Rothwell
Recorded Session
