Business&ITCenter21: Microsoft Excel Fundamentals (2016)

Microsoft Excel 2016 Lessons

This module provides an overview of the fundamentals of Microsoft Excel, including relative and absolute cell references, common functions, and formatting.

 

Unit: Using Formulas and Functions


Description
In this unit, students will learn about: Microsoft Excel formulas including relative and absolute cell references, Autofill, common functions, and the IF function. 

Lessons
  1. A Pancake Recipe (Part 1) 
  2. A Pancake Recipe (Part 2) 
  3. Coffee Shop Inventory 
  4. Quiz

 

Unit: Data Management and Analysis


Description
In this unit, students will learn about: sorting in ascending and descending order, sorting based on multiple criteria, and filtering using column entries and custom criteria.

Lessons
  1. Sorting a Membership List
  2. Filtering an Employee List 
  3. Quiz

 

Unit: Formatting in Excel


Description
In this unit, students will learn about: formatting and conditional formatting in Excel as they make an existing spreadsheet more visually appealing. 

Lessons
  1. Overdue Library Books 
  2. Make It Look Great 
  3. Quiz

 

Project: Who's Who - Age is Only a Number


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 calculate the exact age of each person. Students then calculate the youngest, oldest, and average age. They also calculate the age difference between the teacher and these.

Lessons

  1. Age is Only a Number

 

Project: Using an Excel Template


Description
In this project, students will download a template and customize it based on a specific assignment selected by the teacher.

module-back-button.png