Analyzing Data and Storytelling with PowerPoint

This class involves learning to use PowerPoint features, such as charts and tables, to represent data obtained from research.


Analyzing both quantitative (numbers) and qualitative (ideas) data usually involves examining the results and identifying patterns and trends. Using PowerPoint to prepare visual representations of your data helps filter out irrelevant or insignificant data and focus on the important information resulting in output focused on the story and message you’re delivering.


Users who need to do data analysis and present it using PowerPoint. Users should have a basic working knowledge of both Excel and PowerPoint coming into this course.


1 day


Lesson 1: Using Names in Formulas and Functions

 Topic A: Examine Dashboards

 Topic B: Use Range Names in Formulas

 Topic C: Use Specialized Functions

Lesson 2: Automating Workbook Functionality

 Topic A: Apply Data Validation

 Topic B: Work with Forms and Controls

Lesson 3: Applying Conditional Logic

 Topic A: Use Lookup Functions

 Topic B: Combine Functions

Lesson 4: Visualizing Data with Basic Charts

 Topic A: Create Charts

 Topic B: Modify and Format Charts

Lesson 5: Using Advanced Charting Techniques

 Topic A: Create Dual-Axis Charts and Trendlines

 Topic B: Create Sparklines

Lesson 6: Analyzing Data with PivotTables, PivotCharts, and Slicers

 Topic A: Create a PivotTable

 Topic B: Analyze PivotTable Data

 Topic C: Present Data with PivotCharts

 Topic D: Filter Data by Using Slicers

Custom Lesson: Using Excel Data and Storytelling in PowerPoint

Topic A: Inserting and Linking Charts into PowerPoint

Topic B: Inserting and Linking PivotTables into PowerPoint