This module provides an overview of the essentials of Microsoft Excel, including rows and columns, selecting cells, entering formulas and functions, and formatting data and text.
Unit: Introduction
Description
In this unit, students will learn about: Microsoft Excel basics such as cells, rows, and columns; entering data; and formatting, clearing, copying, cutting, and pasting cell content.
Lessons
1. Microsoft Excel Tour
2. Selecting Rows, Columns, and Cells
3. Entering Data in a Spreadsheet
4. Formatting Cells
5. Clearing Cells
6. Copy, Cut, and Paste Content
7. Quiz
Unit: Basic Formulas and Functions
Description
In this unit, students will learn about: formulas, including cell references, complex formulas, and functions.
Lessons
1. Introduction to Formulas
2. Cell References in Formulas
3. Complex Formulas
4. Introduction to Functions
5. Quiz
Project: Who's Who - Show Me the Money
Description
This project is part of a larger group of projects based around a single theme about well-known people. Prior to beginning any of the projects, students need to generate a list of well-known people in a profession or area of life. Read the "Who's Who Project Guide" for information.
In this project, students research and then compare the salary or net worth of all the people on their list. Students also calculate the smallest, largest, and average values.
Lessons