Getting Started with Microsoft Excel

 

1.     Screen Elements

http://www.fgcu.edu/support/office2000/excel/basics.html

 

2.     Resizing Rows and Columns

http://www.fgcu.edu/support/office2000/excel/modify.html

There are two ways to resize rows and columns.

• Resize a row by dragging the line below the label of the row you would like to resize. Resize a column in a similar manner by dragging the line to the right of the label corresponding to the column you want to resize.
  - OR -
• Click the row or column label and select Format|Row|Height or Format|Column|Width from the menu bar to enter a numerical value for the height of the row or width of the column.

 

3.     Using Equations

http://www.internet4classrooms.com/excel_equations.htm

 

4.  Sorting and Filling

          http://www.fgcu.edu/support/office2000/excel/sorting.html 

 

5.  Printing

          http://www.fgcu.edu/support/office2000/excel/page.html

 

Assignment - Using Excel to analyze the results of a simple survey

          http://www.internet4classrooms.com/excel_survey.htm

 

6.  Getting Help from Microsoft Office

What Chart Type should you use to display your data?

Menu Bar> Help>Microsoft Excel Help>Answer Wizard Tab>

Type in Example of Chart Types> Click graphic to display topic>

read over each example type.

 

• A column chart shows data changes over a period of time or illustrates comparisons among items. Categories are organized horizontally, values vertically, to emphasize variation over time
• A line chart shows trends in data at equal intervals

·        A pie chart shows the proportional size of items that make up a data series to the sum of the items. It always shows only one data series and is useful when you want to emphasize a significant element.

 

Assignment - Creating a Chart or Graph

http://www.internet4classrooms.com/excel_create_chart.htm