O'Reilly logo

Business Analytics with Management Science Models and Methods by Arben Asllani

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required