WHY SHOULD YOU ATTEND?
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.AREA COVERED
- 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
LEARNING OBJECTIVES
- 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
WHO WILL BENEFIT?
- 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.
- 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
- 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
- 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.
Speaker Profile
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

Excel Spreadsheets; Develop and Validate for 21 CFR Part 11…

2025 Handbook Overhaul: Navigating Critical Updates! Federa…

Building Thriving Teams: Proactive Strategies for Managers …

Negotiating Skills For Professional Results - Winning Strat…

President Trumps Executive Orders And What They Mean to Emp…

The Anti-Kickback Statute: 2025 - Year in Review

Navigating Alcohol and Drug Addiction Protections Under the…

Empowering Conflict Resolution: Letting Go to Gain Control

Designing Employee Experiences to Build a Culture of Compli…

Workplace Investigations 101: How to Conduct your Investiga…

FDA Technology Modernization Action Plan (TMAP) and Impact …

Form W-9 Compliance: TIN Verification, B Notices, and Avoid…

50+ new Excel features so far this decade

FDA Regulation of Artificial Intelligence/ Machine Learning

From Challenges to Compliance: Understanding Dietary Supple…

Utilizing HR Metrics to Illustrate & Improve Human Resource…


The Importance of the first 5 seconds when presenting


Policy Pops: Navigating DEI in the 2025 Workplace: Strategi…

Why EBITDA Doesn't Spell Cash Flow and What Does

Do's and Don'ts of Documenting Employee Behaviour, Performa…

Outlook - Master your Mailbox - Inbox Hero Inbox Zero

Mastering Performance Management: Strategies for Continuous…

Impact Assessments For Supplier Change Notices

Understanding the incredible uses and fallbacks of ChatGPT


The Monte Carlo Simulations in Excel for Risky Investments

Unlock Employee Loyalty: Stay Interviews Will Keep Them Eng…

Navigating FDA Regulations – A guide for medical device and…


California Meal and Rest Breaks: What You Don't Know Can Co…


Onboarding is NOT Orientation - How to Improve the New Empl…

Gossip-Free: Leadership Techniques to Quell Office Chatter

Female to Female Hostility @Workplace: All you Need to Know


6-Hour Virtual Seminar on Learning the Highlights of Excel …

The Five Cs Of Commercial Credit: The Basic Elements Of Cre…


Communication Skills for Success - In Business & In Life

2025 Top Employment Regulations That Will Impact Employers!


Building GMP Excellence: A Guide to Implementing Compliant …

Writing Techniques for Auditors and Risk Management Profess…

Interactive dashboards & analytics in Excel

Using Emotional Intelligence to Elevate Your Leadership

4-Hour Virtual Seminar on Bootcamp on Excel

Leading Across Generations: 5 Challenges & 10 Strategies to…
