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

Provided by:
0/10 stars
based on  2 reviews
Provided by:
Cost $8/mo
Start Date On demand
Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

Course Details

Cost

$8/mo

Skillshare offers a wide variety of free and Premium courses on creative skills, marketing and more.

Get One Month Free

Upcoming Schedule

  • On demand

Course Provider

Skillshare online courses
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog h...
In Skillshare’s unique philosophy, everyone is a teacher, and everyone is a learner. Rather than a traditional lecture format, courses are offered within a global online learning community in which learners collaborate and learn by doing. Instructors are industry leaders who share their skills with anyone who wants to learn. No credits are offered. Founded by online entrepreneurs Michael Karnjanaprakorn and Malcolm Ong, Skillshare’s online “campus” was launched in April 2011. Its catalog has grown from 15 to more than 250 online courses that cover creative arts, entrepreneurship, branding and marketing, lifestyle and technology. The School of MakeOurMark, with courses in photography, illustration and tattooing, was launched in October 2013, and the School of Design went live the following month. Among the instructors who have taught courses are Seth Godin, founder of online marketing firm Yoyodyne, who teaches a class on entrepreneurship; DJ Young Guru, who leads a course on mixing and recording; and actor, writer and director James Franco, whose course focuses on screenwriting for short films. You can begin a Skillshare collaboration by taking an introductory course in a particular area to learn, for example, the fundamentals of Photoshop and expand your knowledge with a five-part, in-depth Photoshop series.

Provider Subject Specialization
Arts & Design
Business & Management
32 reviews

Course Description

Present your key insights from analyzing real data. Make data-driven decisions for your business.

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 "Your Project" tab (in this tab see the "Attached Files" 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 ...

Present your key insights from analyzing real data. Make data-driven decisions for your business.

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 "Your Project" tab (in this tab see the "Attached Files" 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.

Reviews 0/10 stars
2 Reviews for Excel for the Real World III: Create a Data-Driven Presentation from Excel to PowerPoint

Ratings details

  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.

Sort By
Jacob Day profile image
Jacob Day profile image

Jacob Day

None/10 starsCompleted
4 years, 10 months ago
Good class, but needs to be much more advanced. Al Chen is a great teacher though, perfect pace.
Was this review helpful? Yes0
 Flag
David Atchison profile image
David Atchison profile image

David Atchison

None/10 starsCompleted
4 years, 10 months ago
Great class, this is the missing component you can't get from most other tutorials -- real world application.
Was this review helpful? Yes0
 Flag

Rating Details


  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars

Rankings are based on a provider's overall CourseTalk score, which takes into account both average rating and number of ratings. Stars round to the nearest half.