Spreadsheet Basics

By Learning Hub Academy6 lessons39 min

Start from zero with Excel or Google Sheets. Learn to create and save a file, find your way around, type and tidy data, write your first formulas, sort and filter a list, and print or share it safely. Then insert, delete and hide rows, use Find and Replace, remove duplicates, highlight cells and make your first chart. No experience needed.

  • Digital skills
  • Data and reporting

What you'll learn

  • Create, name and save a spreadsheet, and find your way around cells, rows, columns and tabs
  • Type and tidy data with clean numbers and dates, the fill handle and number formats
  • Write your first formulas and functions, and use AutoSum
  • Sort and filter a list, and print, save as PDF or share it with the right access
  • Insert, delete and hide rows, use Find and Replace and remove duplicates
  • Make your first column or line chart

The basics

  1. 1

    Getting Started

    6 min9 text and a 5-question quiz

  2. 2

    Entering and Tidying Data

    7 min9 text and a 5-question quiz

Using your data

  1. 3

    Your First Formulas

    7 min9 text and a 5-question quiz

  2. 4

    Sort, Filter and Share

    7 min9 text and a 5-question quiz

  3. 5

    Rows, Find and Highlight

    7 min7 text and a 5-question quiz

  4. 6

    Your First Chart

    5 min6 text and a 5-question quiz

The final assessment opens once every lesson is done.

What learners say

A sample review, shown until learners share their own.

  • Sample

    “I had never used a spreadsheet. By the end I made my first chart. I'd like a few more practice examples.”

    Neha