<br /><br /><br>
<p>microsoft excel data analysis and business modeling</p>
<p>是英文版的。微软出的书，含金量无须多言。</p>
<p>附后有数据，是从微软官网下载的，但是我不明白为什么微软只是提供了部分数据</p>
<p>因为是好东西，略收几个币，希望大家理解。如果有人学习这本书，更希望能与我交流，我已经看了一部分，相当不错。</p>
<p>电子书 pdf 格式</p>
<p></p>
<p><br><br></p>
<p>数据文件如下：</p>
<p></p>
<p>PS：</p>
<p>1.因为从官方下载的数据并不全，所以有的得自己去录入，我以后会随着学习陆续把自己做的数据放上来。方便大家，不要再一次次重复录入。算是增值服务吧。呵呵。希望大家能一块学。而不仅仅是下载。如果大家想回贴，请讨论书中的内容，不要回贴“好东西，谢谢”之类无实际意义的内容。以方便大家阅读。</p>
<p>2.不要以为价格不高就东西就不够好，为了说明书的内容有价值，决定以后每天价钱上涨一个币。</p>
<p>目录</p>
<p>Table of Contents<br>Microsoft Excel Data Analysis and Business Modeling<br>Introduction<br>Chapter 1 - Range Names <br>Chapter 2 - Natural Language Range Names <br>Chapter 3 - Lookup Functions <br>Chapter 4 - The INDEX Function <br>Chapter 5 - The MATCH Function <br>Chapter 6 - Text Functions <br>Chapter 7 - Dates and Date Functions <br>Chapter 8 - Evaluating Investments with Net Present Value Criteria <br>Chapter 9 - Internal Rate of Return <br>Chapter 10 - Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions <br>Chapter 11 - Circular References <br>Chapter 12 - IF Statements <br>Chapter 13 - The Paste Special Command <br>Chapter 14 - The Auditing Tool <br>Chapter 15 - Sensitivity Analysis with Data Tables <br>Chapter 16 - The Goal Seek Command <br>Chapter 17 - Using the Scenario Manager for Sensitivity Analysis <br>Chapter 18 - Creating and Using Spinners for Sensitivity Analysis <br>Chapter 19 - The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions <br>Chapter 20 - The SUMIF Function <br>Chapter 21 - The OFFSET Function <br>Chapter 22 - The INDIRECT Function <br>Chapter 23 - Conditional Formatting <br>Chapter 24 - An Introduction to Optimization with the Excel Solver <br>Chapter 25 - Using Solver to Determine the Optimal Product Mix <br>Chapter 26 - Using Solver to Solve Transportation or Distribution Problems <br>Chapter 27 - Using Solver to Schedule Your Workforce <br>Chapter 28 - Using Solver for Capital Budgeting <br>Chapter 29 - Using Solver for Financial Planning <br>Chapter 30 - Using Solver to Rate Sports Teams <br>Chapter 31 - Importing Text or Microsoft Word Data into Excel <br>Chapter 32 - Importing Data from the Web into Excel <br>Chapter 33 - Validating Data <br>Chapter 34 - Summarizing Data with Histograms <br>Chapter 35 - Summarizing Data with Descriptive Statistics <br>Chapter 36 - Using PivotTables to Describe Data <br>Chapter 37 - Summarizing Data with Database Statistical Functions <br>Chapter 38 - Filtering Data <br>Chapter 39 - Consolidating Data <br>Chapter 40 - Creating Subtotals <br>Chapter 41 - Estimating Straight Line Relationships <br>Chapter 42 - Modeling Exponential Growth <br>Chapter 43 - The Power Curve <br>Chapter 44 - Using Correlations to Summarize Relationships <br>Chapter 45 - Introduction to Multiple Regression <br>Chapter 46 - Incorporating Qualitative Factors into Multiple Regression <br>Chapter 47 - Modeling Nonlinearities and Interactions <br>Chapter 48 - Analysis of Variance: One-Way ANOVA <br>Chapter 49 - Randomized Blocks and Two-Way ANOVA <br>Chapter 50 - Using Moving Averages to Understand Time Series <br>Chapter 51 - Forecasting with Moving Averages <br>Chapter 52 - Forecasting in the Presence of Special Events <br>Chapter 53 - An Introduction to Random Variables <br>Chapter 54 - The Binomial and Hypergeometric Random Variables <br>Chapter 55 - The Poisson and Exponential Random Variable <br>Chapter 56 - The Normal Random Variable <br>Chapter 57 - Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project <br>Chapter 58 - Introduction to Monte Carlo Simulation <br>Chapter 59 - Calculating an Optimal Bid <br>Chapter 60 - Simulating Stock Prices and Asset Allocation Modeling <br>Chapter 61 - Fun and Games: Simulating Gambling and Sporting Event Probabilities <br>Chapter 62 - Using Resampling to Analyze Data <br>Chapter 63 - Pricing Stock Options <br>Chapter 64 - Determining Customer Value <br>Chapter 65 - The Economic Order Quantity Inventory Model <br>Chapter 66 - Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder? <br>Chapter 67 - Queuing Theory: The Mathematics of Waiting in Line <br>Chapter 68 - Estimating a Demand Curve <br>Chapter 69 - Pricing Products with Tie-Ins <br>Chapter 70 - Pricing Products Using Subjectively Determined Demand <br>Chapter 71 - Nonlinear Pricing <br>Chapter 72 - Array Formulas and Functions <br>Chapter 73 - Picking Your Fantasy Football Team <br>Index<br>List of Figures<br>List of Tables<br>List of Sidebars<br></p><br><br><br>
<p align="right"><font color="#000066">[此贴子已经被作者于2007-4-30 12:23:09编辑过]</font></p>