Excel

Each class is approx 2 hours for each level

Level 1

Students will learn how to open, save, and close a workbook, entering data in a cell, working with columns and rows, basic formulas and the auto sum feature , and how to change  the default option settings to enhance your excel environment.

  1. Saving A Workbook
  2. Entering and Deleting Data
  3. Using Undo and Redo
  4. Inserting Rows and Columns
  5. Merging cells
  6. Creating a Basic Formula
  7. Merge and Center
  8. Worksheet options

Level 2

  1. Formulas and Functions
  2. Absolute and Relative References
  3. Formatting cells
  4. Excel mailing list for mailmerge
  5. Changing text appearance
  6. If function
  7. Conditional  formatting
  8. Printing and viewing worksheets

Level 3

Students will learn how to hide columns, use totals ans subtotals with the group feature, data lookups, sparklines, data validation, and macros.

  1. Pivot Tables
  2. Pivot Charts
  3.  V lookup
  4. Nested IF function
  5. Count and CountIF
  6. Protecting a Workbook
  7. Header and footer opptions
  8. Save options