Microsoft Excel

1
Microsoft Excel
Tutorial by Thomas Cho
2
Starting Microsoft Excel
1. Click on Start -- Programs -- Microsoft
Excel 2.        The Menu bar is directly below
the Title bar and displays the menu. The Menu bar
gives instructions to the software. 3.       
Toolbars provide shortcuts to menu commands.
Toolbars are generally located just below the
Menu bar. 4.        Microsoft Excel consists of
worksheets. Each worksheet contains columns and
rows. The columns are lettered A to IV the rows
are numbered 1 to 65536. The combination of
column and row coordinates make up a cell
address. 5.        You can use arrow keys to
transfer to other columns. You can also do this
by using your mouse. 6.        If you wish to
perform a function on a group of cells, you must
first select those cells by highlighting
them.        
3
Numbers and Mathematical Calculations
1.     Click on Tools, which is located on the
Menu bar. Go to options, and then click edit.
Make sure that the box Move Selection after
Enter" is highlighted. 2. In Microsoft
Excel, you can enter numbers and mathematical
formulas into cells. When a number is entered
into a cell, you can perform mathematical
calculations such as addition, subtraction,
multiplication, and division. When entering a
mathematical formula, precede the formula with an
equals sign. Use the following to indicate the
type of calculation you wish to perform
Addition - Subtraction Multiplication /
Division Exponential 3.       The F5 function
key is the "Go To" key. If you press the F5 key
while in the Ready mode, you will be prompted for
the cell you wish to go to. Enter the cell
address, and the cursor will jump to that cell.
4
Addition and Subtraction
       Subtraction 1. Press F5. The Go To
dialog box will appear. 2. Type B1. 3.
Press Enter. 4. The cursor should move to cell
B1. 5. Type 5 in cell B1. 6. Press Enter.
7. Type 3 in cell B2. 8. Press Enter. 9.
Type B1-B2 in cell B3. 10. Press
Enter. Note that cell B1 has been subtracted
from B2 and the result is shown in cell B3.

• Addition
• Move the cursor to cell A1.
• Type 1.
• Press Enter.
• Type 1 in cell A2.
• Press Enter.
• Type A1A2 in cell A3.
• Press Enter.
• Note that cell A1 has been added to cell A2 and
  the result is shown in cell A3

5
Multiplication and Division

•         Division
• Press F5.
• Type D1.
• Press Enter. You should now be in cell D1.
• Type 6 in cell D1.
• Press Enter.
• Type 3 in cell D2.
• Press Enter.
• Type D1/D2 in cell D3.
• Press Enter.
• Note that D1 is divided by D2 and the answer is
  displayed in cell D3.

• Multiplication
• Hold down the Ctrl key while you press "g"
  (Ctrl-g). The Go To dialog box will appear.
• Type C1.
• Press Enter. You should now be in cell C1.
• Type 2 in cell C1.
• Press Enter.
• Type 3 in cell C2.
• Press Enter.
• Type C1C2 in cell C3.
• Press Enter.
• Note that C1 is multiplied by C2 and the answer
  is displayed in C3.

6
Trying automatic calculation

• Hold down the Ctrl key while pressing Home
  (Ctrl-Home). This will move you to cell A1.
• Type 2. Press the Tab key.
• Note that the results shown in cell A3 have
  changed. The number in cell A1 has been added to
  the number in cell A2 and the results display in
  cell A3.
• You should now be in cell B1.
• Type 6. Press the Tab key.
• Note that the results shown in cell B3 have
  changed. The number in cell B1 has been
  subtracted from the number in cell B2 and the
  results display in cell B3.
• You should now be in cell C1.
• Type 4. Press the Tab key.
• Note that the results shown in cell C3 have
  changed. The number in cell C1 has been
  multiplied by the number in cell C2 and the
  results display in cell C3.
• You should now be in cell D1.
• Type 12. Press the Tab key.
• Note that the results shown in cell D3 have
  changed. The number in cell D1 has been divided
  by the number in cell D2 and the results display
  in cell D3.

7
Formatting numbers

• Move the cursor to cell A5.
  Before formatting. --
• Type 1234567.
• Press Enter.
• Move the cursor back to cell A5.
  After formatting--
• Click on Format, which is located on the Menu
  bar.
• Press the down arrow key until Cells is
  highlighted. 
• Press Enter.
• Click on the Number tab, if it is not in the
  front.
• Click on Number in the Category box.
• Type 2 in the Decimal Places box. This will cause
  the number to display with two decimal places.
• Place a checkmark in the Use 1000 Separator box.
  This will cause thousands to be separated with
  commas.
• 12. Click on OK.

8
Alternate methods

• Move the cursor to cell A6. (note the
  decimal point)
• Type 1234567.
  (changed to a percent)
• Press Enter.
• Move the cursor back to cell A6.
• Click twice on the Increase Decimal icon to
  change the number format to two decimal places.
  Clicking on the Decrease Decimal icon decreases
  the decimal places.
• Click once on the Comma Style icon to add commas
  to the number.
• To change the number to a currency format, click
  on the Currency Style format.
• Move the cursor to cell A7.
• 9. Type .35 (note the decimal point). 
• 10. Press Enter.
• 11. Move the cursor back to cell A7.
• 12. Click on the Percent Style icon to turn .35
  to a percent.

9
Adding a dollar sign to the numeric entry

• Move the cursor to cell A5.
• Click on Format, which is located on the Menu
  bar.
• Press the down arrow key until Cells is
  highlighted.
• Press Enter.
• Click on the Number tab, if it is not in the
  front.
• Click on Currency in the Category box.
• Make sure there is a "" in the Symbol box.
• Click OK.

10
The End