Contents

1. Introduction

2. Chapter 1 – Fundamental Skills

   1. 1.1 Overview of Microsoft Excel

   2. 1.2 Entering, Editing, and Managing Data

   3. 1.3 Formatting and Data Analysis

   4. 1.4 Preparing to Print

   5. 1.5 Chapter Practice: PR1 Medical Office Budget

   6. 1.6 Scored Assessment: SC1 Sales and Inventory

3. Chapter 2 – Mathematical Computations

   1. 2.1 Formulas

   2. 2.2 Introductory Statistical Functions

   3. 2.3 Functions for Personal Finance

   4. 2.4 Preparing to Print

   5. 2.5 Chapter Practice: PR2 Lawn Care

   6. 2.6 Scored Assessment: SC2 Hotel

4. Chapter 3 – Logical and Lookup Functions

   1. 3.1 More on Formulas and Functions

   2. 3.2 Logical and Lookup Functions

   3. 3.3 Conditional Formatting

   4. 3.4 Preparing to Print

   5. 3.5 Chapter Practice

   6. 3.6 Chapter Scored

5. Chapter 4 – Presenting Data with Charts

   1. 4.1 Choosing a Chart Type

   2. 4.2 Formatting Charts

   3. 4.3 Using Charts with Microsoft® Word® and Microsoft® PowerPoint®

   4. 4.4 Preparing to Print

   5. 4.5 Chapter Practice

   6. 4.6 Scored Assessment

6. Appendix