微软EXCEL 数据分析和商业建模

相似文件 换一批

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

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

立即领取

感谢您参与论坛问题回答

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

+2 论坛币

microsoft excel data analysis and business modeling

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

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

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

电子书 pdf 格式

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

2007-1-23 18:29:00 上传

[分享]微软EXCEL 数据分析和商业建模
需要: 20 个论坛币  [购买]

数据文件如下：

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

• ExcelDABM.exe

2007-1-23 18:20:00 上传

[分享]微软EXCEL 数据分析和商业建模
需要: 20 个论坛币  [购买]

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

[此贴子已经被作者于2007-4-30 12:23:09编辑过]

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享1 收藏12 回帖

关键词：EXCEL 数据分析 xcel exce cel 商业 数据 建模 EXCEL 微软 数据分析专题 数据处理 数据分析软件 数据分析报告 面板数据分析 excel数据分析 数据分析方法 项目数据分析

好书，不过太贵了。。。

我有这本书的高清pdf 哈哈 下次也跟楼主抢抢生意来卖
说实话 这本书 确实是我见过市面上用excel做高端的数据分析很难得的一本好书！
之前用过里面的data table 和 蒙特卡洛模拟 都很实用！

谢谢分享

太贵了  楼主

想要，可买不起

太贵了呀lz

在这个论坛人家是免费的!!!!!!!

不便宜哇~~~~~~~~~~

雖然好 可是太貴了吧