CAT 118 : Excel Basics

A short introduction to Microsoft Excel (spreadsheet) basics. This class will include students from multiple sections.

Recommended Prerequisites:

Course Outcomes

  1. Create new and edit existing spreadsheet workbooks in Excel.
  2. Save an existing workbook as a revised workbook under a new name.
  3. Use Excel Ribbon tools, tabs, groups, dialog box launchers, backstage view, and contextual tabs to edit, manage, and format cells.
  4. Identify, enter, and edit text, values, formulas, and functions.
  5. Select, move, insert, and delete cells.
  6. Demonstrate an understanding of cell range references.
  7. Apply and modify cell formats, including dates, currency, percentages, alignments, merge, borders & shading, and conditional formats.
  8. Create calculations in a cell by using cell references, static values, simple functions, order of operations, and proper syntax.
  9. Use Relative and Absolute references for copied formulas.
  10. Use Formula View to error-check and edit formulas.
  11. Organize and modify worksheets within a workbook.
  12. Prepare a workbook for sharing and printing.

Overview

Program

Credits

1