Your spreadsheet contains a huge table of data you want to slice and dice on the fly? You need the AutoFilter feature, which works like a database query builder—or for the non-bitheads, iTunes Smart Playlists. Select the criteria of the data you want to see, and AutoFilter will show you only the rows that match without actually changing any of the data (like sorting it would). The Productivity Portfolio weblog explains in detail, with helpful screenshots.
Excel AutoFilter | Filter Excel Spreadsheets [Productivity Portfolio]Telephony geek Brian Aker controls his entire home phone system using the free, open source Asterisk software which does some crazy stuff, like IM’s him whenever the phone rings, sets custom MP3 hold music, and—my favorite—forwards annoying telemarketing calls to the very loud sound of monkeys screaming. Hit the play button to hear Brian’s recent five minute presentation at the Ignite Seattle tech event. Thanks, Brady! More »
