Microsoft Office Excel 2007 : data analysis and business modeling /

Provides an introduction to data analysis and business modeling using Microsoft Excel.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Winston, Wayne L.
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Redmond, Wash. : Microsoft Press, 2007.
Temas:
Microsoft Excel (Computer file)
Industrial management > Statistical methods > Computer programs.
Decision making > Computer programs.
Gestion d'entreprise > Méthodes statistiques > Logiciels.
Prise de décision > Logiciels.
COMPUTERS > Desktop Applications > Spreadsheets.
Business > Computer programs.
Decision making > Computer programs
Industrial management > Statistical methods > Computer programs
Betriebsdaten
Datenanalyse
Excel 2007
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 1. Range names
  • 2. Lookup functions
  • 3. The INDEX function
  • 4. The MATCH function
  • 5. Text functions
  • 6. Dates and date functions
  • 7. Evaluating investments by using net present value criteria
  • 8. Internal rate of return
  • 9. More Excel financial functions
  • 10. Circular references
  • 11. IF statements
  • 12. Time and time functions
  • 13. The paste special command
  • 14. The auditing tool
  • 15. Sensitivity analysis with data tables
  • 16. The goal seek command
  • 17. Using the scenario manager for sensitivity analysis
  • 18. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
  • 19. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
  • 20. The OFFSET function
  • 21. The INDIRECT function
  • 22. Conditional formatting
  • 23. Sorting in Excel
  • 24. Tables
  • 25. Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes
  • 26. An introduction to optimization with Excel solver
  • 27. Using solver to determine the optimal product mix
  • 28. Using solver to schedule your workforce
  • 29. Using solver to solve transportation or distribution problems
  • 30. Using solver for capital budgeting
  • 31. Using solver for financial planning
  • 32. Using solver to rate sports teams
  • 33. Importing data from a text file or document
  • 34. Importing data from the Internet
  • 35. Validating data
  • 36. Summarizing data by using histograms
  • 37. Summarizing data by using descriptive statistics
  • 38. Using PivotTables to describe data
  • 39. Summarizing data with database statistical functions
  • 40. Filtering data and removing duplicates
  • 41. Consolidating data
  • 42. Creating subtotals
  • 43. Estimating straight line relationships
  • 44. Modeling exponential growth
  • 45. The power curve
  • 46. Using correlations to summarize relationships
  • 47. Introduction to multiple regression
  • 48. Incorporating qualitative factors into multiple regression
  • 49. Modeling nonlinearities and interactions
  • 50. Analysis of variance : one-way ANOVA
  • 51. Randomized blocks and two-way ANOVA
  • 52. Using moving averages to understand time series
  • 53. Winter's method
  • 54. Forecasting in the presence of special events
  • 55. An introduction to random variables
  • 56. The binomial, hypergeometric, and negative binomial random variables
  • 57. The poisson and exponential random variable
  • 58. The normal random variable
  • 59. Weibull and beta distributions : modeling machine life and duration of a project
  • 60. Introduction to Monte Carlo simulation
  • 61. Calculating an optimal bid
  • 62. Simulating stock prices and asset allocation modeling
  • 63. Fun and games : simulating gambling and sporting event probabilities
  • 64. Using resampling to analyze data
  • 65. Pricing stock options
  • 66. Determining customer value
  • 67. The economic order quantity inventory model
  • 68. Inventory modeling with uncertain demand
  • 69. Queuing theory : the mathematics of waiting in line
  • 70. Estimating a demand curve
  • 71. Pricing products by using tie-ins
  • 72. Pricing products by using subjectively determined demand
  • 73. Nonlinear pricing
  • 74. Array formulas and functions.

Ejemplares similares