CIT 155 - Excel Spreadsheets

 
Description
This course is a comprehensive use of electronic spreadsheets in solving business and technical problems using Microsoft Excel. Students learn through applied and project-based activities that go beyond the mechanics of the software. It engages students to utilize critical thinking activities for applied learning and problem solving. Topics include preparation of a variety of documents and mastery of specialized software functions.

1. Organize and create effective worksheets and workbooks with formulas and functions.
2. Create and modify charts.
3. Create and manage formal Excel tables for problem solving.
4. Create and modify PivotTables and PivotCharts.
5. Use What-If analysis with data tables, Goal Seek, Scenario Manager and Solver.
6. Use advanced statistical functions.
7. Create structured worksheets, supporting problem-solving.
8. Work with large volumes of data and import data from various sources.
9. Collaborate on and distribute workbooks.
10. Create and use templates and create and run macros.
11. Locate and download Web data and successfully integrate it in Excel-based projects.

1. Introducing Excel
2. Formulas and functions
3. Charts
4. Structured Excel datasets and tables
5. Subtotals, PivotTables and PivotCharts
6. What-if analysis
7. Specialized functions
8. Multiple-sheet workbook management
9. Imports, web queries and XML
10. Collaboration and workbook distribution
11. Sharing data with other office applications
12. Using data validation
13. Templates, styles and macros
14. Locating and downloading data collections from the World Wide Web

Course and Section Search