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.

More info - https://skl.sh/2CprIAd