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