CIS 125E : Excel

Transcript title

Excel

Credits

4

Grading mode

Standard letter grades

Total contact hours

50

Lecture hours

30

Other hours

20

Recommended preparation

(CIS 120 or CIS 124) and CIS 131.

Course Description

Covers intermediate and advanced features of Microsoft Excel such as lists, pivot tables, working with multiple worksheets, templates, what-if-analysis, data tables, advanced formulas and functions, goal seek, solver, consolidating and importing data. Students will apply these Excel features to create and revise business worksheets.

Course learning outcomes

1. Enter different types of data into Excel and use appropriate formatting features to create a professional looking spreadsheets.
2. Appropriately use basic formulas and functions in Excel to solve common business problems.
3. Evaluate data in Excel using logical and lookup functions.
4. Present business related information in an easy to understand format using the Excel charting tools.
5. Use advanced functions to develop sophisticated spreadsheets for making business decisions.
6. Manage large volumes of data using filters and pivot tables.
7. Conduct “What if" analysis using various features of Excel and conduct advanced statistical computations.
8. Import external data form text files and databases.

Content outline

• Worksheet formatting • Functions and formulas • Charting • Pivot charts/tables • Data management

Required materials

Access to Microsoft Office.

Outside of
expected

Use the COCC Catalog to find extraordinary classes and degree programs. Start your journey here »