Skip to content
SiteSmith University
Sign up

SiteSmith Sheets

Track numbers, write formulas and share spreadsheets from your Drive

  • Beginner
  • 15 lessons
  • About 1 hr 21 min
  • Certificate of completion

Taught by SiteSmith

What you'll learn

  • Enter and edit data, select ranges and move around a sheet
  • Write formulas with cell references, ranges and functions, and read the errors they can show
  • Use SUMIF, COUNTIF, VLOOKUP and XLOOKUP on real data
  • Fill formulas down and use absolute references where they're needed
  • Format numbers and cells, sort, freeze headers and find and replace
  • Work with several sheets, import and download CSV files, share by link and restore versions

About this course

This course is for anyone who keeps a list, a budget or an order log in SiteSmith Workspace. No spreadsheet experience needed.

You'll learn how cells, ranges and sheets work, how to write formulas with help as you type, which functions Sheets has (from SUM to VLOOKUP and XLOOKUP), and why some references need a dollar sign. Then you'll format, sort and freeze your data, import and download CSV files, and share a spreadsheet by link.

Curriculum

4 sections · 15 lessons

  1. 1. Getting started

    3 lessons

  2. 2. Formulas

    5 lessons
    • How a formula worksAnimated · 3 min
    • Write formulas with help as you typeReading · 7 min
    • The functions Sheets hasReading · 8 min
    • Filling formulas and absolute referencesAnimated · 3 min
    • Quiz: formulasQuiz · 6 min

  3. 3. Formatting and organizing

    4 lessons
    • Format numbers, text and cellsReading · 5 min
    • Sort, freeze and findReading · 6 min
    • Work with several sheetsReading · 4 min
    • Quiz: formatting and organizingQuiz · 4 min

  4. 4. Import, export and sharing

    3 lessons
    • Import and download CSV files, and printReading · 5 min
    • Share a spreadsheet and use version historyReading · 4 min
    • Course checkQuiz · 10 min

Your instructor

SiteSmith

Site Smith Official