Microsoft Excel: Starter Guide

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Opening Excel and creating a new sheet

Lecture 2: Saving Excel files

Lecture 3: The important file types

Lecture 4: The formula bar

Lecture 5: Adding, Modifying, and Deleting data in cells

Lecture 6: Creating a new workbook

Lecture 7: Develop the habit of using file… save as

Lecture 8: The important data types

Chapter 2: Beginning Steps

Lecture 1: Before we start: Let's zoom in and out

Lecture 2: How Excel works

Lecture 3: The relative cell reference

Lecture 4: Review: Enter and leave edit mode

Lecture 5: Example using relative cell references

Lecture 6: Relative vs. absolute cell references

Lecture 7: Test your skills | Create cell references

Lecture 8: Test your skills | Copy and paste a cell reference

Lecture 9: Add | Subtract | Multiple | Divide

Lecture 10: Add numbers using a more complicated formula

Lecture 11: Review: Cut and Paste | "Moving" Cells

Lecture 12: Recap: Select | Move (cut and paste) | Copy and paste

Chapter 3: Mini Project #1 | Creating a Small Budget

Lecture 1: Very! Fast Overview: Creating a budget

Lecture 2: Building the budget | Part 1

Lecture 3: Building the budget | Part 2

Lecture 4: How to make good formulas even better

Lecture 5: Building the budget | Part 3

Chapter 4: Mini Project #2 | Creating a Personal Budget

Lecture 1: Very! fast overview: Creating a personal budget

Lecture 2: Getting set up

Lecture 3: Creating the Income Row

Lecture 4: Creating the expenses

Lecture 5: Calculating savings/loss

Lecture 6: Expressing expenses as a % of income

Lecture 7: Easily calculate a multi-year budget

Chapter 5: Mini Project #3 | Apartment Comparison Tool

Lecture 1: Formatting text: changing font

Lecture 2: Review: Cut and paste | Move text

Lecture 3: Resizing columns

Lecture 4: Cleaning up | Wrap text

Lecture 5: Adding fake values

Lecture 6: Formatting text: centering

Lecture 7: Selecting all text at once

Lecture 8: Review: Adding a SUM function

Lecture 9: Review: Copy and paste the function

Lecture 10: Formatting text: center | fill with color | sort

Lecture 11: Improve the first function

Lecture 12: Review: Use the fill feature | Merge cells and center text

Lecture 13: Improve the formula using the SUMPRODUCT function