Excel - Data Analytics

Descriptive, predictive and prescriptive analytics are interrelated, helping companies make the most out of their data. Excel is a tool that can be used for analysis; to collect, clean, transform and analyse data and generate reports.

Content

• Understand the different types of analytics techniques
• Use advanced sorting for descriptive analysis
• Use advanced conditional formatting for descriptive analysis
• Work with advanced analytic functions such as SUMPRODUCT and analytic database functions such as DSUM AND DAVERAGE
• Learn how to use What-If Analysis tools: 
  • Goal Seek to calculate a single value needed to achieve a known outcome
  • Scenario Manager to switch between different calculations with different variables
  • Data Tables to view multiple results from one or two variables
  • Solver to calculate multiple values needed to achieve a known outcome.
• Gain an understanding of the Excel Analysis ToolPak.