Pin It

Everything Teachers Need to Know about Google Spreadsheets

I have received several requests on how to perform certain tasks on Google Spreadsheets and since I am really out of time to answer each of these requests I deemed it important to share with you these useful tutorials.

Working on Google Spreadsheets is a little bit tricky but practice makes better. My advice is to try out these tips each at a separate activity and then after a couple of days do it again and see how much you can remember.

You can also check our Spreadsheet section here in Educational technology and Mobile Learning to explore several other tutorials .
Without further ado, I ll let you explore the tutorials I brought you from Learn Free. Click on any title to access the correspondent tutorial. Enjoy

1- Getting started with Google Spreadsheets


In this lesson, you'll learn about the different ways you might use spreadsheets and how to navigate the Google Spreadsheets interface. You'll also learn the basic ways to work withcells and cell content, including how to select cells, insert content, copyand paste cells, and more.
2- Formatting Cells

In this lesson, you'll learn how to modify the size, style and color of text in your cells. You will also learn how to set text alignments, and how to addborders and background colors to your cells.
3- Working with Multiple Sheets

In this lesson, you'll learn how to create, rename, move, delete,and duplicate sheets.
3- Creating Simple Formulas

In this lesson, you'll learn how to create simple formulas that will add, subtract, multiply, and divide values. You will also be introduced to the basics of using cell references in formulas.
4- Creating Complex Formulas

In this lesson, you will learn how Google Spreadsheets follows the order of operations to solve complex formulas. You will also learn how to createcomplex formulas
5- Types of Cell References

In this lesson, you will learn about relative and absolute cell referencesand how to create and copy formulas that include them.
6- Working with functions

In this lesson, you will learn the basics of how to insert a function into a sheet by typing its name and by using the Functions button. You will also learn how to access the list of available functions.
7- Sorting and filtering data

In this lesson, you will learn how to sort data to better view and organize the contents of your spreadsheet. You will also learn how to filter data to display only the information you need.

0 comments : POST A COMMENT