Video Tutorial: Excel Modules 1 & 2
Two modules in one video. Work through them in order.
How Microsoft Excel Works
- The Excel interface and layout
- Cells, rows, columns, and sheets
- Entering and editing data
- Basic formatting and navigation
References
- Cell references explained
- Relative vs absolute references
- Using references in formulas
- Cross-sheet referencing
💡 Tips for This Video
- Have Excel open and follow along as you watch
- Pause after each concept and try it yourself before moving on
- Pay close attention to the difference between relative and absolute references in Module 2
Try it with a real example
Open the example. Open Apple’s prefilled SEC filings and use two annual revenue figures as practice data in Excel. Put each year in its own row, calculate the change with a relative cell reference, then lock a separate hypothetical $100 starting value with an absolute reference.
Key takeaways
- A relative cell reference adjusts when a formula is copied.
- An absolute reference fixes its row and column.
- Use a mixed reference when you need to fix only a row or only a column.
Check your understanding
Answer each question, then open the explanation.
1. What normally happens to a relative reference when its formula is copied to another row?
Show answer and why
Answer: It adjusts relative to the formula’s new location.
Why: This lets a copied formula refer to the corresponding cells in each row.
2. What does $A$1 keep fixed when a formula is copied?
Show answer and why
Answer: Both column A and row 1.
Why: The two dollar signs make both parts absolute; copying does not move that reference.
3. How does $A1 differ from A$1?
Show answer and why
Answer: $A1 fixes the column; A$1 fixes the row.
Why: A mixed reference fixes one part and lets the other adjust, so choose it to match the structure of the worksheet.
AI responses are for educational purposes. Always verify with official course materials.
This lesson teaches a concept. It is general education, not advice about your money. Before you act on anything you learn here, speak to someone licensed.
AI responses are for educational purposes. Always verify with official course materials.
This lesson teaches a concept. It is general education, not advice about your money. Before you act on anything you learn here, speak to someone licensed.
This lesson teaches a concept. It is general education, not advice about your money. Before you act on anything you learn here, speak to someone licensed.
