微软EXCEL 数据分析和商业建模-经管之家官网！

扫码加入数据分析学习群

microsoft excel data analysis and business modeling

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

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

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

电子书 pdf 格式

数据文件如下：

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

「经管之家」APP：经管人学习、答疑、交友，就上经管之家！
免流量费下载资料----在经管之家app可以下载论坛上的所有资源，并且不额外收取下载高峰期的论坛币。
涵盖所有经管领域的优秀内容----覆盖经济、管理、金融投资、计量统计、数据分析、国贸、财会等专业的学习宝库，各类资料应有尽有。
来自五湖四海的经管达人----已经有上千万的经管人来到这里，你可以找到任何学科方向、有共同话题的朋友。
经管之家（原人大经济论坛），跨越高校的围墙，带你走进经管知识的新世界。
扫描下方二维码下载并注册APP