Microsoft Excel 2016: Data Analysis and Business Modeling (Record no. 109512)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 03216nam a2200169 4500 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 171005b xxu||||| |||| 00| 0 eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| International Standard Book Number | 9788120353350 |
| 082 ## - DEWEY DECIMAL CLASSIFICATION NUMBER | |
| Classification number | 005.369 |
| Item number | WIN |
| 100 ## - MAIN ENTRY--PERSONAL NAME | |
| Personal name | Winston, Wayne L. |
| 9 (RLIN) | 20898 |
| 245 ## - TITLE STATEMENT | |
| Title | Microsoft Excel 2016: Data Analysis and Business Modeling |
| 260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT) | |
| Name of publisher, distributor, etc | PHI Learning Private Limited |
| Date of publication, distribution, etc | 2017 |
| Place of publication, distribution, etc | Delhi |
| 300 ## - PHYSICAL DESCRIPTION | |
| Extent | 837p |
| 500 ## - GENERAL NOTE | |
| General note | <br/><br/> Machine generated contents note: Answers to this chapter's questions<br/> Problems<br/> How can I create named ranges?<br/> Using the Name box to create a range name<br/> Creating named ranges by using the Create From Selection option<br/> Creating range names by using the Define Name option<br/> The Name Manager<br/> Answers to this chapter's questions<br/> Remarks<br/> Syntax of the lookup functions<br/> VLOOKUP syntax<br/> HLOOKUP syntax<br/> Syntax of the INDEX function<br/> Syntax of the MATCH function<br/> Text function syntax<br/> The LEFT function<br/> The RIGHT function<br/> The MID function<br/> The TRIM function<br/> The LEN function<br/> The FIND and SEARCH functions<br/> The REPT function<br/> The CONCATENATE and & functions<br/> The REPLACE function<br/> The VALUE function<br/> The UPPER, LOWER, and PROPER functions<br/> The CHAR function<br/> Contents note continued: The CLEAN function<br/> The SUBSTITUTE function<br/> Extracting data by using the Convert Text To Columns Wizard<br/> CUMPRINC and CUMIPMT functions<br/> Answer to this chapter's question<br/> Contents note continued: Problems<br/> Answers to this chapter's question<br/> Handling other constraints<br/> Solving binary and integer programming problems<br/> Why is our model not a linear Solver model?<br/> Understanding the GRG Multistart and Evolutionary Solver engines<br/> How does Solver solve linear model problems?<br/> Contents note continued: How does the GRG Nonlinear engine solve nonlinear optimization models?<br/> How does the Evolutionary Solver engine tackle nonsmooth optimization problems?<br/> Answer to this chapter's questions<br/> Using conditional formatting to highlight each employee's ratings<br/> Using conditional formatting to highlight outliers<br/> Remarks about grouping<br/> Questions answered in this chapter<br/> Filling in the correlation matrix<br/> Using the CORREL function<br/> Relationship between correlation and R-squared<br/> Correlation and regression toward the mean<br/> Problems for Chapters 57 through 59<br/> Problem<br/> Time-series characteristics<br/> Parameter definitions<br/> Initializing Winters method<br/> Contents note continued: Estimating the smoothing constants<br/> The impact of risk on your decision<br/> Confidence interval for mean profit<br/> Contents note continued: Answers to this chapter's questions<br/> Thse back-order case<br/> The lost-sales case<br/> Problems. |
| 600 ## - SUBJECT ADDED ENTRY--PERSONAL NAME | |
| Personal name | Microsoft Excel |
| 9 (RLIN) | 23827 |
| 600 ## - SUBJECT ADDED ENTRY--PERSONAL NAME | |
| Personal name | Electronic Spreadsheets |
| 9 (RLIN) | 23828 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Source of classification or shelving scheme | Dewey Decimal Classification |
| Item type | Book |
| Call number prefix | 005.369 |
| Call number suffix | WIN |
No items available.