Working with Excel

Abstract

Managers and analysts routinely collect and examine key performance measures to better understand their operations and make good decisions. Being able to render the complexity of operations data into a coherent account of significant events requires an understanding of how to work well in the electronic environment with raw data.

The primary foci of this text are (1) to refresh fundamental mathematical skills and operations that broadly support work with statistical and financial equations and formulas, (2) to introduce work with equations and formulas in Excel spreadsheets, (3) to expand statistical and financial analysis with the programmed Excel functions readily available through the “Insert Function” toolbar button and the more ...