Contents

CMSY 101 Beginning Spreadsheets

After successful completion of this course, students will be able to use features of Microsoft® Excel that include functions and formulas, formatting, charts, and lists. This course may be completed in fewer than 14 weeks. All of the work (except tests) may be done outside of class if the student has compatible software.

Credits

1

Course Objectives

  1. 1. Create, save, and print a worksheet.
  2. 2. Format a worksheet.
  3. 3. Enhance a worksheet.
  4. 4. Insert formulas and functions.
  5. 5. Move data within and between workbooks.
  6. 6. Create and modify charts.
  7. 7. Use styles, themes, and templates.
  8. 8. Insert Hyperlinks, Images, SmartArt, WordArt, and shapes.
  9. 9. Filter lists and sort data.

Course Objectives

  1. 1. Create, save, and print a worksheet.
  2. 2. Format a worksheet.
  3. 3. Enhance a worksheet.
  4. 4. Insert formulas and functions.
  5. 5. Move data within and between workbooks.
  6. 6. Create and modify charts.
  7. 7. Use styles, themes, and templates.
  8. 8. Insert Hyperlinks, Images, SmartArt, WordArt, and shapes.
  9. 9. Filter lists and sort data.