4.6 (39 ratings)58 students4h of videoAll levels
Learn how to organise data and calculate automatically with Google Sheets. Short, practical lessons cover cells, rows and columns, formatting, freezing, formulas such as SUM, AVERAGE, MAX, MIN and IF, sorting, filtering and charts, with hands-on practice in every module.
Course content
Module 1: Meet Google Sheets
- ● What is Google Sheets? Free preview 4:22
- 🔒 How to open Google Sheets 4:22
- 🔒 Create and name your first spreadsheet 4:22
- 🔒 Module 1 quiz Quiz
Module 2: Cells, Columns, Rows and Sheets
- 🔒 What is a cell? 4:22
- 🔒 What is a column? 4:22
- 🔒 What is a row? 4:22
- 🔒 What is a sheet? 4:22
- 🔒 Module 2 quiz Quiz
- 🔒 Module 2 assignment Assignment
Module 3: Know Your Sheets Screen
- 🔒 The menu bar and the toolbar 4:22
- 🔒 The Name box and the formula bar 4:22
- 🔒 The grid and the sheet tabs 4:22
- 🔒 Module 3 quiz Quiz
Module 4: Entering and Editing Data
- 🔒 Typing data into cells 4:22
- 🔒 Editing and deleting data 4:22
- 🔒 Copy, paste and drag to fill 4:22
- 🔒 Module 4 quiz Quiz
- 🔒 Module 4 assignment Assignment
Module 5: Working with Sheets
- 🔒 Rename a sheet 4:22
- 🔒 Add, duplicate and delete sheets 4:22
- 🔒 Move and colour sheet tabs 4:22
- 🔒 Module 5 quiz Quiz
Module 6: Formatting Cells
- 🔒 Bold, colour and alignment 4:22
- 🔒 Borders and merge cells 4:22
- 🔒 Number formats 4:22
- 🔒 Module 6 quiz Quiz
- 🔒 Module 6 assignment Assignment
Module 7: Rows and Columns
- 🔒 Resize rows and columns 4:22
- 🔒 Insert and delete rows and columns 4:22
- 🔒 Hide and unhide 4:22
- 🔒 Module 7 quiz Quiz
Module 8: Freezing Rows and Columns
- 🔒 What does freeze mean? 4:22
- 🔒 How to freeze a header row 4:22
- 🔒 How to freeze a column 4:22
- 🔒 Module 8 quiz Quiz
- 🔒 Module 8 assignment Assignment
Module 9: Introduction to Formulas
- 🔒 Every formula starts with equals 4:22
- 🔒 Using cell references 4:22
- 🔒 Formulas update automatically 4:22
- 🔒 Module 9 quiz Quiz
Module 10: SUM
- 🔒 What SUM does 4:22
- 🔒 How to use SUM 4:22
- 🔒 Practice: total a column 4:22
- 🔒 Module 10 quiz Quiz
- 🔒 Module 10 assignment Assignment
Module 11: AVERAGE and MEDIAN
Module 12: MAX and MIN
- 🔒 MAX: the highest number 4:22
- 🔒 MIN: the lowest number 4:22
- 🔒 Practice: top and bottom scores 4:22
- 🔒 Module 12 quiz Quiz
Module 13: The IF Function
- 🔒 What IF does 4:22
- 🔒 Pass or Fail example 4:22
- 🔒 Copy the formula down 4:22
- 🔒 Module 13 quiz Quiz
- 🔒 Module 13 assignment Assignment
Module 14: Auto-Sum and Automatic Calculation
- 🔒 The quick Auto-Sum method 4:22
- 🔒 Other functions in the menu 4:22
- 🔒 Why automatic calculation matters 4:22
- 🔒 Module 14 quiz Quiz
Module 15: Sorting and Filtering
Module 16: Simple Charts
Module 17: Sharing Your Spreadsheet
Module 18: Practice Task: Student Score Tracker
- 🔒 Set up the table 4:22
- 🔒 Step 1: Total column 4:22
- 🔒 Step 2: Average column 4:22
- 🔒 Step 3: Result column 4:22
- 🔒 Module 18 quiz Quiz
- 🔒 Module 18 assignment Assignment
Module 19: Final Project and Assessment
What learners say
I used to find spreadsheets intimidating, especially formulas and calculations. The course broke everything down into simple steps. I can now organise information and perform basic calculations without struggling.
I wanted a simple way to keep track of my business records. This course introduced me to practical ways of using Google Sheets for everyday business activities. Definitely worth learning.
The practical exercises made a big difference for me. I now understand how to work with rows, columns, formulas and tables. I wish I had taken this course earlier.
