|
|
|
May 04, 2024
|
|
2021-2022 Spring Edition [ARCHIVED CATALOG]
|
CIMA 204 ADVANCED SPREADSHEETS - EXCEL
3 Units 2 hours lecture 3 hours lab
Recommended Preparation: CIMA 104 or CIMA 283F
Develop competencies in the advanced topics of spreadsheet software. Create PivotTables and PivotCharts. Use advanced specialized math, statistical, logical, financial and lookup functions. Create macros, sumifs, templates and styles and prepare workbooks for distribution. Use collaboration tools, data analysis, solver, and scenario features. Audit worksheets.
Grading Method: GR - Letter Grade or Pass/No Pass
NR
|
|
|
