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)
Functions = Über formulas!
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
course builder. Create your online course today.
Start now
