Microsoft Excel Skills Project (365)

Phase: Learn & Practice

Unit 1: Worksheet Data and Cells

In this unit, students learn about importing "raw" data. They will also format the data by adjusting column widths, wrapping text, aligning text, merging cells, formatting numbers and text, and adding borders and fill colors to cells.

Lessons:

1. Importing Worksheet Data
2. Adjusting Cells and Managing Worksheets
3. Aligning Text and Merging Cells
4. Formatting Numbers and Text
5. Adding Cell Borders
6. Using Cell Fill Colors

Unit 2: Functions, Formulas, and Tables

In this unit, students use functions and formulas to determine gross and net profits. In the process, they review concepts such as the order of operations and relative/absolute cell references, creating Excel tables, and adding total rows and columns.

Lessons:

1. Using Functions, Part 1
2. Using Functions, Part 2
3. Entering Formulas, Part 1
4. Entering Formulas, Part 2
5. Creating Excel Tables, Part 1
6. Creating Excel Tables, Part 2

Unit 3: Workbooks, Worksheets, and Charts

In this unit, students copy data and worksheets from one workbook to another. They also create pie, column, and line charts showing profit information.

Lessons:

1. Copying Data between Workbooks
2. Coping a Worksheet Tab between Workbooks
3. Referencing Multiple Worksheets
4. Creating a Pie Chart
5. Creating a Column Chart
6. Creating a Line Chart
7. Creating Your Own Chart

Unit 4: What-If Analysis and Printing

In this unit, students learn about What-If Analysis tools as they walk through a What-If analysis on the effect of loss of volunteers on net profit. They then create a What-If analysis on how rent affects net profits. Students format and output information from their Excel spreadsheet to PDF printouts.

Lessons:

1. Creating a What-If Analysis Data Table
2. Creating Your Own What-If Analysis
3. Preparing to Print
4. Printing Your Spreadsheet

Phase: Reinforce

Project: Loan Calculation and Analysis