Advanced MS Excel 2016 Training

Module 5 : Data Analysis (1 Hours)

In this module, you will learn how to use pivot tables and charts toanalyze data. This module covers topics on pivot tables, pivot chart, spark lines. It also demonstrates the application of advanced filters.
● Data analysis using normal charts, formatting of charts, secondary axis use, scatter plots
● Data analysis using a Pivot table and pivot charts, spark lines
● Running Regression in excel, ANOVA, etc.
● Cover basic stats through excel – Functions like correlation, stddev, average, regression functions