Description
Students will utilize the principles of computerized spreadsheet tools in solving analytical problems within Windows-based Microsoft Excel. Topics include: charts and graphs, formulas, what-if analysis and financial functions, table queries, pivot tables, data validation and macros. YBA will also be introduced. Students will create, format, and manage multiple worksheets and workbooks using features of the software.
Course Learning Outcomes
- Create a multi-sheet workbook utilizing the design and formatting features of the software
- Demonstrate how to insert, manipulate, and test formulas for accuracy, and perform a basic what-if analysis
- Understand different financial functions, and how output may be represented visually
Semester
Spring
Notes
Repeat of CS 142, CS 143, CS 144, CS 145.