Tangaza University Library

Microsoft Excel 2010 : (Record no. 183288)

MARC details
000 -LEADER
fixed length control field 04606cam a2200349 a 4500
001 - CONTROL NUMBER
control field 16419250
003 - CONTROL NUMBER IDENTIFIER
control field OSt
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20180220121750.0
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 100816s2011 waua 001 0 eng d
010 ## - LIBRARY OF CONGRESS CONTROL NUMBER
LC control number 2010934987
015 ## - NATIONAL BIBLIOGRAPHY NUMBER
National bibliography number GBB095385
Source bnb
016 7# - NATIONAL BIBLIOGRAPHIC AGENCY CONTROL NUMBER
Record control number 015623687
Source Uk
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9780735643369 (pbk.)
035 ## - SYSTEM CONTROL NUMBER
System control number (OCoLC)ocn650216020
040 ## - 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
042 ## - AUTHENTICATION CODE
Authentication code lccopycat
050 00 - LIBRARY OF CONGRESS CALL NUMBER
Classification number HD30.215
Item number .W563 2011
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 658.40300285554
Edition number 22
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.54
Edition number 22
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Winston, Wayne L.
245 10 - TITLE STATEMENT
Title Microsoft Excel 2010 :
Remainder of title data analysis and business modeling /
Statement of responsibility, etc Wayne L. Winston.
246 30 - VARYING FORM OF TITLE
Title proper/short title Excel 2010 : data analysis and business modeling
260 ## - PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)
Place of publication, distribution, etc Redmond, Wash. :
Name of publisher, distributor, etc Microsoft Press,
Date of publication, distribution, etc c2011.
300 ## - PHYSICAL DESCRIPTION
Extent xv, 700 p. :
Other physical details ill. ;
Dimensions 23 cm.
500 ## - GENERAL NOTE
General note Includes index.
505 0# - 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.
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Microsoft Excel (Computer file)
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Industrial management
General subdivision Statistical methods
-- Computer programs.
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Decision making
General subdivision Computer programs.
906 ## - LOCAL DATA ELEMENT F, LDF (RLIN)
a 7
b cbc
c copycat
d 2
e epcn
f 20
g y-gencatlg
942 ## - ADDED ENTRY ELEMENTS (KOHA)
Source of classification or shelving scheme Library of Congress Classification
Koha item type Book
Holdings
Withdrawn status Lost status Not for loan Home library Current library Shelving location Date acquired Total Checkouts Total Renewals Full call number Barcode Date last seen Date checked out Price effective from Koha item type
      MARY IMMACULATE LIBRARY MARY IMMACULATE LIBRARY Open Shelf 20/02/2018 2 2 HD30.215 .W563 2011 76412 23/04/2021 10/02/2021 20/02/2018 Book
      MARY IMMACULATE LIBRARY MARY IMMACULATE LIBRARY Open Shelf 20/02/2018 2 1 HD30.215 .W563 2011 76413 05/01/2023 17/12/2022 20/02/2018 Book

© Tangaza University Library, Langata South Road P.O Box 15055 00509 Nairobi Kenya
Tel: 0722 204 724 Fax: +254 20 8890018