Click on UNDERLINED TITLES BELOW to access those tutortial sections.

  • Spreadsheets

    1. What are they?
    2. Some ways a teacher can use Excel.

  • Basic Excel Screen Features

    1. Description of basic Excel sheet icons.

  • Controlling Column and Row Size

    1. To change the width of a column
    2. Insert a heading
    3. Change row size
    4. Selecting areas of an Excel worksheet
    5. Applying grid lines to cells
    6. Renaming work sheets

  • Headings in Worksheets

    1. Putting main heading in worksheet
    2. Including other titles in worksheets
    3. Including headings from page to page
    4. Inserting new rows and columns
    5. Deleting rows and columns

  • Entering Data into Cells

    1. Putting text into cells
    2. Assigning properties to groups of cells
    3. Typing text in cells
    4. Money figures using Currency Style
    5. Working with decimals and commas

  • Working With Text Lists

    1. Entering a list
    2. Sorting a single text column
    3. Sorting two columns together
    4. Sorting three or more columns together

  • Working With Numerical Data

    1. Applying changes to columns and rows
    2. Sorting a numerical data
    3. Preparing a work area
    4. Sorting more then two columns together
    5. Sorting data by marks
    6. Working with currency lists
    7. Sorting currency lists

  • Using Basic Formulas

    1. Using the Sum feature
    2. Using the Average feature
    3. Paste Function feature
    4. Keeping Class Records: An Example
    5. Sample Rubric: "English 10 - Oral Presentations"

  • How to Make Graphs and Charts

    1. Charts and Graphs
    2. Creating a 'Column Chart' using student marks
    3. Applying color to graphs and charts

  • Using Color in Worksheets

    1. Applying Color to Cells
    2. Applying Color to Data
    3. Applying color to Heading rows
    4. Applying Color to entire column(s) or row(s)
    5. Example Worksheet With Color

  • WordArt and Clip Art

    1. Using WordArt
    2. Using Clip Art
    3. Using other Excel Graphics
    4. Importing Graphics into Excel