v

您的位置:VeryCD教育计算机


《Excel 2007 公式应用技巧》(Excel 2007 Formulas)CHM

  • 状态: 精华资源
  • 摘要:
    发行日期2007年02月12日
    对白语言英语
  • 时间: 2007/09/13 19:18:33 发布 | 2007/09/13 21:05:14 更新
  • 分类: 教育  计算机 

東京熱

精华资源: 186

全部资源: 212

相关: 分享到新浪微博   转播到腾讯微博   分享到开心网   分享到人人   分享到QQ空间   订阅本资源RSS更新   美味书签  subtitle
该内容尚未提供权利证明,无法提供下载。
中文名Excel 2007 公式应用技巧
英文名Excel 2007 Formulas
版本CHM
发行日期2007年02月12日
地区美国
对白语言英语
简介

IPB Image


书名: Excel.2007.Formulas
作者: John Walkenbach
页数: 804 pages
出版: Wiley; Pap/Cdr edition (February 12, 2007)
语言: English
ISBN-10: 0470044020
ISBN-13: 978-0470044025

本书主要面向希望深入学习Excel公式和函数功能的用户,从全新的角度形象、直观地向读者讲解Excel的高效使用方法。一方面由浅入深、循序渐进地阐述Excel公式与函数的基本概念和操作,另一方面则通过充分的实例展现Excel公式与函数在各种领域的实际应用,使读者通过实践加深对Excel公式和函数的理妥。

Book Description

This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere
Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else
John Walkenbach, aka "Mr. Spreadsheet," is one of the world’s leading authorities on Excel
Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features
Includes a valuable CD-ROM with templates and worksheets from the book
From the Back Cover
Create killer formulas—Mr. Spreadsheet shows you how
Excel master John Walkenbach has shared his expertise in two previous editions of this bestseller. Now he shows you how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and more with Excel 2007. If you already know your way around the newest Excel and want to concentrate on using formulas to extend its capabilities even further, you've come to the right place.
It's estimated that only about ten percent of Excel users really understand how to get the most out of worksheet formulas. If you're ready to join that elite group, here's your membership kit.
CD-ROM INCLUDES:
Sample files for tutorials
See the CD appendix for details and complete system requirements.
Mr. Spreadsheet's Success Techniques
Technique # 1 Master operators, error values, and absolute vs. relative references
Technique # 2 Find errors and debug formulas
Technique # 3 Use pivot tables to eliminate formulas
Technique # 4 Create single- and multi-cell array formulas
Technique # 5 Build custom functions with VBA

IPB Image

http://www.amazon.com/Excel-2007-Formulas-...70044020

Table of Contents
Part I: Basic Information.
Chapter 1: Excel in a Nutshell.
Chapter 2: Basic Facts about Formulas.
Chapter 3: Working with Names.
Part II: Using Functions in Your Formulas.
Chapter 4: Introducing Worksheet Functions.
Chapter 5: Manipulating Text.
Chapter 6: Working with Dates and Times.
Chapter 7: Counting and Summing Techniques.
Chapter 8: Using Lookup Functions.
Chapter 9: Tables and Worksheet Databases.
Chapter 10: Miscellaneous Calculations.
Part III: Financial Formulas.
Chapter 11: Borrowing and Investing Formulas.
Chapter 12: Discounting and Depreciation Formulas.
Chapter 13: Financial Schedules.
Part IV: Array Formulas.
Chapter 14: Introducing Arrays.
Chapter 15: Performing Magic with Array Formulas.
Part V: Miscellaneous Formula Techniques.
Chapter 16: Intentional Circular References.
Chapter 17: Charting Techniques.
Chapter 18: Pivot Tables.
Chapter 19: Conditional Formatting and Data Validation.
Chapter 20: Creating Megaformulas.
Chapter 21: Tools and Methods for Debugging Formulas.
Part VI: Developing Custom Worksheet Functions.
Chapter 22: Introducing VBA.
Chapter 23: Function Procedure Basics.
Chapter 24: VBA Programming Concepts.
Chapter 25: VBA Custom Function Examples.
Part VII: Appendixes.
Appendix A: Excel Function Reference.
Appendix B: Using Custom Number Formats.
Appendix C: Additional Excel Resources.
Appendix D: What’s on the CD-ROM.
Index.

[通过安全测试]
杀毒软件:kav 6.0
病毒库:2007-9-13
共享时间:不定时,一般在白天(ADSL宽带上网1M的一般上传都在30-40KB左右,
希望大家能帮忙分流.上传速度比较慢,请大家不要着急。
共享服务器:DonkeyseverNo.1
[通过安装测试]WindowsXP SP2

该下载内容仅限于个人测试学习之用,不得用于商业用途,并且请在下载后24小时内删除。版权归原作者所有,如果你喜欢,请购买正版。

正在读取……

这里是其它用户补充的资源(我也要补充):

暂无补充资源
正在加载,请稍等...

点击查看所有40网友评论

 

(?) [公告]留口水、评论相关规则 | [活动]每日签到 轻松领取电驴经验

    小贴士:
  1. 类似“顶”、“沙发”之类没有营养的文字,对勤劳贡献的楼主来说是令人沮丧的反馈信息。
  2. 提问之前请再仔细看一遍楼主的说明,或许是您遗漏了。
  3. 勿催片。请相信驴友们对分享是富有激情的,如果确有更新版本,您一定能搜索到。
  4. 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦,又没人会搭理,于人于己都无利。
  5. 如果您发现自己的评论不见了,请参考以上4条。