Microsoft® Office Excel® 2007：Data Analysis and Business Modeling

作者: Wayne L. Winston 著

出版社: Oversea Publishing House

出版时间: 2007-05

版次: 1

ISBN: 9780735623965

定价: 476.90

装帧: 平装

开本: 16开

纸张: 胶版纸

页数: 601页

正文语种: 英语

分类: 外文古旧书>英文书>计算机与互联网

Mastertheanalysisandbusinessmodelingtechniquesthathelpyoutransformyourdataintobottom-lineresults.Award-winningbusinessprofessorandcorporateconsultantWayneWinstonsharesthebestofhisreal-worldexperienceinthispracticalguide—n WayneL.WinstonisaprofessorofDecisionSciencesatIndianaUniversity'sKelleySchoolofBusinessandhasearnednumerousMBAteachingawards.For20+years,hehastaughtclientsatFortune500companieshowtouseExceltomakesmarterbusinessdec 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
内容简介:
Mastertheanalysisandbusinessmodelingtechniquesthathelpyoutransformyourdataintobottom-lineresults.Award-winningbusinessprofessorandcorporateconsultantWayneWinstonsharesthebestofhisreal-worldexperienceinthispracticalguide—n
作者简介:
WayneL.WinstonisaprofessorofDecisionSciencesatIndianaUniversity'sKelleySchoolofBusinessandhasearnednumerousMBAteachingawards.For20+years,hehastaughtclientsatFortune500companieshowtouseExceltomakesmarterbusinessdec
目录:
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

查看详情

Microsoft® Office Excel® 2007：Data Analysis and Business Modeling

内容简介:

作者简介:

目录: