Data Analysis Forcasting

Module: Advanced Microsoft Excel Application For Data Analysis & Forecasting

Lesson1: Large Data Analysis & Report

 Creating a PivotTable
 Analyze Data Using PivotTable
 Use Slicers for filtering data.
 Analyze data using PivotCharts.


Lesson2: The use of Excel Forecasting tools

 Create a Trendline for data
 Create Sparklines for data.
 Create scenarios.
 Create a data table
 Perform a what-if analysis using Goal Seek
 Perform a what-if analysis using Solver
 Perform a statistical analysis with the Analysis ToolPak