David & Raina Hawley – Excel Hacks (2nd Ed.)
$15.00
Reduce frustration with workbooks and worksheets-manage how users interact with worksheets
David & Raina Hawley – Excel Hacks (2nd Ed.)
Check it out: David & Raina Hawley – Excel Hacks (2nd Ed.)
Description
Millions of users create and share Excel spreadsheets every day,but few are deep enough to learn the techniques that will make their work easier. There are many ways to take advantage of Excel\’s advanced features without spending hours on advanced learning.Excel hack offers more than 130 hacks-smart tools, tips and techniques-that will go beyond ordinary beyond your work.
Now extended to include Excel2007,this resourceful, roll up your sleeves guide gives you little-known\”backdoor\”tips for using several Excel versions of different platforms and external applications. Think of the book as a toolbox. When a need arises or a problem arises, you can simply work with the right tools. The hack is divided into chapters so you can find what you need quickly, including how to:
Reduce frustration with workbooks and worksheets-manage how users interact with worksheets, find and highlight information, and deal with fragmentation and corruption.
Analyze and manage data-extend and automate these capabilities beyond the limited tasks designed to perform.
Hack names-not only learn how to name cells and ranges, but also learn how to create names that adapt to the data in spreadsheets.
Get the most out of PivotTable—avoid the frustrating problems that make PivotTable and learn how to scale PivotTable.
Create custom charts-adjust and combine Excel\’s built-in Chart features.
Hack formulas and functions-topics range from moving formulas to dealing with data type problems to improve recalculation time.
Get the most out of macros—includes ways to manage macros and extend other features using macros.
Use Microsoft Office2007 enhancements to use Excel with Word, Access, and Outlook.
You can browse the book, or read from cover to cover, learn programs and scripts to learn more about Excel. Wherever you use it, Excel hack will help you increase your productivity and give you hours of\”hacking\”enjoyment on the way.
