BUS 128 Introduction of Data Analytics with Microsoft Excel

This course provides a thorough working knowledge of a “best practice” platform meeting many organizational and project analytical needs. Students learn modeling and analysis techniques with Microsoft Excel with the ultimate objective of transforming data and modeling assumptions into key metrics as well as bottom-line results of simulations, forecasts and sensitivity analyses. This course is hands-on, scenario-based, and involves relational database construction and integration including use of Pivot Tables and Descriptive Statistics. Key tools included are trend analyses (i.e. multiple regression, exponential smoothing, etc.) as well as advanced Excel functions (i.e. Data Analysis, Solver, etc.)

Credits

3

Distribution

BUS