Analyzing Data and Storytelling with PowerPoint

Analyzing data using PowerPoint involves utilizing data obtained from research and representing it using PowerPoint features, such as charts and … Continue reading "Analyzing Data and Storytelling with PowerPoint"

Overview

Analyzing data using PowerPoint involves utilizing data obtained from research and representing it using PowerPoint features, such as charts and tables. 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.

Audience

Users who need to do data analysis and present it using PowerPoint

Length

1 day

Outline

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