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 30m
Skills Learned
After completing this online training course, students will be able to:
Linking Workbooks and Worksheets
Working with Range Names, Sorting Filtering, and Subtotaling
Analyzing and Organizing with Tables
Using Conditional Formatting
Displaying Data Graphically
Understanding PivotTables
PivotCharts, and Slicers
Working with Advanced PivotTables and PowerPivot Features
Students who have attended the Excel 365 Introduction course or have equivalent knowledge or experience.
The recommended pre-requisite for this course is Excel 365 Introduction course or equivalent knowledge or experience.
01. Excel 365 Intermediate
- Linking Workbooks and Worksheets
- Working with Range Names, Sorting, Filtering, and Subtotaling
- Analyzing and Organizing with Tables
- Using Conditional Formatting
- Displaying Data Graphically
- Understanding PivotTables
- PivotCharts, and Slicers
- Working with Advanced PivotTables and PowerPivot Features
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Linking Workbooks and Worksheets
Working with Range Names, Sorting Filtering, and Subtotaling
Analyzing and Organizing with Tables
Using Conditional Formatting
Displaying Data Graphically
Understanding PivotTables
PivotCharts, and Slicers
Working with Advanced PivotTables and PowerPivot Features
WHO SHOULD ATTEND
Students who have attended the Excel 365 Introduction course or have equivalent knowledge or experience.
PREREQUISITES
The recommended pre-requisite for this course is Excel 365 Introduction course or equivalent knowledge or experience.
COURSE OUTLINE
01. Excel 365 Intermediate
- Linking Workbooks and Worksheets
- Working with Range Names, Sorting, Filtering, and Subtotaling
- Analyzing and Organizing with Tables
- Using Conditional Formatting
- Displaying Data Graphically
- Understanding PivotTables
- PivotCharts, and Slicers
- Working with Advanced PivotTables and PowerPivot Features
