Dec 08, 2019  
2019-2020 Course Catalog 
    
2019-2020 Course Catalog
[Add to Portfolio]

CAPL 1025 - Microsoft Excel

Credits: 3
Hours/Week: Lecture 3 Lab None
Course Description: This course covers spreadsheet software that enables the student to organize data, work with formulas, charts and graphics, work with reports, and develop a professional worksheet. Other topics include: Excel lists, use of multiple worksheets/workbooks, Pivot Table and Pivot Charts. The students will apply critical thinking and problem-solving skills to real-life spreadsheet projects.
MnTC Goals
None

Prerequisite(s): CAPL 1010  or instructor consent.
Corequisite(s): None
Recommendation: None

Major Content
  1. Workbooks/Worksheets
  2. Functions: AVERAGE, MIN, and MAX functions
  3. Charts
  4. Financial functionsPMT, PV, IPMT
  5. Logical functions IF, TODAY, WORKDAY
  6. AutoFilters and Custom AutoFilters
  7. Data form
  8. Excel Lists including subtotals, AVG, MAX, MIN, Grand Total
  9. Hyperlinks
  10. Look-up tables VLOOKUP, HLOOKUP
  11. Multiple workbooks¿linked
  12. Pivot Charts
  13. Pivot tables
  14. Query wizard
  15. Range names
  16. Summary Page
  17. Text file

Learning Outcomes
At the end of this course students will be able to:

  1. create simple spreadsheets.
  2. format data using fonts, sizes, borders and backgrounds.
  3. create a header and footer.
  4. create column and 2-D and 3-D pie charts; resize and move embedded charts.
  5. modify the properties of the chart.
  6. format chart; insert drawing objects.
  7. sort, filter data and insert subtotals in a list.
  8. use a data form to enter, search for, edit, and delete records.
  9. summarize a list using a PivotTable and a PivotChart.
  10. format and edit worksheets.
  11. modify the worksheet.
  12. use charting features.
  13. use functions, macros, and a customized toolbar.
  14. Insert text, values, and formulas.
  15. Insert, delete, resize, and freeze worksheet rows and columns.
  16. Insert, move, rename, spell check, and print worksheets.
  17. copy and paste formulas and functions.
  18. work with absolute and relative references.
  19. use logical and date functions.
  20. create and apply styles and AutoFormat to a table.
  21. audit, trace, and fix formulas.
  22. consolidate information from multiple worksheets and workbooks.
  23. create a lookup table.
  24. create a workbook template.
  25. create validation rules.
  26. merge workbooks.
  27. create, assign, edit, and print macros.

Competency 1 (1-6)
None
Competency 2 (7-10)
None


Courses and Registration



[Add to Portfolio]