Pin It

Everything Teachers Need to Know about Google Spreadsheets

Here are some good  tutorials we 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

Note: Only a member of this blog may post a comment.