Skip to content
menu
See all lessons

G Suite Certification: Sheets - Part 2

Learn spreadsheet functions, filters, and charts 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
  • Spreadsheet design
  • Spreadsheet organization
Using
  • Sheets
Lesson plans
Lessons
Lesson 1: G Suite Certification: Sheets - Part 2
  1. play_circle_filled Introduction to G Suite Certification: Sheets - Part 2
  2. play_circle_filled Sheets: Create Filters and Use Filter Views
  3. play_circle_filled Sheets: Use Filters to Count, Add, and Summarize Data in a Table — Use Sheets and COUNT
  4. play_circle_filled Sheets: Use the SUM Function to Analyze Data
  5. play_circle_filled Sheets: Display Data in a Chart — Create, Insert, and Modify Charts, and Protect Sheets and Ranges
  6. play_circle_filled Sheets: Use COUNTIF to Generate Numeric Data with Text Values
  7. play_circle_filled Sheets: Share and Collaborate — Add Comments, View Revision History, and Download Spreadsheets as File Types
  8. play_circle_filled G Suite Certification: Sheets - Part 2 Wrap-Up
  9. assessment Reflection