Pre session: What I already know
bit.ly/1129SHEET
What did we do last time?
A quick game of memory
1
Cyborgs vs Humans
3
Cyborgs vs Humans
4
What we are going to achieve
5
1.0
Recap
Simple functions: Sum(), Average(), Filter & Sorting
Simple Formulas
Count() & Counta()
2.0
Charting
How to make a bar graph
3.0
Formatting
Wrap text, conditional formatting, and drop down menu
4.0
6
We’ve been hacked!
A whodunit story
7
Count() & Counta()
1
Click an open cell, and in that cell or in the formula bar on top, type an =, followed by the name of the function followed by an (
2
Next select (click and drag a box over) the values that you wish to count
3
Next type ) to close the formula and finally hit Enter
8
Count() & Counta()
4
The cell you entered the formula should now contain the count of cells in the selected range that contain numbers (count) or that aren’t empty (counta)
5
Suggested: Click on the cell next to the formula and label it
6
Next type ) to close the formula and finally hit Enter
9
Count() & Counta()
1
Click an open cell, and in that cell or in the formula bar on top, type an =, followed by the name of the function followed by an (
2
Next select (click and drag a box over) the values that you wish to count
3
Next type ) to close the formula and finally hit Enter
10
Count() & Counta()
4
The cell you entered the formula should now contain the count of cells in the selected range that contain numbers (count) or that aren’t empty (counta)
5
Suggested: Click on the cell next to the formula and label it
6
Next type ) to close the formula and finally hit Enter
11
Dear heavens, what is missing?!
What did we learn?
12
Charting
13
Charting
14
Charting
15
Charting
16
We’re getting closer. I can feel it.
17
“
Wrap text
18
Conditional Formatting
19
Drop Down Menu
20
Who did it?
21
22
Customer
Customer Service Rep
when finished, switch roles!
1. Select one challenge to the customer service rep that is on your paper
2. Determine what the challenge requires and then problem solve the customer’s wishes
23
Debrief
What we learned?
What do I want to know?
24
What I know now
bit.ly/1129SHEETS
25
Sandbox? More like funbox...
26
Now what?
Sandbox
Now is your chance!
27