Lesson 2 Excel notes

Cell content – will vary according to the spreadsheet

Budget – estimate of both income and expenses over a period of time. Excel is a great for doing this especially if you use formulas so that you can play the What If game.

Functions – are built in formulas in Excel; Sum, Average, Min, Max: remember that you need a group of cells (Range) selected for these functions to work: advantage of built-in formulas is that you don’t have to remember them and they are quicker to use. (Show examples of how to use in everyday life.)

You can always Edit the content of a cell by Double Clicking on the cell

If you want to remove all data (Clear) from a cell just select it and hit Delete (same as Clear Contents button)

Use Find and Replace when you want to find something quickly in a large spreadsheet, Home>Editing>Find & Replace is where you go to do this just like in Word.

Moving cells – select the cells and place the pointer over the cells until it looks like a 4 headed arrow, hold the mouse down then just drag over to the new place and release the mouse.

Cut, Copy, Paste and Clipboard do the same things here as before.

Delete Rows or Columns – remember that when you delete rows or columns that you delete not only the content of the cells but the row or column itself. This is different than just deleting the contents of a cell. Home>Cells>Delete>Delete Cells

Inserting Rows or Columns – remember the direction that the current row or column will move when you insert a new one. Row- down, Column – right Home>Cells>Insert>choose type of insert

You can insert just a cell but be careful as other cells will shift and possibly not line up, usually done with a Rt. Click on a cell then choose the direction you want to shift things.

Fill Handle – used to insert repeated content into several cells at one time. To use; Select cells then move the cursor to the lower right corner and it will look like a Plus sign, hold mouse and drag until you get to desired location and release mouse. (Ctrl +R or Ctrl + D)

Hyperlink – way to connect to another file or location. Could be worksheet, workbook or internet and makes it easy to find related files