Regardless of your job function and industry everyone is being exposed to more and more data. If you are not able to summarize and explain the data in a clear and meaningful way, it provides little value to you or your organization. This course will teach you how to effectively summarize and communicate the results your data to team members and senior management. Use Key Performance Indicators (KPI) drivers to show others the results under various ‘What-if’ scenarios. The term ‘Model’ will show up far and wide as you dive into Data Analytics. It is important to remember a ‘Model’ is simply using a tool to build a representation of a real world situation
How you will benefit: - Effectively communicate the results of models to team members and senior management - Evaluate patterns in your historical data - Identify and utilize key business drivers and integrate them into your forecast - Make business decisions based on your analysis
What You Will Cover: - Working with advanced Excel modeling techniques such as ‘Goal Seek’ Optimization - Analyzing and applying diagnostics to validate your forecast - The Art of Telling the story
Basic understanding of Excel and charting functions Laptop with Excel (preferably 2013 or later), 10-key function if possible