Sheets 101
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Log into Google and then go to:
http://bit.ly/sheets101
and make a copy {File > Make a Copy}
2
NumberTaskTask DescriptionLink to Resource for HelpVideo TutorialI can do thisEven More
3
1Make a copy of a SpreadsheetMake a copy of the spreadsheet and give it a titlehttp://bit.ly/sheets101
Yes
4
2Find and ReplaceUsing the list of misspelled words, use the Find and Replace feature in spreadsheets to update your own spreadsheetHow toVIDEO
5
3
Remove duplicates with Add-Ons
Using the "Remove Duplicates" Add-On, clean up duplicate entries in your spreadsheetshttps://chrome.google.com/webstore/detail/remove-duplicates/bckmhokpcdnhhjldhhfpebhdfipmlbog?hl=enVIDEO
6
4Split namesUsing the "Split Names" Add-On, split the names in Column A into two columnshttp://www.ablebits.com/gs/split-names/howto.phpVIDEO
7
5Freeze Rows & ColumnsPractice freezing rows and columnshttps://support.google.com/docs/answer/54813?hl=en
8
6FilterFilter your data by sorting by A-Zhttps://support.google.com/docs/answer/1229641?hl=en
9
7FormulasUse the quicksum feature to calculate a total number in Column B of the worksheet labelled 7. https://support.google.com/docs/answer/66032?hl=en&ref_topic=1361471Function List
10
8Share the spreadsheetShare your spreadsheet with an elbow partnerhttps://support.google.com/drive/answer/2494822?hl=enVIDEO
11
9Get notified of changesSet up notifications on a spreadsheethttps://support.google.com/docs/answer/91588?hl=enVIDEO
12
BONUS ROUNDUse Autocrat for mail mergeLearn to use Autocrat to create a mail mergehttps://chrome.google.com/webstore/detail/autocrat/ppgnklghfnlijoafjjkpoakpjjpdkgdj?hl=en-USVIDEO
SAMPLE TEMPLATE (MAKE A COPY)
13
14
chrisbell.pro
15
edtechteam.com
16
17
18
19
Then text the total to 714-512-2355 - include your team # in your response.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Checklist
autoCrat_MergeData_DO_NOT_DELETE
NVScriptsProperties
2
3-6
7
BONUS ROUND
Learning Resources