[学习分享] 微软EXCEL 数据分析和商业建模 [推广有奖]

4关注
4粉丝

博士生

13%

还不是VIP/贵宾

威望: 0 级
论坛币: 1397 个
通用积分: 2.6025
学术水平: 2 点
热心指数: 3 点
信用等级: 1 点
经验: 287 点
帖子: 100
精华: 0
在线时间: 321 小时
注册时间: 2005-4-12
最后登录: 2024-4-28

楼主

adfansor 发表于 2007-1-23 18:21:00 |只看作者 |坛友微信交流群|倒序 |AI写论文

相似文件

换一批

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

microsoft excel data analysis and business modeling

是英文版的。微软出的书，含金量无须多言。

附后有数据，是从微软官网下载的，但是我不明白为什么微软只是提供了部分数据

因为是好东西，略收几个币，希望大家理解。如果有人学习这本书，更希望能与我交流，我已经看了一部分，相当不错。

电子书 pdf 格式

86781.pdf (6.51 MB, 需要: 20 个论坛币)

数据文件如下：

86777.rar (450.31 KB, 需要: 20 个论坛币) 本附件包括：

ExcelDABM.exe

PS：

1.因为从官方下载的数据并不全，所以有的得自己去录入，我以后会随着学习陆续把自己做的数据放上来。方便大家，不要再一次次重复录入。算是增值服务吧。呵呵。希望大家能一块学。而不仅仅是下载。如果大家想回贴，请讨论书中的内容，不要回贴“好东西，谢谢”之类无实际意义的内容。以方便大家阅读。

2.不要以为价格不高就东西就不够好，为了说明书的内容有价值，决定以后每天价钱上涨一个币。

Table of Contents
Microsoft Excel Data Analysis and Business Modeling
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 Tables
Chapter 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 Problems
Chapter 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 Functions
Chapter 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 Series
Chapter 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
Chapter 61 - Fun and Games: Simulating Gambling and Sporting Event Probabilities
Chapter 62 - Using Resampling to Analyze Data
Chapter 63 - Pricing Stock Options
Chapter 64 - Determining Customer Value
Chapter 65 - The Economic Order Quantity Inventory Model
Chapter 66 - Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder?
Chapter 67 - Queuing Theory: The Mathematics of Waiting in Line
Chapter 68 - Estimating a Demand Curve
Chapter 69 - Pricing Products with Tie-Ins
Chapter 70 - Pricing Products Using Subjectively Determined Demand
Chapter 71 - Nonlinear Pricing
Chapter 72 - Array Formulas and Functions
Chapter 73 - Picking Your Fantasy Football Team
Index
List of Figures
List of Tables
List of Sidebars