Getting Started
- Opening Excel and creating a new sheet
- Saving Excel files
- The important file types
- The formula bar
- Adding, Modifying, and Deleting data in cells
- Creating a new workbook
- Develop the habit of using file... save as
- The important data types
Beginning Steps
- Before we start: Let's zoom in and out
- How Excel works
- The relative cell reference
- Review: Enter and leave edit mode
- Example using relative cell references
- Relative vs. absolute cell references
- Test your skills | Create cell references
- Test your skills | Copy and paste a cell reference
- Add | Subtract | Multiple | Divide
- Add numbers using a more complicated formula
- Review: Cut and Paste | "Moving" Cells
- Recap: Select | Move (cut and paste) | Copy and paste
Mini Project #1 | Creating a Small Budget
- Very! Fast Overview: Creating a budget
- Building the budget | Part 1
- Building the budget | Part 2
- How to make good formulas even better
- Building the budget | Part 3
Mini Project #2 | Creating a Personal Budget
- Very! fast overview: Creating a personal budget
- Getting set up
- Creating the Income Row
- Creating the expenses
- Calculating savings/loss
- Expressing expenses as a % of income
- Easily calculate a multi-year budget
Mini Project #3 | Apartment Comparison Tool
- Formatting text: changing font
- Review: Cut and paste | Move text
- Resizing columns
- Cleaning up | Wrap text
- Adding fake values
- Formatting text: centering
- Selecting all text at once
- Review: Adding a SUM function
- Review: Copy and paste the function
- Formatting text: center | fill with color | sort
- Improve the first function
- Review: Use the fill feature | Merge cells and center text
- Improve the formula using the SUMPRODUCT function
