OADM 132 - Microsoft® Excel

3 Credits: (3 lecture)

Course Description
This course provides a comprehensive knowledge of Microsoft® Excel and its capabilities to create and manage spreadsheets.

Note Mac and Chromebook computers ARE NOT recommended for this course due to software required in the course. A computer with a current WINDOWS operating system is highly recommended for off-campus work.

Spring semester only.

Prerequisite COMP 210. Corequisite COMP 210.

Text
Freund, S. M. & Starks, J. L. (2023). Shelly Cashman series® Microsoft® Office 365® & Excel® 2021 comprehensive (1st ed.). Boston, MA: Cengage Learning.

Objectives
The student will be able to:

A. Create worksheets with labels, values, functions, and formulas.

B. Design charts and tables.

C. Apply appropriate formatting to worksheets, tables, and charts.

D. Utilize sorting and filtering commands to edit lists.

E. Employ integration tools to incorporate other Microsoft® applications.

F. Implement “what-if analyses,” lookup options, and basic macros.

G. Utilize print options.

H. Create interactive reporting and analysis using Pivot tables and charts.

Content
A. Worksheets.

B. Worksheet data.

C. Charts and Pivot tables.

D. Tables.

E. Lists.

F. Formulas.

G. Functions.

H. Macros.

Student Evaluation
Objectives A through H will be assessed through textbook and simulation software assignments, application and written tests and/or quizzes, and a comprehensive final exam.