Cargando…
Microsoft Excel 2010 : data analysis and business modeling /
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this a...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Redmond, Wash. :
Microsoft Press,
©2011.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | OR_ocn708034041 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr zn||||||||| | ||
| 008 | 110301s2011 waua ob 001 0 eng d | ||
| 010 | |a 2010934987 | ||
| 040 | |a CtWfDGI |b eng |e pn |c STF |d UMI |d UKMGB |d OCLCQ |d B24X7 |d COO |d N$T |d HEBIS |d TEFOD |d OCLCQ |d YDXCP |d OCLCQ |d DEBSZ |d OCLCQ |d OCLCF |d OCLCQ |d OCLCO |d UUO |d CAUOI |d AU@ |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCQ |d CEF |d WYU |d UAB |d OCLCQ |d VT2 |d UHL |d UKAHL |d OCLCO |d OCLCQ | ||
| 015 | |a GBB095385 |2 bnb | ||
| 016 | 7 | |a 015623687 |2 Uk | |
| 019 | |a 733752537 |a 765140769 |a 765143765 |a 778448373 |a 806504944 |a 873067659 |a 1066600885 |a 1103262540 |a 1113148397 |a 1129361208 | ||
| 020 | |a 9780735660519 |q (electronic bk.) | ||
| 020 | |a 0735660514 |q (electronic bk.) | ||
| 020 | |a 9780735660298 |q (electronic bk.) | ||
| 020 | |a 0735660298 |q (electronic bk.) | ||
| 020 | |z 9780735643369 | ||
| 020 | |z 0735643369 | ||
| 029 | 1 | |a AU@ |b 000050492303 | |
| 029 | 1 | |a AU@ |b 000052677448 | |
| 029 | 1 | |a DEBSZ |b 368470903 | |
| 029 | 1 | |a GBVCP |b 785427287 | |
| 029 | 1 | |a HEBIS |b 291538037 | |
| 029 | 1 | |a AU@ |b 000067104611 | |
| 029 | 1 | |a AU@ |b 000056817628 | |
| 035 | |a (OCoLC)708034041 |z (OCoLC)733752537 |z (OCoLC)765140769 |z (OCoLC)765143765 |z (OCoLC)778448373 |z (OCoLC)806504944 |z (OCoLC)873067659 |z (OCoLC)1066600885 |z (OCoLC)1103262540 |z (OCoLC)1113148397 |z (OCoLC)1129361208 | ||
| 037 | |a CL0500000094 |b Safari Books Online | ||
| 050 | 4 | |a HD30.215 |b .W56 2011eb | |
| 072 | 7 | |a BUS |x 019000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.54 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Winston, Wayne L. | |
| 245 | 1 | 0 | |a Microsoft Excel 2010 : |b data analysis and business modeling / |c Wayne L. Winston. |
| 246 | 3 | 0 | |a Data analysis and business modeling |
| 260 | |a Redmond, Wash. : |b Microsoft Press, |c ©2011. | ||
| 300 | |a 1 online resource (xv, 700 pages) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 505 | 0 | |a 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. | |
| 504 | |a Includes bibliographical references and index. | ||
| 520 | |a Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide -- fully updated for Excel 2010! | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 blmlsh |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |0 (OCoLC)fst01366659 |
| 650 | 0 | |a Industrial management |x Statistical methods |x Computer programs. | |
| 650 | 0 | |a Decision making |x Computer programs. | |
| 650 | 6 | |a Gestion d'entreprise |x Méthodes statistiques |x Logiciels. | |
| 650 | 6 | |a Prise de décision |x Logiciels. | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Decision-Making & Problem Solving. |2 bisacsh | |
| 650 | 7 | |a Decision making |x Computer programs. |2 fast |0 (OCoLC)fst00889038 | |
| 650 | 7 | |a Industrial management |x Statistical methods |x Computer programs. |2 fast |0 (OCoLC)fst00971331 | |
| 776 | 0 | 8 | |i Print version: |a Winston, Wayne L. |t Microsoft Excel 2010. |d Redmond, Wash. : Microsoft Press, ©2011 |z 9780735643369 |w (DLC) 2010923987 |w (OCoLC)650216020 |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9780735656864/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26378476 | ||
| 938 | |a EBSCOhost |b EBSC |n 431791 | ||
| 938 | |a YBP Library Services |b YANK |n 7488979 | ||
| 938 | |a YBP Library Services |b YANK |n 7485935 | ||
| 994 | |a 92 |b IZTAP | ||