AOS 104: Excel Basics

Credits 1
Quarter Offered
Fall,
Winter,
Spring

A short introduction to Microsoft Excel (spreadsheet) basics. Keyboarding skills are recommended. This class may include students from multiple sections. (Formerly CAT 118)

  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.