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

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

Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 48000 Hz, 2ch | Size: 686 MB

Genre: eLearning Video | Duration: 1 hours 24 mins | SRT/VTT | Language: English
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 "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.



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

Related eBooks:
Take Control of Big Sur
Take Control of Shortcuts
iOS 14 Programming Fundamentals with Swift
Take Control of Notes
Fundamentals of Mac OS: El Capitan
OS X Mountain Lion: The Missing Manual
The Easy Guide to Your Macintosh
The Graphic Designer's Basic Guide to the Macintosh
The Ultimate Mac User Book
iOS 12 Guide: The Ultimate Guide to iOS 12 on iPhone & iPad
Take Control of Preview
Apple Computing for Seniors in Easy Steps: Covers OS X El Capitan and iOS 9
Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.