Business Modeling & Analytics Using Excel For Dummies

Management Science develops mathematical models to solve complex decision making problems, and Excel is the best platform to solve those complex problems. This book presents this material in an easy-to-understand format and focuses on the features of Excel that are important to businesses and researchers. Topics include working with external databases, PivotTables and Pivot Charts, using Excel for statistical and financial functions, data sharing, accounting, economics, operations and other important business quantitative needs.

The reader will find real life examples from the areas of banking and finance, transportation, manufacturing, manpower assignment, scheduling, quality control, inventory management, queuing, food and product mix. The book will present a variety of examples that can be applied to any industry. Whether the reader makes small daily business decisions or million-dollar ones, this is the book for anyone who needs to use Excel for problem solving.

Some of the techniques covered will include:
Linear and Nonlinear Optimization
Transportation
Assignment
Probabilistic Analysis
Stochastic Modeling and Simulation
Economic Analysis
Inventory Control and Production Systems
Risk Analysis
Accounting/Investment Science
Plan Location
Capital Investment
Forecasting