ISOM-801 Solving Business Problems Using Advanced Excel
Analyzes various real world business problems and explores the full scope of MS Excels formulas, functions and features to create data models and present solutions. Students analyze data, design custom charts, graphs, PivotTables and Pivot charts, create three-dimensional workbooks, build links between files and endow worksheets with decision-making capabilities. Students conduct What-If Analysis, utilizing Scenario Manager, Solver, Data Tables and Goal Seek. This course provides the skills necessary to pass the Microsoft Office Specialist Certification in Excel.
Prerequisite
Student has satisfied all of the following Academic Unit (Computed) in the selection list Accounting, Accounting and Business Law, Business Administration, Business Administration Executive, Business Analytics, Business Law and Ethics, Entrepreneurship, Finance, Health Administration, Information System, Information Systems and Operations Management, INTO Sawyer Business School, Management and Entrepreneurship, Management Studies, Marketing, Moakley Center for Public Management, Public Administration, Public Administration and Health Administration, Sawyer Business School, Strategy and International Business Or Programs of Study any in the selection list Business Economics Major BSBA
Offered
Fall, Spring