Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Use Spreadsheets Confidently: Navigation, Functions and More
Introduction
Course overview
Understanding spreadsheet file formats
Spreadsheet navigation and formatting
How do I sort rows in a spreadsheet? (Using the Sort tool) (9:19)
How do I stop the top row from moving in a spreadsheet? (Freezing rows) (2:26)
Spreadsheet functions
How do I add up a column of numbers in a spreadsheet? (Using the SUM function) (4:49)
How do I reference cells on a different sheet? (7:01)
How do I add up values that only meet a specific criteria? (Using SUMIF) (6:21)
How do I use a SUMIF function with cells on a different sheet? (3:45)
Data clean-up
How do I use a text editor to delete duplicates in a set of data? (6:00)
More spreadsheet functions
How do I "lock" the row or column value in a cell's address? (8:13)
How to answer questions about your data using your new spreadsheet skills! (7:27)
Conclusion
Conclusion
Teach online with
How do I add up values that only meet a specific criteria? (Using SUMIF)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock
