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
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
How do I sort rows in a spreadsheet? (Using the Sort tool)
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
