Students will develop advanced business-related spreadsheet skills in developing and analyzing Excel worksheets under common business management scenarios. Topics include formulas, formatting, financial and lookup functions, charts, pivot tables, data tables, and other advanced features used to make business decisions and communicate financial, forecasting, and operational performance. Course Outcomes: 1. Apply advanced worksheet editing and formatting tools to present business data. 2. Design customized workbooks based on various business management scenarios 3. Demonstrate mastery of software functionality relating to navigation and formatting 4. Create formulas and functions under various business management scenarios 5. Create charts and tables to effectively communicate data 6. Apply software features to facilitate business decision making 7. Assess data presented in worksheets to make business decisions
Prerequisite
Completion of MATH 40 with a 2.0 or higher. It is also recommended that students complete CS 101 prior to enrollment.