Microsoft Excel 2016 Data Analysis and Business Modeling / by Wayne L. Winston
Material type:
TextLanguage: English Publisher: Delhi ; PHI Learning (P) Ltd , 2016Description: 837 pISBN: 9788120353350Subject(s): Microsoft Excel (Computer file) -- Decision making--Computer programs -- Industrial management--Statistical methods--Computer programsDDC classification: 005.54 WIN | Item type | Current location | Call number | Status | Date due | Barcode |
|---|---|---|---|---|---|
| BOOK | Bangaluru Dr. B.R. Ambedkar School of Economics | 005.54 WIN (Browse shelf) | Available | 001166 |
Contents
Using the Scenario Manager for sensitivity analysis CHAPTER 20 The COUNTIF COUNTIFS COUNT COUNTA and COUNTBLANK functions CH...
The INDIRECT function CHAPTER 24 Conditional formatting CHAPTER 25 Sorting in Excel
The traveling salesperson problem CHAPTER 39 Importing data from a text file or document CHAPTER 40 Validating data CHAPTER 41 Summari...
Using PivotTables and slicers to describe data CHAPTER 44 The Data Model
Oneway ANOVA CHAPTER 61 Randomized blocks and twoway ANOVA CHAPTER 62 Using moving averages to understand time series CHAPTE...
Modeling machine life and duration of a project
Simulating gambling and sportingevent probabilities
The mathematics of waiting in line CHAPTER 84 Estimating a demand curve CHAPTER 85 Pricing products by using tieins CHAPTER 86 Pricing pr...
The Goal Seek command
Tables
Spin buttons scroll bars option buttons check boxes combo boxes and group list boxes
The analytics revolution
An introduction to optimization with Excel Solver CHAPTER 30 Using Solver to determine the optimal product mix
Using Solver to schedule your workforce
Using Solver to solve transportation or distribution problems
Using Solver for capital budgeting
Nonlinear pricing CHAPTER 88 Array formulas and functions CHAPTER 89 Recording macros
Introduction
Basic spreadsheet modeling
Range names
Lookup functions
The INDEX function
The MATCH function
Text functions
Dates and date functions
Evaluating investments by using net present value criteria
Internal rate of return
More Excel financial functions
Circular references
IF statements
Time and time functions
The Paste Special command
Threedimensional formulas and hyperlinks
The auditing tool
Sensitivity analysis with data tables
Using Solver for financial planning
Using Solver to rate sports teams
Warehouse location and the GRG Multistart and Evolutionary Solver engines
Penalties and the Evolutionary Solver
Power Pivot
Power View and 3D Maps
Sparklines
Summarizing data with database statistical functions
Filtering data and removing duplicates
Consolidating data
Creating subtotals
Charting tricks
Estimating straightline relationships CHAPTER 54 Modeling exponential growth CHAPTER 55 The power curve
Using correlations to summarize relationships
Introduction to multiple regression
Incorporating qualitative factors into multiple regression
Index
Copyright
There are no comments on this title.