Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint | Al Chen | Skillshare

# Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

#### Al Chen, Excel Trainer & Coda Evangelist

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
9 Lessons (1h 24m)

0:59

10:59

10:53

15:34

9:09

11:12

5:59

11:10
• ### 9. Presenting Findings

8:02
34 students are watching this class
• --
• Beginner level
• Intermediate level
• All levels
• Beg/Int level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

4,241

Students

2

Projects

In the final Excel for the Real World class, you will take all of the tools and techniques you learned and apply them to help drive a real business decision. This is the 3rd part of thisÂ 3-part series on learning to use Excel from the producers ofÂ KeyCuts. We will walk through a real-world application for Excel, and you'll learn to use Excel as if you were a data analyst tasked with cleaning up a data set, analyzing the data, and presenting your insights.

Learn by doing.

You'll follow along with me in the Excel for the Real World III fileÂ I have provided under the "Projects & Resources" tab (in this tab see the "Resources" section).Â You will then work on analyzing the data yourself to come up with new insightful trends that will drive real business decisions. Upload your Excel file with your anlaysis as well as the PowerPoint slide with the final presentation!

What You'll Learn

• Setting Up the Scenario & Hypothesis. Create the outline for an analysis ofÂ ACME Inc'sÂ online advertising campaign (taken from a real AdWords campaign)
• Cleaning Up Raw Data.Â We'll walk through some quick data clean-up tips!
• Filtering, Sorting, PivotTables.Â PlayÂ around with the data in Excel to discover the signal in the noise from Google Adwords campaign results.
• Creating Charts.Â Create some basic charts to show some trends in the data.
• Detecting Trends.Â Add value to the anlaysis by discovering the trends and story behind the numbers.
• Revisiting Original Hypothesis.Â Is our original hypothesis supported or rejected? Think about how toÂ shape your findings to the CEO of ACME.
• Formatting.Â In terms of data visualization, there are a few tips to keep in mind when presenting charts to your audience.
• Presenting Findings.Â How do you succinctly present all your findings in one slide? Tell the story to help drive actionable business decisions for the CEO of ACME.

Also see:Â Excel for the Real World I: Gain the Basic Skills in 1 HourÂ &Â Excel for the Real World II: Double Your Excel Speed with Keyboard Shortcuts

Data drives all decisions, regardless of the business or industry you work on. You need to know how to organize it! Data is power! This Excel series will not only develop your technical skills, but also help you work with data in an efficient, smart way.

Note: The version of Excel used in this classÂ is Max Excel 2011, but the concepts apply to both PC and Mac.

### Al Chen

Excel Trainer & Coda Evangelist

Teacher

I have been an Excel power user for 10+ years. I started learning Excel when I was a financial analyst at Google. 30,000+ students have taken my online Excel classes and I have facilitated in-person workshops to over 5,000 MBA students around the the U.S.

I founded KeyCuts, an Excel training and consulting company to Fortune 500 companies. If it isn't clear I'm addicted to Excel, perhaps my podcast about Excel and data analysis (Dear Analyst) will convince you :).

Outside of Excel and spreadsheets, I'm experimenting with different productivity tools to help people be more productive at work. I have become an active user of (and currently work for) Coda, an all-in-one doc for teams. If you would like to read my full journey with spreadshee... See full profile

## Class Ratings

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

## Your creative journey starts here.

• Supportive online creative community
• Learn offline with Skillshareâ€™s app

## Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects