0022 - MS Excel Level 2
1019135
Loading...
Course Description
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.
Outline
- Lesson 1: Working with Functions
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
- Lesson 2: Working with Lists
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
- Lesson 3: Analyzing Data
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
- Lesson 4: Visualizing Data with Charts
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
- Lesson 5: Using PivotTables and PivotCharts
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
Prerequisites
Loading...
Enroll Now - Select a section to enroll in
Required fields are indicated by .