OFF 120 — Microsoft Excel 3 Units (AA/AS; CSU) 54 lecture hours, 18 lab hours
An Excel worksheets and workbooks course to include: formatting, calculating sums, formulas, charts, enhancing the worksheet, and making decisions using the IF function, completing financial functions, data lists, large workbooks using templates, using advanced sorting and filtering, creating charts, diagrams, and templates, creating PivotTable, PivotChart reports, and auditing worksheets, using data analysis, solver, and scenario features, using macros, and Visual Basic for applications, external data, database functions, side-by-side tables, and collaborating with others and preparing a workbook for distribution.