iGeneration - 21st Century Education (Pedagogy & Digital Innovation)
1.2M views | +19 today
Follow
iGeneration - 21st Century Education (Pedagogy & Digital Innovation)
Teaching and learning in the 21st Century - meeting the pedagogical challenges of digital learning and innovation for the iGeneration
Your new post is loading...
Your new post is loading...
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

New intelligent suggestions for formulas and functions in Google Sheets

New intelligent suggestions for formulas and functions in Google Sheets | iGeneration - 21st Century Education (Pedagogy & Digital Innovation) | Scoop.it
Quick summary  You’ll now see in-line, sequential, context-aware suggestions for formulas and functions when working with data in Googl
No comment yet.
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

Keep Formatting In Google Form Response Sheets by Kim Pollishuke

Have you ever been annoyed trying to wrap the text in a Form's Response Sheet each time a new row of data appears? Do you wish the shee
No comment yet.
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

Using COUNTIF in Google Sheets

Using COUNTIF in Google Sheets | iGeneration - 21st Century Education (Pedagogy & Digital Innovation) | Scoop.it
The COUNTIF spreadsheet function is very useful for counting the values within a given range that match a given criterion. Take a look at the spreadsheet in the first figure. It s a list of scores from an online quiz, each result marked out of 100.
No comment yet.
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

Google spreadsheets function list - Enhance your spreadsheets!

No comment yet.
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

Using Formulas and Conditional Formatting in Google Sheets via Erin Whalen

Using Formulas and Conditional Formatting in Google Sheets via Erin Whalen | iGeneration - 21st Century Education (Pedagogy & Digital Innovation) | Scoop.it
Part of my job is keeping track of upcoming events. I use Google Sheets to help me by adding formulas and conditional formatting to my travel spreadsheet. 
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

Using VLOOKUP in Google Sheets

Using VLOOKUP in Google Sheets | iGeneration - 21st Century Education (Pedagogy & Digital Innovation) | Scoop.it
No comment yet.
Scooped by Tom D'Amico (@TDOttawa)
Scoop.it!

How To Get an Item Count in Google Sheets

How To Get an Item Count in Google Sheets | iGeneration - 21st Century Education (Pedagogy & Digital Innovation) | Scoop.it
Here's a quick and dirty formula you can use in Google Sheets to get a running count of cells that contain any value (numbers, dates, text, links, etc.).
No comment yet.