MARC details
| 000 -LEADER |
| fixed length control field |
04623cam a2200361 a 4500 |
| CONTROL NUMBER |
| control field |
16419250 |
| CONTROL NUMBER IDENTIFIER |
| control field |
OSt |
| DATE AND TIME OF LATEST TRANSACTION |
| control field |
20221001112459.0 |
| FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION |
| fixed length control field |
100816s2011 waua 001 0 eng d |
| LIBRARY OF CONGRESS CONTROL NUMBER |
| LC control number |
2010934987 |
| NATIONAL BIBLIOGRAPHY NUMBER |
| National bibliography number |
GBB095385 |
| Source |
bnb |
| NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER |
| Record control number |
015623687 |
| Source |
Uk |
| INTERNATIONAL STANDARD BOOK NUMBER |
| International Standard Book Number |
9780735643369 (pbk.) |
| SYSTEM CONTROL NUMBER |
| System control number |
(OCoLC)ocn650216020 |
| CATALOGING SOURCE |
| Original cataloging agency |
BTCTA |
| Language of cataloging |
eng |
| Transcribing agency |
BTCTA |
| Modifying agency |
YDXCP |
| -- |
WIM |
| -- |
SINLB |
| -- |
YOU |
| -- |
CDX |
| -- |
EEK |
| -- |
UKM |
| -- |
BWX |
| -- |
COA |
| -- |
DLC |
| AUTHENTICATION CODE |
| Authentication code |
lccopycat |
| LIBRARY OF CONGRESS CALL NUMBER |
| Classification number |
HD30.215 |
| Item number |
.W563 2011 |
| DEWEY DECIMAL CLASSIFICATION NUMBER |
| Classification number |
005.54 |
| Edition number |
22 |
| Item number |
WIN/M |
| MAIN ENTRY--PERSONAL NAME |
| Personal name |
Winston, Wayne L |
| 9 (RLIN) |
3960 |
| TITLE STATEMENT |
| Title |
Microsoft Excel 2010 : |
| Remainder of title |
data analysis and business modeling / |
| Statement of responsibility, etc. |
Wayne L. Winston. |
| VARYING FORM OF TITLE |
| Title proper/short title |
Excel 2010 : data analysis and business modeling |
| PUBLICATION, DISTRIBUTION, ETC. |
| Place of publication, distribution, etc. |
Redmond, Wash. : |
| Name of publisher, distributor, etc. |
Microsoft Press, |
| Date of publication, distribution, etc. |
c2011. |
| PHYSICAL DESCRIPTION |
| Extent |
xv, 700 p. : |
| Other physical details |
ill. ; |
| Dimensions |
23 cm. |
| GENERAL NOTE |
| General note |
Includes index. |
| FORMATTED CONTENTS NOTE |
| Formatted contents note |
What's new in Excel 2010 -- 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 -- Three-dimensional formulas -- The auditing tool -- Sensitivity analysis with data tables -- The goal seek command -- Using the scenario manager for sensitivity analysis -- The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions -- The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions -- The OFFSET function -- The INDIRECT function -- Conditional formatting -- Sorting in Excel -- Tables -- Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes -- An introduction to optimization with Excel Solver -- 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 -- 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 -- The traveling salesperson problem -- Importing data from a text file or document -- Importing data from the internet -- Validating data -- Summarizing data by using histograms -- Summarizing data by using descriptive statistics -- Using PivotTables and slicers to describe data -- Sparklines -- Summarizing data with database statistical functions -- Filtering data and removing duplicates -- Consolidating data -- Creating subtotals -- Estimating straight line relationships -- Modeling exponential growth -- The power curve -- Using correlations to summarize relationships -- Introduction to multiple regression -- Incorporating qualitative factors into multiple regression -- Modeling nonlinearities and interactions -- Analysis of variance: one-way ANOVA -- Randomized blocks and two-way ANOVA -- Using moving averages to understand time series -- Winters's method -- Ratio-to-moving-average forecast method -- Forecasting in the presence of special events -- An introduction to random variables -- The binomial, hypergeometric, and negative binomial random variables -- The Poisson and exponential random variable -- The normal random variable -- Weibull and beta distributions: modeling machine life and duration of a project -- Making probability statements from forecasts -- Using the lognormal random variable to model stock prices -- Introduction to Monte Carlo simulation -- Calculating an optimal bid -- Simulating stock prices and asset allocation modeling -- Fun and games: simulating gambling and sporting event probabilities -- Using resampling to analyze data -- Pricing stock options -- Determining customer value -- The economic order quantity inventory model -- Inventory modeling with uncertain demand -- Queuing theory: the mathematics of waiting in line -- Estimating a demand curve -- Pricing products by using tie-ins -- Pricing products by using subjectively determined demand -- Nonlinear pricing -- Array formulas and functions -- PowerPivot. |
| SUBJECT ADDED ENTRY--UNIFORM TITLE |
| Uniform title |
Microsoft Excel (Computer file) |
| SUBJECT ADDED ENTRY--TOPICAL TERM |
| Topical term or geographic name entry element |
Industrial management |
| General subdivision |
Statistical methods |
| -- |
Computer programs. |
| SUBJECT ADDED ENTRY--TOPICAL TERM |
| Topical term or geographic name entry element |
Decision making |
| General subdivision |
Computer programs. |
| LOCAL DATA ELEMENT F, LDF (RLIN) |
| a |
7 |
| b |
cbc |
| c |
copycat |
| d |
2 |
| e |
epcn |
| f |
20 |
| g |
y-gencatlg |
| ADDED ENTRY ELEMENTS (KOHA) |
| Source of classification or shelving scheme |
Dewey Decimal Classification |
| Koha item type |
Books |
| Classification part |
005.54 |
| Item part |
WIN/M |
| Call number prefix |
005.54 |
| Call number suffix |
WIN/M |