免费下载书籍地址:PDF下载地址
精美图片

Microsoft Office Excel 2007:数据分析与业务模型(光盘)Microsoft Office Excel 2007书籍详细信息
- ISBN:9780735623965
- 作者:暂无作者
- 出版社:暂无出版社
- 出版时间:2007-05
- 页数:624
- 价格:318.60
- 纸张:胶版纸
- 装帧:平装
- 开本:16开
- 语言:未知
- 丛书:暂无丛书
- TAG:暂无
- 豆瓣评分:暂无豆瓣评分
内容简介:
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
作者介绍:
暂无相关内容,正在全力查找中
出版社信息:
暂无出版社相关信息,正在全力查找中!
书籍摘录:
暂无相关书籍摘录,正在全力查找中!
在线阅读/听书/购买/PDF下载地址:
在线阅读地址: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
书籍真实打分
故事情节:5分
人物塑造:8分
主题深度:8分
文字风格:7分
语言运用:4分
文笔流畅:7分
思想传递:7分
知识深度:9分
知识广度:6分
实用性:9分
章节划分:3分
结构布局:5分
新颖与独特:4分
情感共鸣:7分
引人入胜:6分
现实相关:7分
沉浸感:3分
事实准确性:4分
文化贡献:4分
网站评分
书籍多样性:6分
书籍信息完全性:7分
网站更新速度:9分
使用便利性:3分
书籍清晰度:8分
书籍格式兼容性:9分
是否包含广告:5分
加载速度:5分
安全性:8分
稳定性:6分
搜索功能:5分
下载便捷性:3分
下载点评
- 无颠倒(149+)
- 值得下载(617+)
- 速度快(155+)
- 速度慢(640+)
- 体验还行(577+)
- azw3(558+)
- txt(62+)
- 三星好评(475+)
- 无多页(230+)
- 四星好评(132+)
下载评价
网友 芮***枫:有点意思的网站,赞一个真心好好好 哈哈
网友 常***翠:哈哈哈哈哈哈
网友 訾***雰:下载速度很快,我选择的是epub格式
网友 权***波:收费就是好,还可以多种搜索,实在不行直接留言,24小时没发到你邮箱自动退款的!
网友 屠***好:还行吧。
网友 薛***玉:就是我想要的!!!
网友 曾***玉:直接选择epub/azw3/mobi就可以了,然后导入微信读书,体验百分百!!!
网友 冉***兮:如果满分一百分,我愿意给你99分,剩下一分怕你骄傲
网友 游***钰:用了才知道好用,推荐!太好用了
网友 国***芳:五星好评
网友 曾***文:五星好评哦
网友 仰***兰:喜欢!很棒!!超级推荐!
网友 濮***彤:好棒啊!图书很全
网友 权***颜:下载地址、格式选择、下载方式都还挺多的
网友 印***文:我很喜欢这种风格样式。
网友 通***蕊:五颗星、五颗星,大赞还觉得不错!~~