Education 2.0 & 3.0

Want to make your spreadsheets more visually appealing by adding images? Here's how to insert an image into a cell in Google Sheets.

Via Gumersindo Fernández

Te contamos cómo sacar el máximo provecho a las hojas de cálculo de Google

Via Gumersindo Fernández

This guide is for Excel users who are migrating to Google Sheets.
It lays out the differences between the two spreadsheet tools in detail.
You’ll learn what features are the same across both tools, what exciting new features exist in Google Sheets, and what you won’t find in Google Sheets.
This guide will help you determine what you might need to change with your current processes and workflows.
The goal of this guide is to get you up to speed with Google Sheets as quickly as possible, with the least amount of effort.

Via Gumersindo Fernández

It is so frustrating to look up online the standards for something and to not have it in a spreadsheet format. A nicely organized PDF document is nice for printing but terrible for doing anything with it. Paper or PDF you probably need to by hand type into some sort of lesson planning guide. I am not doing that by hand! This is a handy skill. Try sharing a PDF of standards with your students and asking them to copy them into a spreadsheet and to clean up the data.

Via Gumersindo Fernández

A Student’s Guide to Using Google Sheets Using a spreadsheet is a life skill. In the real world, successful people use spreadsheets. I have created a Google Doc with 4 essential skills that if students can do just these 4 things they can use spreadsheets for assignments. Provide this guide to students along with the …

Via Tom D'Amico (@TDOttawa)

We know that data in spreadsheets isn’t always neatly distributed across entire rows and columns; oftentimes, for instance, sheets contai

Via Tom D'Amico (@TDOttawa)

Try this function for Google Sheets to convert a text string into a cell reference. When you need to construct not type your formula, use INDIRECT

Via Tom D'Amico (@TDOttawa)

Aprende a aplicar el formato condicional Google Sheets, básico tutorial con descarga de PDF práctico de la hoja de cálculo.

Via Gumersindo Fernández

Aquí os dejo una serie de OCHENTA Y CINCO vídeos en formato de píldoras muy cortas explicando funcionalidades concretas de las hojas de cálculo y empezando desde cero.

Recordad que tenéis una lista de (mini) videotutoriales parecida para GoogleDocs

Su objeto no es tanto formar un “curso”, aunque casi lo es, como servir de referencia rápida para resolver dudas puntuales para alumnos o usuarios.

Via Gumersindo Fernández

Te enseñamos cómo sacarle el máximo provecho a Google Sheets a través de nueve sencillos trucos.

Via Gumersindo Fernández

Entre los mas destacados se encuentra Moovly, un sitio web en el cual podrás tener la oportunidad de crear videos y animaciones de distinto tipo: promocionales, instructivos, para redes sociales, publicitarios, para YouTube, así como presentaciones. Todo esto sin la necesidad de instalar ningún programa en el ordenador.

Via Gumersindo Fernández

The way to do that is to use the "protect range" setting in Google Sheets. With that setting activated you can prevent your collaborators from editing a particular set of cells within your spreadsheet. I made a new video to demonstrate how to protect a range in Google Sheets, check it out!

Via Gumersindo Fernández

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

Via Tom D'Amico (@TDOttawa)