This is a comprehensive computer spreadsheet course using Microsoft Excel for solving business problems. This includes calculations, forecasting, projections, macro programming, database searching, extraction, linking, statistics, and matrix manipulation. Production of graphs and reports. Project design using multiple, integrated spreadsheets. It is recommended that one introductory course in computers be completed prior to enrolling in this course.
Prerequisites
An introductory course in computers may be necessary prior to enrollment in this course.
Student Learning Outcomes
- Explain file management.
- Getting Started with Excel
- Formatting Workbook Text and Data
- Performing Calculations with Formulas and Functions
- Create, manipulate, and format charts.
- Analyze data using formulas.
- Manage workbook data.
- Analyze and manipulate data in a table structure.
- Analyze table data.
- Automate worksheet tasks.
- Enhance charts.
- Perform what-if analysis.
- Analyze data with PivotTables.
- Share Excel files and incorporate Web information.
- Customize Excel and apply advanced worksheet management techniques.