1 of 8

MASTER GOOGLE SHEET

BEGINNER TO EXPERT LEVEL

2 of 8

OUTLINE OF THE COURSE

4

​

​

​

​

​

​

​

DATA PRESENTATION / VISUALIZATION

3

​

​

​

​

​

​

​

DATA PROCESSING/ ANALYSIS

​

​

​

​

​

​

​

1

DATA ENTRY

​

​

​

​

​

​

​

DATA MANIPULATION

2

3 of 8

DATA ENTRY

1

​

​

​

COLLABORATION

#SHARING EDITING/COMMENTING�#PROTECTING SHEET & RANGE�# HISTORY VERSION

2

DATA VALIDATION

#DROP DOWN LIST�#DATE�#CHECK BOX

​

3

GOOGLE FORM

#DESIGNING QUESTIONS�#SHARING FOR COLLECTION OF DATA�#VIEW RESPONSES

4

COPY CUT PASTE

DATA COPY CUT PASTE

4 of 8

DATA MANIPULATION

5 PAGE & PRINT

4 RENAME SHEET , ADD DELETE SHEET, HIDE UNHIDE SHEET, ADD DELETE ROW COLUMN

​

​

1 DATA SORTING

2 DATA FILTERING

3 DATA FREEZING

5 of 8

DATA PROCESSING: FUNCTIONS AND FORMULA

MATH

CONDITIONAL

TEXT

DATE

LOOKUP

AVERAGE()

COUNTIF()

COUNTA

DATE()

VLOOKUP()

MAX()

COUNTIFS()

LEN()

DATEDIF()

HLOOKUP()

MIN()

SUMIF()

LEFT()

EOMONTH()

INDEX()

ROUND()

SUMIFS()

RIGHT()

EDATE()

MATCH()

COUNT

IF

MID()

TODAY()

​

SUM

IFS

TRIM()

NOW()

​

SUBTOTAL()

​

SPLIT()

​

​

​

​

CONCATENATE()

​

​

6 of 8

DATA PRESENTATION

CHART

TABLE

GRAPH

PIVOT TABLE

7 of 8

DATA ANALYST

DESTINATION TO BECOME A

8 of 8

Valedictory Session