Aug 08, 2020
2019-2020 Course Catalog
 Select a Catalog 2020-2021 Course Catalog 2019-2020 Course Catalog [ARCHIVED CATALOG] 2018-2019 Course Catalog [ARCHIVED CATALOG] 2017-2018 Course Catalog [ARCHIVED CATALOG]

# 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
10. Look-up tables VLOOKUP, HLOOKUP
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:

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