Microsoft Office Excel 2007：数据分析与业务模型（光盘）Microsoft Office Excel 2007
点此进入淘宝搜索页搜索分类: 图书,进口原版书,计算机 Computers & Internet ,
作者： Wayne L. Winston著
出 版 社： Oversea Publishing House
出版时间： 2007-5-1字数：版次： 1页数： 601印刷时间： 2007/05/01开本： 16开印次： 1纸张： 胶版纸I S B N ： 9780735623965包装： 平装内容简介
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 Office Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guideupdated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. Youll learn how to create best, worst, and most-likely scenarios for sales, estimate a products demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. Youll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty. You get all the books problem-and-solution files on CDfor all the practice you need to solve complex problems and work smarter with Excel.
目录
Preface
Introduction
1 Range Names
2 Lookup Functions
3 The INDEX Function
4 The MATCH Function
5 Text Functions
6 Dates and Date Functions
7 Evaluating Investments by Using Net Present Value Criteria
8 Internal Rate of Return
9 More Excel Financial Functions
10 Circular References
11 IF Statements
12 Time and Time Functions
13 The Paste Special Command
14 The Auditing Tool
15 Sensitivity Analysis with Data Tables
16 The Goal Seek Command
17 Using the Scenario Manager for Sensitivity Analysis
18 The CO.IF. COUNTIFS. COUNT. COUNTA. and COUNTBLANK Functions
19 The SUMIF. AVERAGEIF. SUMIFS. and AVERAGEIFS Functions
20 The OFFSET Function
21 The INDIRECT Function
22 Conditional Formatting
23 Sorting in Excel
24 Tables
25 Spin Buttons, Scroll Bars, Option Buttons, Check Boxes,Combo Boxes, and Group List Boxes
26 An Introduction to Optimization with Excel Solver
27 Using Solver to Determine the Optimal Product Mix
28 Using Solver to Schedule Your Workforce
29 Using Solver to Solve Transportation or Distribution Problems
30 Using Solver for Capital Budgeting
31 Using Solver for Financial Planning
32 Using Solver to Rate Sports Teams
33 Importing Data from a Text File or Document
34 Importing Data from the Internet
35 Validating Data
36 Summarizing Data by Using Histograms
37 Summarizing Data by Using Descriptive Statistics
38 Using PivotTables to Describe Data
39 Summarizing Data with Database Statistical Functions
40 Filtering Data and Removing Duplicates
41 Consolidating Data
42 Creating Subtotals
43 Estimating Straight Line Relationships
44 Modeling Exponential Growth
45 The Power Curve
46 Using Correlations to Summarize Relationships
……
Index
