Comments:
*******************************************************************************<br />
Excel Hacks: Tips and Tools for Streamling Your Spreadsheets<br />
*******************************************************************************<br />
<br />
-------------------------------------------------------------------------------<br />
General Information<br />
-------------------------------------------------------------------------------<br />
Type.................: Ebook<br />
Part Size............: 8,822,722 bytes<br />
<br />
<br />
<br />
<br />
-------------------------------------------------------------------------------<br />
Post Information<br />
-------------------------------------------------------------------------------<br />
Posted by............: ~tqw~<br />
<br />
-------------------------------------------------------------------------------<br />
Release Notes<br />
-------------------------------------------------------------------------------<br />
Millions of users create and share Excel spreadsheets every day, but few go <br />
deeply enough to learn the techniques that will make their work much easier. <br />
There are many ways to take advantage of Excel's advanced capabilities without <br />
spending hours on advanced study. Excel Hacks provides more than 130 hacks -- <br />
clever tools, tips and techniques -- that will leapfrog your work beyond the <br />
ordinary.<br />
<br />
Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide <br />
gives you little known "backdoor" tricks for several Excel versions using <br />
different platforms and external applications. Think of this book as a toolbox. <br />
When a need arises or a problem occurs, you can simply use the right tool for <br />
the job. Hacks are grouped into chapters so you can find what you need quickly, <br />
including ways to:<br />
-Reduce workbook and worksheet frustration -- manage how users interact with <br />
worksheets, find and highlight information, and deal with debris and corruption.<br />
-Analyze and manage data -- extend and automate these features, moving beyond <br />
the limited tasks they were designed to perform.<br />
-Hack names -- learn not only how to name cells and ranges, but also how to <br />
create names that adapt to the data in your spreadsheet.<br />
-Get the most out of PivotTables -- avoid the problems that make them <br />
frustrating and learn how to extend them.<br />
-Create customized charts -- tweak and combine Excel's built-in charting <br />
capabilities.<br />
-Hack formulas and functions -- subjects range from moving formulas around to <br />
dealing with datatype issues to improving recalculation time.<br />
-Make the most of macros -- including ways to manage them and use them to extend <br />
other features.<br />
-Connect Excel to the world -- use XML and take advantage of web sites and <br />
services from Google and Amazon to get information into and out of your <br />
spreadsheets.<br />
<br />
You can either browse through the book or read it from cover to cover, studying <br />
the procedures and scripts to learn more about Excel. However you use it, Excel <br />
Hacks will help you increase productivity and give you hours of "hacking" <br />
enjoyment along the way.<br />
<br />
Table Of Contents<br />
Credits xiii<br />
Preface xv<br />
Chapter 1. Reducing Workbook and Worksheet Frustration 1<br />
Chapter 2. Hacking Excel’s Built-in Features 48<br />
Chapter 3. Naming Hacks 105<br />
Chapter 4. Hacking PivotTables 124<br />
Chapter 5. Charting Hacks 140<br />
Chapter 6. Hacking Formulas and Functions 193<br />
Chapter 7. Macro Hacks 263<br />
Chapter 8. Cross-Application Hacks 331<br />
Index 355<br />
<br />
Product Details<br />
<br />
* ISBN: 0596528345<br />
* ISBN-13: 9780596528348<br />
* Format: Paperback, 386pp<br />
* Publisher: O'Reilly Media, Incorporated<br />
* Pub. Date: June 2007<br />
* Edition Number: 2<br />
<br />
-------------------------------------------------------------------------------<br />
Install Notes<br />
-------------------------------------------------------------------------------<br />
Adobe Acrobat Reader<br />
News:
Hide your personal activity while downloading torrents with TorrentPrivacy.com
Excel Hacks Tips and Tools for Streamling Your Spreadsheets~tqw~_darksiderg.nfo
Excel Hacks Tips and Tools for Streamling Your Spreadsheets~tqw~_darksiderg.pdf
Anime
Software
Games
Movies
Music
Other
Series/TV Shows
External comments