COMP265

Download as PDF

Spreadsheets Using Excel

Upon completion of this course, students will be able to:

Outcome

Gain an understanding of spreadsheet concepts and terminology.

Outcome

Acquire the ability to use a microcomputer to effectively process and present information.

Outcome

Organize and create an effective worksheet and workbook with formulas and functions.

Outcome

Create and modify charts.

Outcome

Sort and filter data.

Outcome

Apply conditional formatting.

Outcome

Create and modify PivotTables and PivotCharts.

Outcome

Use What-If analysis with data tables, Goal Seek, Scenario Manager, and Solver.

Outcome

Use advanced statistical functions.