Microsoft Office Excel 2007：数据分析与业务模型（光盘）Microsoft Office Excel 2007 mobi 下载 fb2 夸克云 azw3 网盘 pdf pmlz

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

暂无相关内容，正在全力查找中

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Microsoft Office Excel 2007：数据分析与业务模型（光盘）Microsoft Office Excel 2007在线阅读

在线听书地址：Microsoft Office Excel 2007：数据分析与业务模型（光盘）Microsoft Office Excel 2007在线收听

在线购买地址：Microsoft Office Excel 2007：数据分析与业务模型（光盘）Microsoft Office Excel 2007在线购买

暂无原文赏析，正在全力查找中！

书籍介绍

在线阅读本书

Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guidenow updated for Excel 2007. Use Waynes proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge. Solve real-world business problems with Excel 2007! Maximize profitsdetermine NPV, optimize your product mix, calculate ROI Create best, worst, and most-likely case scenarios for sales Analyze investment performance and help minimize risk Track your personal finances, calculate loan terms, and plan for retirement Use trend and seasonality to forecast revenue Estimate a products demand curve and manage inventory with precision Interpret the effects of price and advertising on sales Assign a dollar value to customer loyalty Solve work scheduling problems and shorten wait times for customer service queues PLUSpredict outcomes of sporting events, presidential elections, and more! CD Includes: Sample files from each chapter Problem-and-solution setsbuild your expertise! Fully searchable eBook