CAT 140: Introduction to Microsoft Excel

Download as PDF

Introduction to spreadsheets. Create, format, edit, and print worksheets; formula and function capabilities; analyze, link, and summarize data; create charts and tables; images and diagrams; work with multiple worksheets; use templates and galleries. Keyboarding and file management skills are recommended. This class may include students from multiple sections. 

  1. Create and manage workbooks.
  2. Organize and enter data.
  3. Change properties and print worksheets.
  4. Format cells.
  5. Enter simple formulas.
  6. Use advanced functions.
  7. Display data in charts.
  8. Organize data in tables.
  9. Summarize complex data.
  10. Introduced to pivot tables/charts.
  11. Develop Excel workbook implementing skills learned.
Program
Computer Applications Technology
Credits
5
Lecture Hours
55