OFFC1155 : MS Excel II

This online-enhanced course covers advanced methods of using Microsoft Excel spreadsheet software to analyze financial data using a Personal Computer (PC). Topics include linking worksheets and workbooks, sorting and filtering, creating and using macros, using problem-solving, analysis and auditing tools, creating pivot tables and pivot charts, created advanced charts, importing and exporting data, sharing workbooks and integrating Excel with the Internet or an Intranet.

Prerequisites: Basic computer skills, including working in the Windows environment and file management (saving, retrieving or copying data files) and completion of OFFC1135, MS Excel I or equivalent experience. Offered: Fall, Spring, Summer

Credit Breakout:  1.00 lecture,   1.00 lab,   0.00 other.

Student Expectations:
Each student will spend at least 3 hours per week preparing for class. Attendance is critical in this class.