Microsoft® Excel Data Analysis and Business Modeling
Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Excel fo...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2004.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628159206719 |
Tabla de Contenidos:
- Cover; Copyright; Table of Contents; Introduction; Chapter 1 Range Names; Chapter 2 Natural Language Range Names; Chapter 3 Lookup Functions; Chapter 4 The INDEX Function; Chapter 5 The MATCH Function; Chapter 6 Text Functions; Chapter 7 Dates and Date Functions; Chapter 8 Evaluating Investments with Net Present Value Criteria; Chapter 9 Internal Rate of Return; Chapter 10 Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions; Chapter 11 Circular References; Chapter 12 IF Statements; Chapter 13 The Paste Special Command; Chapter 14 The Auditing Tool
- Chapter 15 Sensitivity Analysis with Data TablesChapter 16 The Goal Seek Command; Chapter 17 Using the Scenario Manager for Sensitivity Analysis; Chapter 18 Creating and Using Spinners for Sensitivity Analysis; Chapter 19 The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions; Chapter 20 The SUMIF Function; Chapter 21 The OFFSET Function; Chapter 22 The INDIRECT Function; Chapter 23 Conditional Formatting; Chapter 24 An Introduction to Optimization with the Excel Solver; Chapter 25 Using Solver to Determine the Optimal Product Mix
- Chapter 26 Using Solver to Solve Transportation or Distribution ProblemsChapter 27 Using Solver to Schedule Your Workforce; Chapter 28 Using Solver for Capital Budgeting; Chapter 29 Using Solver for Financial Planning; Chapter 30 Using Solver to Rate Sports Teams; Chapter 31 Importing Text or Microsoft Word Data into Excel; Chapter 32 Importing Data from the Web into Excel; Chapter 33 Validating Data; Chapter 34 Summarizing Data with Histograms; Chapter 35 Summarizing Data with Descriptive Statistics; Chapter 36 Using PivotTables to Describe Data
- Chapter 37 Summarizing Data with Database Statistical FunctionsChapter 38 Filtering Data; Chapter 39 Consolidating Data; Chapter 40 Creating Subtotals; Chapter 41 Estimating Straight Line Relationships; Chapter 42 Modeling Exponential Growth; Chapter 43 The Power Curve; Chapter 44 Using Correlations to Summarize Relationships; Chapter 45 Introduction to Multiple Regression; Chapter 46 Incorporating Qualitative Factors into Multiple Regression; Chapter 47 Modeling Nonlinearities and Interactions; Chapter 48 Analysis of Variance: One-Way ANOVA; Chapter 49 Randomized Blocks and Two-Way ANOVA
- Chapter 50 Using Moving Averages to Understand Time SeriesChapter 51 Forecasting with Moving Averages; Chapter 52 Forecasting in the Presence of Special Events; Chapter 53 An Introduction to Random Variables; Chapter 54 The Binomial and Hypergeometric Random Variables; Chapter 55 The Poisson and Exponential Random Variable; Chapter 56 The Normal Random Variable; Chapter 57 Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project; Chapter 58 Introduction to Monte Carlo Simulation; Chapter 59 Calculating an Optimal Bid
- Chapter 60 Simulating Stock Prices and Asset Allocation Modeling
