Students learn to recognize different classes of business problems that can be solved through the use of spreadsheets. Students learn how to design and develop a spreadsheet from a set of business requirements, apply financial functions, summarize data through the use of pivot tables, extract data from lookup tables, apply conditional logic to make decisions, and consolidate data from different spreadsheets. Lab fee. Prerequisite: BUS 171.