OS 233 - Advanced Spreadsheets/Excel (1)

Prerequisite: OS 133
spring, summer

Lecture: One-half hour of lecture/discussion per week. Lab: One hour of lab per week.

Students will expand upon the skills learned in OS 133 Spreadsheets/Excel. Students will learn how to use spreadsheets to organize, present, evaluate data, and use complex formulas and functions. Students will learn about PivotTables, PivotCharts, Macros, use data analysis, solver and scenario features, as well as sharing workbooks, and connecting to external data. Upon completion of this course, students should have learned the skills required to pass the Microsoft Office Specialist (MOS) Excel Expert certificate exam.