CT 6710 - Spreadsheets for Business Analysis

Students will use powerful tools and methods in spreadsheets to analyze data, design charts and graphs, create forecasts and models, and communicate the insights derived from those insights. In this course, students will learn how to generate table summaries, outline and group data, use complex formulas and IF statements, work with functions, create pivot tables, format pivot charts, perform what-if analysis with Goal Seek and Solver, and explore the various lookup functions. The class will also explore the uses of the Data Analysis Tool Pak for Random Number Generation, Annova, correlation, covariance, F & T tests and more. Credits: 3