• Free
  • CCC Computer Concepts
  • 6 lessons
  • About 1 h 43 min

Spreadsheet: Foundation

Foundation course on Spreadsheet (CCC Computer Concepts): the basics, explained from the start, following the CCC chapter.

About this course

Foundation course on Spreadsheet (CCC Computer Concepts): the basics, explained from the start, following the CCC chapter.

What you will learn, lesson by lesson

  1. Spreadsheets from zero: workbooks, sheets, rows, columns and cells Name the parts of a spreadsheet window, read and write cell addresses and ranges, and tell LibreOffice Calc and Microsoft Excel files apart.
  2. Entering data, selecting ranges, AutoFill and number formats Type text, numbers and dates correctly, select cells and ranges, fill series with the fill handle, and change how numbers look without changing their value.
  3. Formulas: operators, order of operations, relative and absolute references Write formulas that start with =, predict results using the order of operations, and copy formulas correctly with relative, absolute ($A$1) and mixed references.
  4. Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, ROUND and text functions Use the everyday functions to total, average and count a list, make a decision with IF, round results, work with text, and recognise the common error values.
  5. Sorting, filtering, freeze panes, charts and printing a sheet Arrange data with sort and filter, keep headings visible with freeze panes, choose the right chart for the data, and print a sheet neatly.
  6. Final self-assessment: Spreadsheet basics Test yourself on the whole course: 15 questions with answers explained.

Lessons in this course

  1. 1 Spreadsheets from zero: workbooks, sheets, rows, columns and cells About 14 min Start
  2. 2 Entering data, selecting ranges, AutoFill and number formats About 15 min Start
  3. 3 Formulas: operators, order of operations, relative and absolute references About 16 min Start
  4. 4 Functions: SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, IF, ROUND and text functions About 17 min Start
  5. 5 Sorting, filtering, freeze panes, charts and printing a sheet About 16 min Start
  6. 6 Final self-assessment: Spreadsheet basics About 25 min 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