Data Visualization Series: Excel Charts, PivotTables, and Dashboards

Convey data with mesmerizing charts and dashboards. Learn how to harness Excel’s data visualization features.

After spending countless hours compiling data, you need a better way to convey it. You cannot just show a bunch of numbers—stakeholders want to see conclusions and understand relationships in the information.

Data tells; visuals sell. Studies show that 65% of your audience are visual learners. Excel’s visualization tools offer a variety of ways to share your story.

To help you communicate your message clearly, we have assembled a five-part webinar series with step-by-step guidance that will enable you to transform your visualization skills from basic to advanced.

Excel Charts, PivotTables, And Dashboards Series

Webinar 1: Intro to Lists, Tables, and Charts

• Sorting and filtering lists
• Best practices for creating tables
• Creating tables
• Creating charts (at least 3 ways)
• Which chart types work best, depending on your data and the story you’re trying to communicate
• Exploring basic chart types

Webinar 2: Modifying and Advanced Charts

• Formatting Charts
• Modifying Charts
• Creating Advanced Charts (secondary axis, tree map, maps, and more)

Webinar 3: Intro to Pivot Tables – Part 1

• When to use PivotTables
• What you should know before you create a PivotTable
• Creating a PivotTable
• Formatting PivotTables
• Sorting and filtering PivotTables
• Filtering with interactive slicer tools
• Creating PivotCharts

Webinar 4: Intro to Pivot Tables and Charts – Part 2

• Customizing PivotTable formatting
• Changing PivotTable calculations
• Formatting PivotCharts
• Creating Advanced PivotCharts
• Sharing PivotTables and charts in PowerPoint, Word, and other apps
• Power tips, tricks, and shortcuts

Webinar 5: Creating Interactive Dashboards

• Designing a dashboard
• Setting up your Excel workbook
• Formatting your Excel worksheet
• Inserting pivot tables, charts, and slicers
• Making your dashboard interactive

We are not affiliated, endorsed, or sponsored by Microsoft or Microsoft Excel®.