- Free
- Computer Awareness
- 10 lessons
- About 1 h 53 min
Spreadsheets: Foundation
Foundation course on Spreadsheets (Computer Awareness): the basics, explained from the start.
Start: Workbooks, worksheets, rows, columns and cells
Sign in to keep track of your progress.
About this course
Foundation course on Spreadsheets (Computer Awareness): the basics, explained from the start.
What you will learn, lesson by lesson
- Workbooks, worksheets, rows, columns and cells Name the parts of a spreadsheet and read a cell address like C5 or a range like B2:B6.
- Formulas and operators Write simple formulas with + - * / and understand the order in which operators are worked out.
- Common functions: SUM, AVERAGE, MAX, MIN and COUNT Use the standard functions on a range and work out what each one returns.
- Cell references: relative, absolute and mixed Explain what happens to a formula when copied, and use $ to lock a row or column.
- Sorting, filtering and charts Sort and filter a data list and pick a suitable chart for the story the numbers tell.
Lessons in this course
- 1 Workbooks, worksheets, rows, columns and cells About 12 min Start
- 2 Formulas and operators About 12 min Start
- 3 Common functions: SUM, AVERAGE, MAX, MIN and COUNT About 13 min Start
- 4 Cell references: relative, absolute and mixed About 13 min Start
- 5 Sorting, filtering and charts About 13 min Start
- 6 Entering data, AutoFill and number formats About 12 min Start
- 7 Percentages and everyday formulas: share, discount, profit and change About 13 min Start
- 8 Comparison operators and the IF function About 13 min Start
- 9 Managing worksheets and moving around quickly About 12 min Start
- 10 Final self-assessment: spreadsheet basics Start
Questions about this course
Is this course free?
Yes. Every lesson in this course is free to read.
How do I keep track of what I've finished?
Create a free account and sign in. Each lesson you finish is saved to your account and shown here and on your dashboard.
Student reviews
No reviews yet. Students who finish a lesson can rate this course.