This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Step-by-step Spreadsheets for Absolute Beginners
Introduction
Welcome! (2:49)
Why are spreadsheets so awesome? (3:21)
What you need to get started (3:13)
Choose your weapon: Free alternatives to Microsoft Excel (11:10)
Project overview: 5-song CD recording budget (2:34)
QUIZ: Check your progress!
First Steps
Meet your spreadsheet (8:14)
Battleships!
Data entry tips and tricks (10:43)
Thinking ahead: Building a flexible template (15:03)
QUIZ: Check your progress!
Putting Your Spreadsheet to Work
Calculations: Don't do the math! (7:04)
Formulas = Magic recipes! (5:06)
Tips and tricks for writing formulas (5:37)
Functions = Über formulas! (14:24)
QUIZ: Check your progress!
Using Your Spreadsheet to Find Solutions
Subtraction in action: Are we going to break even? (2:44)
Playing with numbers: Tweaking our budget (4:04)
Bonus round: Splitting the profits (4:28)
QUIZ: Check your progress!
File Formats
Choosing the right spreadsheet file format (18:54)
Wrapping Up
Hooked on spreadsheets: What's next? (2:34)
Formulas = Magic recipes!
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock