本站推荐使用:QQ旋风下载,迅雷下载

v

您的位置: 联合资源分享资料计算机教程 → 资料信息

Excel 2007 公式应用技巧

Excel 2007 公式应用技巧_图片预览

中文名: Excel 2007 公式应用技巧英文名: Excel 2007 Formulas版本: CHM发行时间: 2007年02月12日地区: 美国对白语言: 英语简介:
书名: 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
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小时内删除。版权归原作者所有,如果你喜欢,请购买正版。
提示:点数资源需要登录才能下载!
用户名:                    已输入:0/128 字符
内 容:
  验证码:
·上一书籍:义愤填膺
·下一书籍:我遇见奥马尔-本拉登
* 如果您下载《Excel 2007 公式应用技巧》发现下载链接错误,请点击报告错误谢谢!
* 本站采用P2P技术,下载《Excel 2007 公式应用技巧》的人越多速度越快。
* 为了达到最快的下载速度,推荐使用 电驴迅雷QQ旋风等下载软件下载本站资源。
* 站内提供的所有资源均收集自互联网,本站不参与《Excel 2007 公式应用技巧》的资源制作。
* 本站若侵犯了您的版权利益, 敬请来信通知我们!
关于本站 | 网站帮助 | 广告合作 | 网站声明 | 联系我们 | 网站地图

Copyright © 2012 - 2013 Uniow.Com
联合资源分享 - 让分享变得更简单!
ICP备案编号:蜀ICP备13007150号

官方QQ群:314822859