In this course, students will learn how to link workbooks and worksheets, work with range names, sort and filter range data, and analyze and organize with tables. Students will also apply conditional formatting, outline with subtotals and groups, display data graphically with charts and sparklines. Additionally, students will also understand PivotTables, PivotCharts, and slicers and work with advanced PivotTables and PowerPivot features.
Overview
COURSE DIFFICULTY
COURSE DURATION
4h 40m
Skills Learned
After completing this online training course, students will be able to:
Linking Workbooks and Worksheets
Working with Range Names
Sorting and Filtering Range Data
Using Conditional Formatting
Displaying Data Graphically
Understanding PivotTables
PivotCharts, and Slicers
Working with Advanced PivotTables and PowerPivot Features
Analyzing and Organizing with Tables
Students who have attended Excel 2019 Introduction course or have equivalent knowledge or experience.
The recommended pre-requisite for this course is Excel 2019 Introduction course or equivalent knowledge or experience.
01. Excel 2019 Intermediate
- Linking Workbooks and Worksheets
- Working with Range Names
- Sorting and Filtering Range Data
- Using Conditional Formatting
- Displaying Data Graphically
- Understanding PivotTables
- PivotCharts, and Slicers
- Working with Advanced PivotTables and PowerPivot Features
- Analyzing and Organizing with Tables
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Linking Workbooks and Worksheets
Working with Range Names
Sorting and Filtering Range Data
Using Conditional Formatting
Displaying Data Graphically
Understanding PivotTables
PivotCharts, and Slicers
Working with Advanced PivotTables and PowerPivot Features
Analyzing and Organizing with Tables
WHO SHOULD ATTEND
Students who have attended Excel 2019 Introduction course or have equivalent knowledge or experience.
PREREQUISITES
The recommended pre-requisite for this course is Excel 2019 Introduction course or equivalent knowledge or experience.
COURSE OUTLINE
01. Excel 2019 Intermediate
- Linking Workbooks and Worksheets
- Working with Range Names
- Sorting and Filtering Range Data
- Using Conditional Formatting
- Displaying Data Graphically
- Understanding PivotTables
- PivotCharts, and Slicers
- Working with Advanced PivotTables and PowerPivot Features
- Analyzing and Organizing with Tables
