Training Videos

Google Spreadsheets: Conditional Formatting


How do I color code cells so they automatically adjust as I enter data?

Select/highlight the cells that you want to color code. Select Conditional formating under Format. Format can be found across the top tool bar. Click the Text Contains box within the window that popped open. Choose the verbage that best describes the action you want to take. Click the small box to the left of Background (still within the box that popped open). Select the color you  would like to use. Click Add another rule (still within the box that popped open). Select the verbage that best describes the next action you want to take. Select the background color for this action. Continue until all additional rules are entered.

Google Spreadsheets: Average, Median, Standard Deviation



Google Spreadsheets: Freezing Rows and Columns

How do I freeze columns or rows?

Freezing rows and columns allows you to keep some of your data in the same place as you scroll through the rest of your spreadsheet. This is particularly useful if you have headings or labels that you'd like to keep in one place as you scroll through a large data set.

You can freeze up to ten rows or five columns in any particular sheet. Here's how:

  1. Go to the View menu.

  2. Then, point your mouse to Freeze rows... or Freeze columns....

  3. Select one of the options. When you scroll, you'll notice the frozen row(s) or column(s).

To unfreeze rows or columns, follow these steps:

  1. Go to the View menu.

  2. Then, point your mouse to Freeze rows... or Freeze columns....

Select the No frozen rows or No frozen columns option. When you scroll, you'll notice that there are no frozen row(s) or column(s).


How do I add columns?

To add a column to a spreadsheet, click on the gray area containing the column letter. Select the action that you'd like to complete from the drop-down menu (upside-down triangle). For example, to insert a blank column to the left of the column you selected, you'd select Insert 1 left from the drop-down menu. To delete a row or column, select Delete column from the drop-down menu.


How do I add rows?

To add a row to a spreadsheet, click on the gray area containing the number of the row. Select the action that you’d like to complete under INSERT. INSERT can be found across the toolbar at the top of the page. Select Insert above or Insert below to meet your needs.

Creating & Sharing a Document



Creating & Sharing a Collection



Creating a Comment



Are you interested in learning something specific not listed here in Google Docs/Calendar/Sites?  Contact Matt Townsley or Kathy Kaldenberg to setup one-on-one training.  Customized, self-paced tutorial videos can also be created to fit your needs. 

Videos created by Matt Townsley.  Printed directions created by Heather Groh and the Google Docs Help page.

Comments