ABDEFGHIJ
1
Accomplishing Great Feats With Google Sheets! - 3 experience points.
2
Below you will find several topics and tasks of varying levels. Each topic has a corresponding support page that will walk you through the topic as well as a task to complete. Feel free to use the "practice" sheet to complete your tasks. Once you have reviewed the topic and completed the task put an "X" in column "A."
3
Check Off
with an X
Topic #Difficulty LevelXPTitleDescriptionBadge
Check Off
Support PageTask Details
4
x11Create a Google Sheet!Starting from ground 0....learn how to create a new sheet.#REF!Support PageTask Details
5
2★★4What's in a Name?Brush up on some common terms associated with Google Sheets.Support PageTask Details
6
x3★★★2I Want It My WayDiscover how to format data you've added to a spreadsheet.#REF!Support PageTask Details
7
4★★★★★5Average, Sum, Count, & If, What's Your Function?Use Formula and Functions including Sum, Average, Unique, Count, IfSupport PageTask Details
8
5★★★3I Want It My Way (Part 2)Arrange your data just the way you'd like with the sorting feature.Support PageTask Details
9
6★★★3Chart How Awesome You Are With a ChartAnalyze the Data in a Google Sheet by inserting Charts and GraphsSupport PageTask Details
10
7★★★4How to be TrendyAdd a trendline to your data to recognize patterns.Support PageTask Details
11
8★★★★4Add a chart, graph, or table to Google DocsDiscover how to insert a chart, graph, or table from Google Sheets into a Doc or Presentation.Support PageTask Details
12
9★★★2It's Official!Publish Results from a Google SheetSupport PageTask Details
13
10★★2Why Work Alone?Share your data with others to keep them informed.Support PageTask Details
14
11★★★★4Hands Off!Protect sheets and ranges in your datasheet to ensure your data does not get deleted or changed.Support PageTask Details
15
12★★★3Label a RangeLearn how to label a range of cells in a datasheet.Support PageTask Details
16
13★★★★4Too Much Data!Use filters and filter views to see only the data you need.Support PageTask Details
17
14★★★★4Sparklines: SparkNotes VersionUse Sparklines to show trand data in your spreadsheets.Support PageTask Details
18
15★★★3Flubaroo Your Quiz!Use Flubaroo to grade the responses to a Google FormSupport PageTask Details
19
16★★★★4Ooh! Pretty Colors!Learn to take advantage of conditional formatting to draw attention to your data.Support PageTask Details
20
17★★★★★5Pivot Your Stance on Pivot TablesUse a pivot table to view a complex set of data quicklySupport PageTask Details