Tuesday, October 11, 2011

Excel tutorial #1 - spreadsheets

In order to work successfully with spreadsheets, one needs to understand how they are organized. This blog post is designed to provide a working knowledge of spreadsheet organization and to introduce basic terminology you will need for mastering Excel. Scroll to the bottom of this post to see a labeled screenshot of an example spreadsheet.

Data is arranged in a spreadsheet in rows and columns. Rows are addressed by number and run from left to right; columns are addressed by letter and run from top to bottom. You can't change the row and column designations in spreadsheets.

The intersection of a row and a column is called a cell. Each cell is addressed by first its column name and then by its row number as in C1 or E4 (you sank my Battleship!).

A range of cells starts with the top left cell name and ends with the lower right cell name. For example, A2:D4 refers to the group of cells bounded by corner cells A2, D2, A4, and D4. The range includes all of the cells A2, A3, A4, B2, B3, B4, C2, C3, C4, D2, D3, and D4.

The name box is located above cell A1. The name of the active cell (the cell where your mouse cursor is) will be displayed in the name box. Cell A1 is also known as the home cell.

To the right of the name box is the formula bar. This is where you can edit and view the formula associated with the active or selected cell.

An Excel file is called a workbook. Each Excel workbook can have one to many worksheets in it. When you create a new workbook, Excel provides you with three worksheets by default and they are named Sheet 1, Sheet 2, and Sheet 3. You can easily change the name of one or more worksheets simply by right clicking on the sheet's tab to pop up the context menu and selecting Rename. You can insert additional worksheets as necessary with the insert worksheet tab. Worksheets can also be deleted, moved, and copied, as desired.

As in Word, you can change the magnification of the display by adjusting the zoom slider in the lower right corner.

Click for an enlarged image