Coverart for item
The Resource Microsoft Excel 2019 : data analysis and business modeling, Wayne L. Winston

Microsoft Excel 2019 : data analysis and business modeling, Wayne L. Winston

Label
Microsoft Excel 2019 : data analysis and business modeling
Title
Microsoft Excel 2019
Title remainder
data analysis and business modeling
Statement of responsibility
Wayne L. Winston
Creator
Subject
Language
eng
http://library.link/vocab/creatorName
Winston, Wayne L
Illustrations
illustrations
Index
index present
Literary form
non fiction
http://library.link/vocab/subjectName
  • Decision making
  • Industrial management
  • Business
  • Electronic spreadsheets
Label
Microsoft Excel 2019 : data analysis and business modeling, Wayne L. Winston
Instantiates
Publication
Copyright
Note
  • "Microsoft Press"--Back cover
  • Includes index
Carrier category
volume
Carrier category code
  • nc
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
Basic worksheet modeling -- Range names -- Lookup functions -- The INDEX function -- The MATCH function -- Text functions and Flash Fill -- Dates and date functions -- NPV and XNPV functions -- IRR, XIRR, and MIRR functions -- More Excel financial functions -- Circular references -- IF, IFERROR, IFS, CHOOSE, and SWITCH functions -- Time and time functions -- The Paste Special command -- Three-dimensional formulas and hyperlinks -- The auding tool and the Inquire add-in -- 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, AVERAGEIFS, MAXIFS, and MINIFS functions -- The OFFSET function -- The INDIRECT function -- Conditional formatting -- Sorting in Excel -- Excel Tables and table slicers -- Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes -- The analytics revolution -- 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 -- Get & Transform -- Geography and Stock data types -- Validating data -- Summarizing data by using histograms and Pareto charts -- Summarizing data by using descriptive statistics -- Using pivot tables and slicers to describe data -- The Data Model -- Power Pivot -- Filled and 3D Power Maps -- Sparklines -- Summarizing data with database statistical functions -- Filtering data and removing duplicates -- Consolidating data -- Creating subtotals -- Charting tricks -- Estimating straight-line relationships -- Modeling exponential growth -- The power curve using correlations to summarize relationships -- Introduction to multiple regression -- Incorprating 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 method and the Forecast Sheet -- Ratio-to-moving-average forecast method -- Forecasting in the presence of special events -- An introduction to probability -- An introduction to random variables -- The binomial, hypergeometric, and negative binomial random variables -- The Poisson and exponential random variable -- The normal random variable and Z-scores -- Weibull and beta distributions: Modeling machine life and duration of a project -- Making probability statements from forecasts -- Using the lognormal random variaable to model stock prices -- Importing historical stock data into Excel -- 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 determinded demand -- Nonlinear pricing -- Array formulas and functions -- Recording macros -- Advanced sensitivity analysis
Control code
on1054835628
Dimensions
23 cm
Edition
Sixth edition.
Extent
xxvii, 850 pages
Isbn
9781509305889
Media category
unmediated
Media MARC source
rdamedia
Media type code
  • n
Other physical details
illustrations
System control number
(OCoLC)1054835628
Label
Microsoft Excel 2019 : data analysis and business modeling, Wayne L. Winston
Publication
Copyright
Note
  • "Microsoft Press"--Back cover
  • Includes index
Carrier category
volume
Carrier category code
  • nc
Carrier MARC source
rdacarrier
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
Contents
Basic worksheet modeling -- Range names -- Lookup functions -- The INDEX function -- The MATCH function -- Text functions and Flash Fill -- Dates and date functions -- NPV and XNPV functions -- IRR, XIRR, and MIRR functions -- More Excel financial functions -- Circular references -- IF, IFERROR, IFS, CHOOSE, and SWITCH functions -- Time and time functions -- The Paste Special command -- Three-dimensional formulas and hyperlinks -- The auding tool and the Inquire add-in -- 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, AVERAGEIFS, MAXIFS, and MINIFS functions -- The OFFSET function -- The INDIRECT function -- Conditional formatting -- Sorting in Excel -- Excel Tables and table slicers -- Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes -- The analytics revolution -- 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 -- Get & Transform -- Geography and Stock data types -- Validating data -- Summarizing data by using histograms and Pareto charts -- Summarizing data by using descriptive statistics -- Using pivot tables and slicers to describe data -- The Data Model -- Power Pivot -- Filled and 3D Power Maps -- Sparklines -- Summarizing data with database statistical functions -- Filtering data and removing duplicates -- Consolidating data -- Creating subtotals -- Charting tricks -- Estimating straight-line relationships -- Modeling exponential growth -- The power curve using correlations to summarize relationships -- Introduction to multiple regression -- Incorprating 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 method and the Forecast Sheet -- Ratio-to-moving-average forecast method -- Forecasting in the presence of special events -- An introduction to probability -- An introduction to random variables -- The binomial, hypergeometric, and negative binomial random variables -- The Poisson and exponential random variable -- The normal random variable and Z-scores -- Weibull and beta distributions: Modeling machine life and duration of a project -- Making probability statements from forecasts -- Using the lognormal random variaable to model stock prices -- Importing historical stock data into Excel -- 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 determinded demand -- Nonlinear pricing -- Array formulas and functions -- Recording macros -- Advanced sensitivity analysis
Control code
on1054835628
Dimensions
23 cm
Edition
Sixth edition.
Extent
xxvii, 850 pages
Isbn
9781509305889
Media category
unmediated
Media MARC source
rdamedia
Media type code
  • n
Other physical details
illustrations
System control number
(OCoLC)1054835628

Library Locations

    • Badia FiesolanaBorrow it
      Via dei Roccettini 9, San Domenico di Fiesole, 50014, IT
      43.803074 11.283055
Processing Feedback ...