Introduction to Excel:

1
Introduction to Excel

• Basic Formatting and Formulas

2
Basic Terminology

• Cell A rectangle within a workbook or
  worksheet. Cells may contain text, numbers, or
  formulas that return a value
• Columns Vertical collections of cells.
• Rows Horizontal collections of cells
• Formulas Equations that perform various
  operations within a worksheet

3
Excel Navigation or What Does C7 Mean?

• Columns are labeled alphabetically
• Rows are labeled numerically
• C7 would be the at the intersection of Column C
  and Row 7

4
Column Designation
Active Cell (C7)
Row Designation
5
Basic Cell Formatting
Format Cells
Borders
Fill Color
6
More Cell Formatting
Alignment
Orientation
Control
7
Formulas
AutoSum
8
Simple Formulas

• AutoSum
• Select range of cells
• Click on the AutoSum Icon
• Using Values from existing data
• Select a new Cell
• Type D4, i.e. D4 represents a cell that contains
  existing data. This is handy for creating
  gradebooks