Technology In-Service






 

Marketing

Business CAM

Technology
In-Service

 

 

Introduction to Excel

Objectives:

To learn more try going to MS Excel Tutorials

To see an example of a spreadsheet that I use in personal finance to track stocks click here.

  • Change column width.
  • Position text within a cell by wrapping, rotating, indenting, and aligning.
  • Change the appearance of cells using fonts, styles, colors, and borders.
  • Designate the format of a cell to accommodate different kinds of text and numerical data.

Open up Step 2.1 for this lesson

  1. Increase the width of column D by using mouse pointer.
  2. Select column B through D. Choose Format / Column / Width - Key in "10" in the Column width box -Click OK
  3. Change the height of row 18 by placing your cursor on the bottom edge of the row. Drag until label reads Height: 18.00.
  4. Go to cell A20. Go to Format / Column / AutoFit Selection - Excel will determine the best width of the column.

 

  1. Go to A22 - Choose Cells / Format / Alignment - Click the Wrap text box and click OK. The text wraps in the cell and the cell height adjusts automatically.
  2. Highlight B3:D3 - Choose Format / Cells and click on the Alignment tab (It should already be clicked).
  3. In the Orientation section, key 45 in the Degrees text box and click OK.
  4. Change the width of columns B through D to 8.

 

  1. Move to A5 and click the Increase Indent button on the toolbar. Highlight A10:A16 and indent the text. Select B3:D3 adn click the Center button. Highlight A7 and click the Align Right button. Right align A17, A19, and A20.
  2. Select A1:D1. Click the Merge and Center button on the toolbar.
  3. Merge and Center the Third Quarter Budget across A2:D2.

 

  1. Select A1:D1 (Which is now merged into one cell)
  2. Change the font color to green using the Font Color button on the toolbar
  3. While the cells are still highlighted, change the fill color to Gray-25%

 

  1. Placing a border around Cell A4 by going to the Borders button on the toolbar and selecting the outline border from the drop-down arrow.
  2. Do the same for A9

 

  1. Select B5:D5 and choose Format / Cells. Click on the Number tab and click Currency in the Category list and click OK.
  2. Change the width of columns B through D using AutoFit.
  3. Change the format of B20:D20 to Currency
  4. Select the range B6:D19 and open the Format Cells dialog box and click on the Number tab. Click Number in the Category list box. Click the Use 1000 Separator (,).

 

Objectives

  • Using formulas (Auto Sum feature)
  • Understanding Relative and Absolute cell references
  • Graphing

Open the file budget.

Review - Widen the column width to make sure all data is visible. Change the format of appropriate cells to Currency. Use the indent feature to seperate sub-directories.

 

Objectives

Making an organizational chart. Insert / Object and then select MS Organization Chart 2.0