Home » Tag Archives: google sheets

Tag Archives: google sheets

Merge Data From Multiple Spreadsheets with vLookup Function

vLookup to merge data from multiple spreadsheets

vLookup: Quickly Find & Return Data When I find myself trying to pull together data from multiple spreadsheets, I frequently turn to using the vLookup function. VLookup can be used provided there is a unique value (search key) in both data sets. For example, a student identification number or email address. The vLookup function uses this search key to “lookup” ...

Read More »

From Google Sheets to Amazing Activities with Flippity

From Google Sheets to Amazing Activities with Flippity

If you’re looking for make and take activities that can be customized from ready-to-use templates, Flippity is the place to go! Created by experienced World Language teacher turned Tech Integration Specialist, Steve Fortua, Flippity boasts dozens of activities and tools that will have you re-thinking the potential of Google Sheets. The site contains dozens of activities, games and teacher tools ...

Read More »

Formatting Google Sheets for Readability

Google Sheets Formatting Readability

Formatting Google Sheets Using simple formatting techniques Google Sheets users can create spreadsheets that are easier to read and more effective for viewing and display data. Working with spreadsheet data doesn’t have to be intimidating. As educators, we often need to collect, analyze and visualize data to truly understand trends in our classrooms, schools or districts. I’ve compiled some tips for Google ...

Read More »