Duration
Microsoft Excel 2019 (Advanced)
1 day
Outline
9:00am-10:30am
Module 1: Managing Data
- Consolidating Information
- Removing Duplicates
- Configuring Data Validation
- Using FlashFill
10:30am-10:45pm Morning Break
10:45pm-12:30pm
Module 2: Outlining and Grouping Data
- Outlining Data
- Showing and Hiding Outline Details
- Grouping Data
- Creating Subtotals
- Removing Outlining and Grouping
12:30pm-1:30pm Lunch
1:30pm-3:30pm
Module 3: Data Visualization
- Understand Types of Charts
- Creating Treemap Chart
- Creating Waterfall Chart
- Creating Funnel Chart
- Creating Map Chart
Module 4: Analyzing Data (I)
- Using Goal Seek
- Using Data Tables
Module 5: Analyzing Data(II) (Office365)
- Analysis on Stock Data Type
- Analysis on Geography Data Types
- Using Ideas
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
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.