Google Spreadsheets allows you to organize, edit and analyze different types of information using 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 with cells and cell content, including how to select cells, insert content, copy and paste cells, and more. Watch the video to learn how to navigate the Google Spreadsheets interface.
Every row and column of a new spreadsheet is always set to same height and width. As you begin to work with spreadsheets, you will find that these default sizes are not always well-suited to different types of cell content. Watch the video to learn about modifying columns, rows, and cells, including wrapping text and merging cells.
A quick how-to guide for sorting and filtering in Google Spreadsheet
A convenient and time-saving feature of Google Spreadsheets is its ability to add, subtract, multiply, and divide numerical information for you. Spreadsheets uses mathematical expressions called formulas that make handling these calculations easy. In this lesson, we are going to focus on formulas that contain one mathematical operator.
Most of the time you will be using a cell’s address in the formula. This is called using a cell reference. The advantage of using cell references is that you can change a value in a referenced cell and the formula will automatically recalculate. Using cell references in your formulas will make sure the values in your formulas are accurate. Watch the video to learn how to work with simple formulas in Google Spreadsheets.