TOTAL DAYS: 1 | TOTAL HOURS: 3

Lesson 1: Formatting a Worksheet

Topic A: Apply Text Formats

Topic B: Apply Number Formats

Topic C: Align Cell Contents

Topic D: Apply Colors, Borders, and Styles

Topic E: Apply Basic Conditional Formatting

Lesson 2: Printing Workbooks

Topic A: Preview and Print a Workbook

Topic B: Set Up the Page Layout

Topic C: Configure Headers and Footers

Lesson 3: 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

TOTAL DAYS: 1 | TOTAL HOURS: 3

Lesson 1: 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 2: Analyzing Data

Topic A: Create and Modify Tables

Topic B: Apply Intermediate Conditional Formatting

Topic C: Apply Advanced Conditional Formatting

Lesson 3: Visualizing Data with Charts

Topic A: Create Charts

Topic B: Modify and Format Charts

Topic C: Use Advanced Chart Features