The Mac Observer

Skip navigational links

You're viewing an article in TMO's historic archive vault. Here, we've preserved the comments and how the site looked along with the article. Use this link to view the article on our current site:
O'Reilly Releases Excel Guide

O'Reilly Releases Excel Guide

by , 7:00 AM EDT, April 9th, 2004

O'Reilly & Associates has published a new book titled; "Excel Hacks" . The book, written by David and Raina Hawley, is a guide for maximizing a users potential using the ever popular app Microsoft Excel. The book provides tips and "back-door" hacks. According to O'Reilly & Associates:

The structure of the classic Greek tragedy is fairly inflexible. The rigidity of this structure might seem antithetical to creative expression and yet it has given rise to some of the most moving verses in the history of human drama.

In the same fashion, Microsoft Excel, with its stark, bare-bones grid of cells provides a fertile medium for the eloquent presentation of data and analyses. Far more than just a number-crunching application, Excel's streamlined, familiar interface casually conceals its considerable capabilities. If you've thought that getting creative with Excel means the underhanded tweaking of numbers, think again. "Excel Hacks" by David and Raina Hawley will take your spreadsheets to a whole new level, squeezing out every ounce of meaning possible.

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
  • and more...

You can find more information about "Excel Hacks" at the O'Reilly & Associates Web site. The book is available for US$24.95.

Observer Comments

Show: Subjects Only | Full Comments
Comment on this Article

Comments are currently closed. Please email the author instead.


Recent Headlines - Updated November 21st

Fri, 7:07 PM
Games - Soccer Sim Championship Manager 2010 Released for Mac
6:47 PM
Games - EA Publishes Original Monopoly for iPhone
6:15 PM
News - Original Apple I on Ebay for $50K, w/Letter from Steve Jobs
6:11 PM
Games - New iPhone Games: Secret of the Lost Cavern Ep 1, New DJ Nights, More
5:47 PM
Games - Star Trek D-A-C Game Headed to the Mac Next Month
4:57 PM
Product News - TidBITS Releases “Take Control of Syncing Data in Snow Leopard”
4:26 PM
John Martellaro's Blog - Particle Debris (week ending 11/20) Stationery Pads Go Poof
2:59 PM
Free on iTunes - Musée du Louvre, Art Lite, SketchBook Mobile X and More.
1:50 PM
Deal Brothers - Acer P215H bmid 21.5” Widescreen LCD Monitor:  $139.99
11:24 AM
TMO Appearances - Jeff Gamet Shares More Holiday Gift Ideas on MacJury
10:43 AM
Product News - Cocktail 4.5 for Leopard Adds QuickLook Cache Clearing
10:06 AM
News - Hack Enables Mac OS X 10.6.2 on Netbooks

The Mac Observer Reader Specials

  • __________
  • Buy Stuff, Support TMO!
  • Podcast: Mac Geek Gab
  • Podcast: Apple Weekly Report
  • TMO on Twitter!