O'Reilly Releases "Excel Hacks" The Creative User's Guide to Excel

"Excel Hacks" shows even the most experienced users how to do things with Excel they might never have thought of doing--and shows them how to have a little fun while they're at it. Readers learn to bring a hacker's creative approach to both common and uncommon Excel topics-- "hackers" in the sense of those who like to tinker with technology to improve it.

The little known "backdoor" adjustments in the book include everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions. "Excel Hacks" shows how to:

• Design charts that go far beyond the basic chart types and behavior
  provided by Excel
  
• Specify dynamic ranges that expand and contract to match your data and
  that you can use to create flexible formulas and charts
  
• Write macros to automatically and repetitively perform tasks in an
  efficient and predictable way
  
• Put PivotTables to work and share the results without sharing the
  underlying data
  
• Structure data so that Excel's built-in tools will process it easily
  
• Build an interactive and normalizing data entry environment
  
• Go beyond Excel--even beyond your own desktop and data--using XML and web
  services
  

This practical, roll-up-your-sleeves guide is for intermediate to advanced Excel users eager to explore new ways to make Excel do things--from data analysis to worksheet management to import/export--that you never thought possible. "Excel Hacks" (O'Reilly, US $24.95) by David and Raina Hawley will help you increase productivity with Excel and give you hours of creative enjoyment along the way.