CAPL1025 — Microsoft Excel
CAPL 1025 - Microsoft Excel CAPL 1025 - Microsoft Excel 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 format data using fonts, sizes, borders and backgrounds. create a header and footer. create column and 2-D and 3-D pie charts; resize and move embedded charts. modify the properties of the chart. format chart; insert drawing objects. sort, filter data and insert subtotals in a list. use a data form to enter, search for, edit, and delete records. summarize a list using a PivotTable and a PivotChart. format and edit worksheets. modify the worksheet. use charting features. use functions, macros, and a customized toolbar. Insert text, values, and formulas. Insert, delete, resize, and freeze worksheet rows and columns. Insert, move, rename, spell check, and print worksheets. copy and paste formulas and functions. work with absolute and relative references. use logical and date functions. create and apply styles and AutoFormat to a table. audit, trace, and fix formulas. consolidate information from multiple worksheets and workbooks. create a lookup table. create a workbook templat
Prerequisites: CAPL1010
Part of
- Accounting Transfer Pathway, AS
- Accounting, AAS
- Thank you for your interest in the Administrative Assistant, AAS program at Century College. Effective Summer/Fall semester 2025, Century College will no longer admit new students into this program. Century College is committed to providing students currently enrolled in the Administrative Assistant, AAS program an opportunity to complete their intended award. For further details or assistance, please contact Assistant to Dean Business, Human Services and Industry Michelle LeMire 651.444.2516 or michelle.lemire@century.edu.
- Thank you for your interest in the Office Support Diploma program at Century College. Effective Summer/Fall semester 2025, Century College will no longer admit new students into this program. Century College is committed to providing students currently enrolled in the Office Support Diploma program an opportunity to complete their intended award. For further details or assistance, please contact Assistant to Dean Business, Human Services and Industry Michelle LeMire 651.444.2516 or michelle.lemire@century.edu.
- Thank you for your interest in the Software Applications Certificate program at Century College. Effective Summer/Fall semester 2025, Century College will no longer admit new students into this program. Century College is committed to providing students currently enrolled in the Software Applications Certificate program an opportunity to complete their intended award. For further details or assistance, please contact Assistant to Dean Business, Human Services and Industry Michelle LeMire 651.444.2516 or michelle.lemire@century.edu.