Module 1: Managing Data

Consolidating Information

Configuring Data Validation

Converting Text to Columns

Using Flash Fill

Module 2: Outlining and Grouping Data

Outlining Data

Showing and Hiding Outline Details

Grouping Data

Creating Subtotals

Removing Outlining and Grouping

Understand Types of Charts

Creating Treemap Chart

Creating Waterfall Chart

Creating Map Chart

Creating Funnel Chart

Using Goal Seek

Using Data Tables

Using Solver

Analysis on Stocks Data Type

Analysis on Geography Data Types

Using Analyze Data

Course Outline :: EXC21A ::

Creating a Basic PivotTable

Creating a Basic PivotChart

Using the PivotTable Fields Pane

Adding Calculated Fields

Sorting Pivoted Data

Filtering Pivoted Data

Using Slicers

Creating Timelines

Programme scope, delivery arrangements and suitability are confirmed during enquiry.