2022-2023 College Catalog 
    
    May 01, 2024  
2022-2023 College 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