Course Outline

1 - GETTING STARTED WITH EXCEL

• Topic A: Navigate the Excel User Interface
• Topic B: Use Excel Commands
• Topic C: Create and Save a Basic Workbook
• Topic D: Excel Online
• Topic E: Enter Cell Data
• Topic F: Use Excel Help

2 - PERFORMING CALCULATIONS

• Topic A: Create Worksheet Formulas
• Topic B: Insert Functions
• Topic C: Reuse Formulas and Functions

3 - MODIFYING A WORKSHEET

• Topic A: Insert, Delete, and Adjust Cells, Columns, and Rows
• Topic B: Search for and Replace Data
• Topic C: Use Proofing and Research Tools

4 - 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
• Topic F: Create and Use Templates

5 - PRINTING WORKBOOKS

• Topic A: Preview and Print a Workbook
• Topic B: Set Up the Page Layout
• Topic C: Configure Headers and Footers

6 - MANAGING WORKBOOKS

• Topic A: Manage Worksheets
• Topic B: Manage Workbook and Worksheet Views
• Topic C: Manage Workbook Properties