Catalog

CS 152 - Spreadsheet Analysis: Intermediate (2)

Learn to use Microsoft Excel as a spreadsheet tool to analyze data using advanced features, functions and charts. This course prepares students for CSSV 153. Topics: Charts (pie, column, line, area, bar, combination, exploding, 3-D), data mapping, link workbooks, 3-D formulas, IF functions, Lookup functions (vertical and horizontal), inserting comments, color fonts and background, autoformat, lock, protect and hide data or worksheets. Taught in lecture/lab format using Microsoft Excel. Offered Fall/Spring.