To add an image to a spreadsheet: 

• To add an image as a header, at the top, click View -> Freeze and specify the number of rows or columns to freeze. Click anywhere in the frozen section where you want the image.

• To add an image to the body of a spreadsheet, click anywhere on the spreadsheet.

  • At the top, click insert -> Image

  • Select an option:

    • Upload—Choose an image from your computer and click Open.

    • Take a snapshot—Use your webcam and click Take a snapshot.

    • By URL—Paste the image’s URL and click Select.

    • Your albums—Choose an image from an album and click Select.

    • Google Drive—Choose an image stored in Drive and click Select.

    • Search—Search for and choose an image and click Select.

(Optional) To resize the image, select the image and drag a point on the image border.

If you have text in a column that needs to be put into two columns (such as a full name that should be split to First Name and Last Name), the split text to columns feature is useful.

To split text to columns:

• Highlight the cells containing the text you want to split.

• Click on the Data menu in the top navigation bar, then select Split text to columns from the dropdown menu.

• In the Split text to columns dialog box that appears, select the delimiter that separates the text you want to split (e.g., comma, space, semicolon, etc.). If the delimiter is not listed, select Custom and enter the delimiter in the text box.

• Click Split to split the text into separate columns.

That's it! The text in the selected cells will now be split into separate columns based on the delimiter you selected.

Sorting and filtering data allows you to organize the information in your spreadsheet. It can be sorted numerically or alphabetically, or a filter can be applied to narrow down the data and hide the parts you don't need.

Types of sorting:

• Sort sheet - Organize all the data in your spreadsheet in one column. 

• Sort range - Sorts the data in a range of cells without affecting other content on the worksheet. 

If you have any header rows (first name, last name, address, ID #, etc.), be sure to freeze the row before you sort any data. 

To sort data in a Google Sheet, follow these steps:

• Highlight the cells that you want to sort. If you want to sort the entire sheet, click on the top-left corner of the sheet to select all cells.

• Click on Data -> Sort sheet by from the dropdown menu.

• In the Sort sheet by dialog box that appears, select the column you want to sort by from the Sort by dropdown menu. You can also select a second and third column to sort by, if needed.

• Choose whether you want to sort the data in ascending or descending order by selecting either A-Z or Z-A in the Order dropdown menu.

• Check the box next to Data has header row if your data includes headers and you want to sort the data based on those headers.

• Click the Sort button to apply the sorting to the selected cells.

After clicking Sort, the selected cells will be sorted based on the criteria you specified. The column you chose to sort by will be the primary sorting criteria, and any additional columns you selected will be used as secondary or tertiary sorting criteria.

To filter data:

• Select a range of cells in your spreadsheet

• Click Data -> Create a filter.

• To see filter options, go to the top of the range and click Filter

  • Filter by condition: Choose conditions or write your own.

  • Filter by values: To hide data points, uncheck the box next to the data point and click OK.

  • Search: Search for data points by typing in the search box. 

  • Filter by color: Choose which text or fill color to filter by. You can filter by conditional formatting colors, but not alternating colors.

To turn the filter off, click Data -> Remove filter.