Skip to content
menu
See all lessons

G Suite Certification: Sheets - Part 1

Learn to build, organize, and format a spreadsheet to prepare for the G Suite certification exam.
Time to complete

timer 45 - 90 minutes

Suitable for
  • High School
  • Adult Learners
Skills covered
  • Advanced formulas
  • Conditional formulas
  • Data analysis
  • Spreadsheet design
  • Spreadsheet organization
Using
  • Sheets
Lesson plans
Lessons
Lesson 1: G Suite Certification: Sheets - Part 1
  1. play_circle_filled Introduction to G Suite Certification: Sheets - Part 1
  2. play_circle_filled Sheets: Duplicate Your Sheet and Add New Data — Add, Delete and Insert Data
  3. play_circle_filled Sheets: Format and Organize Spreadsheet Data — Use Bold and Italics, Merge Cells, Set Alignment, and Format Dates
  4. play_circle_filled Sheets: Continue Formatting and Organizing — Freeze Cells, Columns, and Rows, Add Borders, Set Fill Color, Add Borders, and Change Fonts and Sizes
  5. play_circle_filled Sheets: Add Data Validation to Limit Options
  6. play_circle_filled Sheets: Sort Your Data — Name and Sort Sheets or Ranges
  7. play_circle_filled G Suite Certification: Sheets - Part 1 Wrap-Up
  8. assessment Reflection