iWork '09: Numbers

ByMike Moffit

Noted features:

  • Easily create formulas, using visual placeholders with plain language text.
  • Perform calculations using over 250 functions.
  • Organize your data instantly using Table Categories.
  • Check your calculations at a glance with Formula List view.
  • Create two-axis charts and combine line, column, and area series in a single mixed chart.
  • Choose from twelve new Apple-designed templates (30 total).
  • Open, save, and email Microsoft Excel files from within Numbers.

Similar Posts

  • iLife '09 Update: iPhoto

    iPhoto has gotten many updates in the iLife ’09 edition. iPhoto is arguably the most-used application in the iLife suite, behind iTunes.

    For starters, there are now three ways to sort your photos:

    * Events
    * Faces
    * Places

    Events was a new way to view and sort photos with the last iLife release, but both Faces and Places are new.

    Faces relies on face recognition, and assists in tagging photos. Amazingly, it will find a face and ask in other photos if it is the same person… I guess we’ll see! There’s also integration with Facebook and Flickr.

    Places works with Google Maps to zoom in on a location. It uses latitude and longitude, and will automatically add a location to your photos. This is great because you’ll be able to ‘geotag’ your entire set of photos. Phil uses the example of “Yosemite” in that if you have just taken a vacation there, it will geotag all of your photos from the trip!

    I’m really excited to check iPhoto ’09 out, especially the tagging and face recognition features. As Don mused, “will it be able to recognize dog’s faces, too?” We’ll be checking out iLife ’09 in detail soon and will give you our feedback in upcoming issues of Tech Tails!

    “Learn more and pre-order iLife 09 here.”:http://www.smalldog.com/product/72885

  • Picasa for Mac – Better Late Than Never!

    On Monday, Google finally released a public beta of Picasa for the Mac. Picasa is a free desktop app for importing, editing, organizing and sharing digital images–particularly digital photos.

    Picasa for Macs is a free download from “Picasa.google.com/mac/”:http://picasa.google.com/mac/. You need an Intel Mac running OS 10.4 or later.

    Picasa has been a popular photo app on the Windows side for years. It shares some features with iPhoto, and adds some unique killer features. These include the ability to sync your Picasa desktop and Picasa Web Albums edits, screen captures, create and edit movies within Picasa, add text/watermarks to photos, manage folders on your computer, a collage creation, screensaver creation, and Facial-recognition technology. Privacy and sharing settings can be adjusted for individual photos, collections or for your entire library.

    Preliminary tests show Picasa to be as fast or faster than iPhoto and easy and elegant to use. We’ll test further and review Picasa in detail in the future.

    Google also offers Picasa Web Albums, which is an excellent web service for sharing and organizing photos. This has been Mac-compatible for years. There is an iPhoto plugin if you want to use Picasa Web Albums without necessarily using the desktop version of Picasa. “Click here to download this.”:http://picasa.google.com/mac_tools.html

    Also, the new version of iPhoto ’09 looks amazing. News about Picasa for Mac has been swept under the rug with the announcement of iPhoto ’09.

    Picasa Web Albums integrates tightly with Google’s Blogger service, along with many other blog platforms and web services. Picasa Web Albums is very easy to use, uploading is a breeze, and photos are nicely displayed online. Picasa Web Albums offers up to 1GB (“enough space for 4,000 wallpaper-size photos”) of photo hosting for free.

    Flickr is still more popular and has deeper social network components then Picasa Web Albums. Again, we’ll do a detailed comparison in the near future.

  • iLife '09 Update: GarageBand

    At Macworld, Phil Schiller introduced a new version of GarageBand. The biggest new feature is called “Learn to Play.” It is designed to teach people to play instruments such as guitar and keyboards. You see the a representation of the instrument on the screen with a video of the instructor facing you.

    Celebrity instructors include Sting, Sarah McLachlan, John Fogerty, and more. Apple says “learn to play a hit song from the artist who made it famous,” which I think sounds pretty cool. Additional video lessons can be purchased from the new GarageBand store for $4.99.

  • iWork '09: Pages

    Pages received a bunch of updates this time around, most notably:

    * *40 new Apple-designed templates* (for over 180 total).
    * A new *full-screen view* option so that you can focus only on your writing!
    * *Dynamic outlines* allow you to organize your ideas as they come.
    * *Mail merge with Numbers* makes adding addresses, names and more really simple.
    * MathType 6 and EndNote X2 (both sold separately) integration allows you to insert equations or bibliographies (respectively).

    As always, you can open, save, and email Microsoft Word files from within Pages.

  • iLife '09 Update: iMovie '09

    Apple has updated iMovie ’08 to iMovie ’09 as part of iLife ’09. iMovie ’09 was introduced with the statement that iMovie ’08 “didn’t have all the features that older customers wanted.” Apple has added “a bunch of features that should please everyone.” Phil Schiller continued to say that Apple has added “depth and power” to iMovie ’09.

    Some of the new features include:

    * Precision editor with expanded timeline for advanced users. Improved drag and drop of video clips and audio clips. Easier to insert, overlay, replace, and add audio straight from clips. Sound can now be extended from the first clip over audio from the second clip to give pro continuity to edits. Also now easier to skim and see edits before and after cuts.

    * Automatic video stabilization. The software identifies jittery/bumpy motion and reduces it by comparing frames of video to subsequent and previous frames. Video stabilization along with image stabilization in camcorders can practically create still photos. Two-step process. The first-pass is processor intensive.

    * Now possible to integrate maps into iMovie projects, including an option for Indiana Jones-style flyovers with a beginning and end point.

    * iMovie once again supports DVD chapter makers and titles for use with iDVD ’09, which is very welcome news.

    Other features include new themes complete with titles, transitions and credits. “Clip adjustment” includes a slider to speed up or slow down video clips (which was mystifyingly absent in iMovie ’08). A new Project Library shows you all your film clips. New video effects have been added with instant previewing; no rendering is necessary. Read all new changes “by clicking here.”:http://www.apple.com/ilife/imovie/new-features.html

    Personally, the announcement of iMovie ’09 was the most exciting event at this Macworld. I can’t wait to try it out. It sounds like creating engaging, attractive videos will be more fun than ever.

    “Learn more and pre-order iLife ’09 here.”:http://www.smalldog.com/product/72885