The Microsoft Excel Tutorial
Microsoft Excel is an electronic spreadsheet. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly.
As a tutor, I would start with basics of excel which is to learn spreadsheet;
So let’s get started digging into what makes a spreadsheet work. Spreadsheets are made up of
- columns
- rows
- and their intersections are called cells
In each cell there may be the following types of data
- text (labels)
- number data (constants)
- formulas (mathematical equations that do all the work)
- In a spreadsheet the COLUMN is defined as the vertical space that is going up and down the window. Letters are used to designate each COLUMN’S location.
Worksheets
Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576.
The Formula Bar
If the Formula bar is turned on, the cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar. Cell entries display on the right side of the Formula bar. If you do not see the Formula bar in your window, perform the following steps:
- Choose the View tab.
- Click Formula Bar in the Show/Hide group. The Formula bar appears.
EXERCISE 1
Move Around the Worksheet
The Down Arrow Key
- Press the down arrow key several times. Note that the cursor moves downward one cell at a time.
The Up Arrow Key
- Press the up arrow key several times. Note that the cursor moves upward one cell at a time.
The Tab Key
- Move to cell A1.
- Press the Tab key several times. Note that the cursor moves to the right one cell at a time.
The Shift+Tab Keys
- Hold down the Shift key and then press Tab. Note that the cursor moves to the left one cell at a time.
The Right and Left Arrow Keys
- Press the right arrow key several times. Note that the cursor moves to the right.
- Press the left arrow key several times. Note that the cursor moves to the left.
Page Up and Page Down
- Press the Page Down key. Note that the cursor moves down one page.
- Press the Page Up key. Note that the cursor moves up one page.
The Ctrl-Home Key
- Move the cursor to column J.
- Stay in column J and move the cursor to row 20.
- Hold down the Ctrl key while you press the Home key. Excel moves to cell A1.
Go To Cells Quickly
The following are shortcuts for moving quickly from one cell in a worksheet to a cell in a different part of the worksheet.
I hope this tutorial gives the right and adequate info to learn the very basics for excel for CIS 3810 class.