Business Analytics with Management Science Models and Methods

A. Excel Tools for the Management Scientist

The following is a summary of the ten most used functions throughout the book. A brief description, syntax, and an illustration with an example are provided for each function. The Appendix A file contains sales records for a two-year period. You can download the Appendix A file from the companion website at www.informit.com/title/9780133760354. Each function discussed in this appendix is demonstrated in a separate worksheet in the file.

1: Shortcut Keys

In the era of Big Data, data scientists often deal with large data sets that spread over hundreds of columns and thousands or millions of rows. Shortcut keys offer an easy way to navigate through records, fields, and select a single value or range of ...