Business&ITCenter21: Microsoft Excel Essentials (2019)

microsoft-excel-365

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

  1. Show Me the Money
module-back-button.png
New call-to-action