Skip to content
menu
See all lessons

G Suite Certification: Sheets - Part 3

Learn advanced functions and conditional formatting 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 3
  1. play_circle_filled Introduction to G Suite Certification: Sheets - Part 3
  2. play_circle_filled Sheets: Copy Sheets Into Your Spreadsheet — Copy from .csv and .xls File Types
  3. play_circle_filled Sheets: Use Functions to Calculate Cost and Current Sales — Format Currency and View Function List
  4. play_circle_filled Sheets: Use Functions to Summarize Data and Calculate Profit
  5. play_circle_filled Sheets: Use the MIN, MAX, and AVERAGE Functions to Analyze Sales Data
  6. play_circle_filled Sheets: Add Conditional Formatting to Emphasize Data
  7. play_circle_filled Sheets: Insert Links, Images, Forms and Drawings
  8. play_circle_filled G Suite Certification: Sheets - Part 3 Wrap-Up
  9. assessment Reflection