Spreadsheet Essentials

Categories: Data Skills
Share

About Course

Spreadsheets are the most useful tool in almost every office, yet most people only use a fraction of what they can do. This course takes you from a blank sheet to a tidy, working list with totals, averages and filters.

Everything works in Microsoft Excel and in free Google Sheets. There are four short lessons with a video, then a five-question quiz. Pass with 70% or more to unlock your certificate.

What Will You Learn?

  • Lay out a clean table with clear headings
  • Write SUM, AVERAGE and COUNT formulas
  • Use cell references so totals update by themselves
  • Sort and filter a list to find answers fast

Course Content

Getting set up

  • Rows, columns and cells
  • Your first formulas
    00:46

Working with lists