Module 1: Managing Data
9:00am
Module 2: Outlining and Grouping Data
10:30am
Module 3: Data Visualization
11:30am
Lunch Break
12:30pm
Module 4: Analyzing Data
1:30pm
Module 5: Using Solver
2:30pm
Module 6: PivotTable Features
3:30pm
End of the Day
5:00pm
Time
Day 2
9am-10:30am
Module 1,2
10:30am-10:45am
Morning Break
10:45am-12:30pm
Module 3,4
12:30pm-1:30pm
Lunch Break
1:30pm-3:30pm
Module 5
3:30pm-3:45pm
Afternoon Break
3:45pm-5:00pm
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
Module 3: Data Visualization
Understand Types of Charts
Creating Treemap Chart
Creating Waterfall Chart
Creating Map Chart
Creating Funnel Chart
Module 4: Analyzing Data (I)
Using Goal Seek
Using Data Tables
Using Solver
Module 5: Analyzing Data (II)
Analysis on Stocks Data Type
Analysis on Geography Data Types
Using Ideas
Module 6: PivotTable Features
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.