Skip to content

2. Add Columns to Your Plan

Playback Speed:
Transcript

In this video, you will navigate a spreadsheet and learn some basic spreadsheet concepts.

Then, you’ll add *headings* to your spreadsheet and start setting up your job search plan.

Spreadsheets contain many rectangles called “Cells” that are organized into *rows* and *columns*.

A *row* is a horizontal set of cells that is labeled with a number.

A *column* is a vertical set of cells that is labeled with a letter.

Every cell has an *address* that is based on its position in the spreadsheet.

For example, this cell is called *A1* because it is in Column A, Row 1.

To navigate a spreadsheet, click on individual cells using the mouse.

Or, use the arrow keys to move up, down, left, and right.

You can add text, formatting, formulas, and functions to any cell.

To edit a cell, click on it.

A border appears around the cell.

Type in the cell and press “Enter.”

Now that you know a little about spreadsheets, add headings to your job search plan.

Click on the first cell in the spreadsheet and type “Task.”

Click on the next cell to the right.

Add a heading for “Deadline.”

To add *additional* columns, select one column in your sheet.

Then, select “Insert,” “Column,” and choose whether to add the new column to the right or the left of the selected one.

Label this column “Notes.”

To ensure that you can see the header row no matter where you are in the spreadsheet, *freeze* the top row.

First, select the row by clicking the row number.

Then, from the View menu, select “Freeze” and “up to current row”.

Now, you will be able to see the headings even as you sort or filter your spreadsheet.

Add additional headings for columns you need in *your* job search plan.

Then, move on to the next video where you will add tasks to your plan and customize the font styles and colors in your spreadsheet.

Now it’s your turn: Add headings for “Tasks,” “Notes,” and “Deadlines” to your spreadsheet.

Freeze the top row so you can always see it in the spreadsheet.

Add additional headings for columns you need in *your* job search plan.

Next
Instructions
  1. Add headings for “Tasks,” “Notes,” and “Deadlines” to your spreadsheet.
  2. Freeze the top row so you can always see it in the spreadsheet.
  3. Add additional headings for columns you need in your job search plan.