Understanding Logical Functions

Using IF with Text

Using IF with Numbers

Nesting IF Functions

Using IFERROR

Using TRUE and FALSE

Using AND

Using OR

Using NOT

SUMIF & SUMIFS

COUNTIF & COUNTIFS

Understanding Data Lookup Functions

Using CHOOSE

Using VLOOKUP

Using VLOOKUP for Exact Matches

Using HLOOKUP

Using INDEX

Using Match

Understanding Reference Functions

Using ROW and ROWS

Using COLUMN and COLUMNS

Using ADDRESS

Using INDIRECT

Using OFFSET

Scenario Manager

Goal Seek

Data Table

Show formulas

Errors checking

Evaluate formula

Trace precedents

Trace dependents

Remove arrows

Understanding How Solver Works

Installing the Solver Add-In

Setting Solver Parameters

Adding Solver Constraints

Performing the Solver Operation

Running Solver Reports

Validating Data

Understanding Data Validation

Creating a Number Range Validation

Testing a Validation

Creating an Input Message

Creating an Error Message

Creating a Drop Down List

Using Formulas as Validation Criteria

Circling Invalid Data

Removing Invalid Circles

Copying Validation Settings

Understanding Data Consolidation

Consolidating Data with Identical Layouts

Creating a Linked Consolidation

Consolidating Data with Different Layouts

Consolidating Data Using the SUM Function

Understanding Pivot Tables

Recommended Pivot Tables

Creating Your Own PivotTable

Defining the PivotTable Structure

Filtering a PivotTable

Clearing a Report Filter

Switching PivotTable Fields

Formatting a PivotTable

Understanding Slicers

Creating Slicers

Inserting a Timeline Filter

Dashboard Management

Understanding Time series concept

Historical sales data management

Historical data analysis

Time series plot

Understand trend components

The irregular component in time series

Design with graph quarterly time series forecasts

Definition

Keys Models and Use

Practical Exercises

Solver Addin

Histogram

Goal Seek

Data Table

Scenario Manager

Descriptive Statistics

Testing hypothesis

ANOVA

Covariance

Correlation

Regression

Msg Box

VBA variables

Events

Array

VBA functions

Application Object

Power Pivot

Power View

Power Query

Power Map