Excel Hacks: Tips & Tools for Streamlining Your Spreadsheets, 2nd Edition


(PDF 英文版)
by David Hawley, Raina Hawley
Paperback: 410 pages
Publisher: O'Reilly Media, Inc.; 2 edition (June 20, 2007)
ISBN-10: 0596528345
ISBN-13: 978-0596528348



Reduce workbook and worksheet frustration -- manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.


Analyze and manage data -- extend and automate these features, moving beyond the limited tasks they were designed to perform.


Hack names -- learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.


Get the most out of PivotTables -- avoid the problems that make them frustrating and learn how to extend them.


Create customized charts -- tweak and combine Excel's built-in charting capabilities.


Hack formulas and functions -- subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.


Make the most of macros -- including ways to manage them and use them to extend other features.


Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.


详细介绍，目录，源码在此：http://oreilly.com/catalog/9780596528348/index.html