Overview
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. Users should have a basic working knowledge of both Excel and PowerPoint coming into this course.
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