1-Day Excel Advanced Training

Module 1 Pivot Table

Creating Pivot Tables
Sorting and Filtering Pivot Tables
Formatting Pivot Tables
Creating PivotCharts
Module 2: Functions & Formulas

Formula Shortcut Keys
If and Related Functions
Lookup and Reference Functions
Power Functions
Statistical Functions
Math Functions
Date and Time Functions
Array Functions
Text Functions
Module 3: Advanced Charts

Creating Basic Charts
Style Charts with Design Tabs
Fine Tune Chart Elements
Format Tab
Module 4 Data Analysis

Installing Data Analysis Tool
Goal Seeker & Solver
Linear Regression
Testing a Hypothesis
Covariance and Correlation
Bayesian Analysis