Excel
Part 2
Target Student:
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.
Prerequisites:
To ensure success, students should have completed Logical
Operations Microsoft Office Excel Part 1 (Second Edition) or
have the equivalent knowledge and experience.
Lesson 1:
Customizing the Excel Environment
Topic A: Configure Excel Options
Topic B: Customize the Ribbon and the Quick Access Toolbar
Topic C: Enable Excel Add-Ins
Lesson 2: Creating
Advanced Formulas
Topic A: Use Range Names in Formulas
Topic B: Use Specialized Functions
Topic C: Use Array Formulas
Lesson 3:
Analyzing Data with Functions and Conditional Formatting
Topic A: Analyze Data by Using Text and Logical Functions
Topic B: Apply Advanced Conditional Formatting
Lesson 4:
Organizing and Analyzing Datasets and Tables
Topic A: Create and Modify Tables
Topic B: Sort Data
Topic C: Filter Data
Topic D: Use SUBTOTAL and Database Functions
Lesson 5:
Visualizing Data with Basic Charts
Topic A: Create Charts
Topic B: Modify and Format Charts
Lesson 6:
Analyzing Data with PivotTables, Slicers, and PivotCharts
Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic
D: Filter
Data by Using Slicers