Microsoft Office Excel 2007：数据分析与业务模型（光盘）Microsoft Office Excel 2007 mobi 下载 网盘 caj lrf pdf txt 阿里云

Master the techniques that business ***ysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known c***ultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Office Excel for data ***ysis, modeling, and decision ***. 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 ***ysis 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 smarte***ith Excel.

Preface

Introduction

1 Range Names

2 Lookup Functi***

3 The INDEX Function

4 The MA***H Function

5 Text Functi***

6 Dates and Date Functi***

7 Evaluating Investments by Using Net Present Value Criteria

8 Internal Rate of Return

9 More Excel Financial Functi***

10 Circular References

11 IF Statements

12 Time and Time Functi***

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 Functi***

19 The SUMIF. ***ERAGEIF. SUMIFS. and ***ERAGEIFS Functi***

20 The OFFSET Function

21 The INDIRECT Function

22 Conditional Formatting

23 Sorting in Excel

24 Tables

25 Spin Butt***, Scroll Bars, Option Butt***, 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 Functi***

40 Filtering Data and Removing Duplicates

41 C***olidating Data

42 Creating Subtotals

43 Estimating Straight Line Relati***hips

44 Modeling Exponential Growth

45 The Power Curve

46 Using Correlati*** to Summarize Relati***hips

……

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 ***ysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate c***ultant 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 decisi***, 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 electi***, and more! CD Includes: Sample files from each chapter Problem-and-solution setsbuild your expertise! Fully searchable eBook