• Free
  • Computer Awareness
  • 10 lessons
  • About 1 h 53 min

Spreadsheets: Foundation

Foundation course on Spreadsheets (Computer Awareness): the basics, explained from the start.

About this course

Foundation course on Spreadsheets (Computer Awareness): the basics, explained from the start.

What you will learn, lesson by lesson

  1. 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.
  2. Formulas and operators Write simple formulas with + - * / and understand the order in which operators are worked out.
  3. Common functions: SUM, AVERAGE, MAX, MIN and COUNT Use the standard functions on a range and work out what each one returns.
  4. Cell references: relative, absolute and mixed Explain what happens to a formula when copied, and use $ to lock a row or column.
  5. 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. 1 Workbooks, worksheets, rows, columns and cells About 12 min Start
  2. 2 Formulas and operators About 12 min Start
  3. 3 Common functions: SUM, AVERAGE, MAX, MIN and COUNT About 13 min Start
  4. 4 Cell references: relative, absolute and mixed About 13 min Start
  5. 5 Sorting, filtering and charts About 13 min Start
  6. 6 Entering data, AutoFill and number formats About 12 min Start
  7. 7 Percentages and everyday formulas: share, discount, profit and change About 13 min Start
  8. 8 Comparison operators and the IF function About 13 min Start
  9. 9 Managing worksheets and moving around quickly About 12 min Start
  10. 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.

Keep going

Privacy · Terms · Refunds · Delivery