Compare with 1 courses
Google Sheets for Beginners: Formulas, Sharing and Simple Dashboards

Google Sheets for Beginners: Formulas, Sharing and Simple Dashboards

Learn Google Sheets from scratch: enter and format data, write formulas, share safely, keep data clean, use pivot tables and build a simple dashboard. 50 written lessons plus 10 practice downloads.

£29.99

Learn more
Has discount
Expiry period Lifetime
Made in English
Last updated at Fri Oct 2026
Level
Beginner
Total lectures 60
Total quizzes 10
Total duration 11:42:00 Hours
Total enrolment 0
Number of reviews 0
Avg rating
Short description Learn Google Sheets from scratch: enter and format data, write formulas, share safely, keep data clean, use pivot tables and build a simple dashboard. 50 written lessons plus 10 practice downloads.
Outcomes
  • Create, organise and find spreadsheets in Google Drive, and import CSV and Excel files
  • Format data clearly with UK dates, pounds and percentages, and sort and filter it safely
  • Write formulas with SUM, AVERAGE, IF, COUNTIFS, SUMIFS, XLOOKUP and date and text functions
  • Share spreadsheets safely with the right roles, and use comments, version history and protected ranges
  • Keep data clean with drop-downs, tick boxes, conditional formatting and Google Forms
  • Summarise data with FILTER, UNIQUE and pivot tables, and check your figures
  • Make clear charts, scorecards and sparklines
  • Build, share and maintain a simple interactive dashboard
Requirements
  • A computer with a web browser (Windows, Mac, Chromebook or Linux)
  • A Google account (free) or a work or school Google Workspace account
  • No spreadsheet experience needed
  • The practice files are included: download each section's pack and import the files into Google Sheets

Learn something new every week

One short, practical tip each Thursday, plus news when new courses open. Free, and you can unsubscribe in one click.

We'll never share your email. See our privacy policy.