Outline- Microsoft Excel Class #1 - Study Chapter 1 on Excel

Intro to Excel and Spreadsheets (Worksheets)
  1. Open the Excel program, and then in a new Excel workbook, type in this file - Auto_Sales_Your_Name.xlsx . Save it in My Documents in a folder called "Excel Your Name". Put in your own name.

    2.   A B C D E
    1 Rio Rancho Auto Gallery    
    2 First Quarter Sales by Vehicle Type    
    3 Type January February March Totals
    4 Sedans

    330373.42

    289076.3

    271717.67

     

    5

    SUVs

    185835.76

    161446.98

    140408.67

     

    6

    Trucks

    309725.48

    272558.89

    330373.58

     

    7

    Convertibles  

     

     

     

     

    8

    Totals  

     

     

     

     

  2. Parts of a Window: Office Button, Ribbon, Name Box, Formula Bar, Active Cell, Worksheet Names
  3. Naming Cells:
    1. Columns have letters at the top; Rows have numbers on the left. Cell Name is the column followed by the number. Example: C1
    2. Cell Name is different from the Contents of a Cell
  4. Selecting a Range – example: C3:C7 means cell C3 thru C7. To select, drag (highlight) the cells.
  5. Cell Content: Values (Text or Numbers) or Formulas
  6. Formulas (computations) are different from Functions (e.g. Sum, Average)
  7. AutoSum button and Calculations Area of the Status Bar
  8. Make some Changes "January" becomes "Jan", etc.
    (Ways to make changes: a) Double click in cell, b) Click in cell, then change in Formula Bar, c) Click in cell, then press F2 key). Note that you can use "Autofill" when typing in months or days.

  9. Remember, Save it as needed.
  10. Make some more Modifications:
    1. Inserting a Row before row 4 by right clicking on the row header: Compacts, 326485.76, 376984.92, 367540.58
    2. Deleting Rows: Delete the "Convertibles" row - Click in row 8, Home Tab - Delete (or right click)
    3. Insert a Row for "Averages" before the Totals row(rt-click): - Click on Row header, then rt-click and enter
    4. Insert a Column after the "Totals" column for "Averages". Insert formulas as shown in class, and use the "Fill Handle" to copy to multiple cells.
  11. Charts - Select A3:E8, and Insert Tab, Charts Group, Column, and create a chart. Move the chart under the data.
  12. Printing -
    13. Page Layout, margins, orientation, size, print titles (header/footer, sheet, gridlines)
    Print: Office Button, Print Preview - zoom, margins, page break preview, print, close
    Print - page range, print what, copies, properties

  13. Add another Worksheet! - Bottom Sheet Tabs, on the right - Insert a new worksheet in this workbook