Official Certification Course

Become a googlesheets Developer

Master googlesheets with our comprehensive, free interactive course. Pass the exam to earn your industry-recognized certificate. Includes interactive examples, quizzes, and a verifiable digital certificate upon completion.

googlesheets

Course Syllabus

1Google Sheets Tutorial
2Google Sheets Introduction
3Google Sheets Get Started
4Google Sheets Overview - Ribbon and Sheet
5Google Sheets Syntax
6Google Sheets Ranges
7Google Sheets Fills
8Google Sheets Double Click to Fill
9Google Sheets Move Cells
10Google Sheets Add Cells
11Google Sheets Delete Cells
12Google Sheets Undo and Redo
13Google Sheets Formulas
14Google Sheets Relative and Absolute References
15Google Sheets Absolute References
16Google Sheets Addition Operator
17Google Sheets Subtraction Operator
18Google Sheets Multiplication Operator
19Google Sheets Division Operator
20Google Sheets Parentheses
21Google Sheets Functions
22Google Sheets Location Settings
23Google Sheets Formatting
24Google Sheets Format Painter
25Google Sheets Format Colors
26Google Sheets Format Fonts
27Google Sheets Format Font Color
28Google Sheets Format Fonts Size
29Google Sheets Format Fonts Characteristics
30Google Sheets Format Borders
31Google Sheets Format Numbers
32Google Sheets Format Gridlines
33Google Sheets Clear Format
34Google Sheets Sort
35Google Sheets Sort Sheet By Column
36Google Sheets Sort Range By Column
37Google Sheets Sort Range
38Google Sheets Conditional Formatting
39Google Sheets Single Color Formatting
40Google Sheets Color Scale Formatting
41Google Sheets AND Function
42Google Sheets AVERAGE Function
43Google Sheets AVERAGEIF Function
44Google Sheets AVERAGEIFS Function
45Google Sheets COUNT Function
46Google Sheets COUNTA Function
47Google Sheets COUNTBLANK Function
48Google Sheets COUNTIF Function
49Google Sheets COUNTIFS Function
50Google Sheets IF Function
51Google Sheets IFS Function
52Google Sheets MAX Function
53Google Sheets MEDIAN Function
54Google Sheets MIN Function
55Google Sheets MODE Function
56Google Sheets OR Function
57Google Sheets STDEV.P Function
58Google Sheets STDEV.S Function
59Google Sheets SUM Function
60Google Sheets SUMIF Function
61Google Sheets SUMIFS Function
62Google Sheets VLOOKUP Function
63Google Sheets XOR Function

Certificate of Completion

Pass the exam with 70% or higher to earn your official, verifiable certificate.

Exam Duration30 Mins
Questions20-30
Passing Score70%

Why learn googlesheets?

  • High demand in the job market
  • Core technology for web development
  • Foundation for advanced frameworks