Macworld: Excel for Mac 2008 vs. Numbers ‘08

Tuesday, May 6th, 2008

Rob Griffiths, writing in Macworld, has a side be side comparison of Excel 2008 and Numbers '08. He created the same project - a sales-tracking spreadsheet - in each program, in order to test their individual strengths and weaknesses. In the end, he found Excel to be superior to Numbers ...

Tip: How To Use The Index Function To Transpose Data In Numbers

Tuesday, May 6th, 2008

I just found this great Numbers tip on Fury&Frost.com: You can use the INDEX() Function to transpose data to another table. Read the post for a full explanation, but use the following function to get the results shown in the screen shot above: =INDEX(Prefs::$A$1:$E$15,COLUMN(),ROW()) Good one!

Screen Cast: How To Place An Image Behind A Table

Sunday, May 4th, 2008

One of the unique features of Numbers is the ability to place an image in a cell, or behind a group of cells. In the case of the latter, it can be a little confusing to figure out how to accomplish this trick. I put together a short screen cast ...

Waterfall Charts in Numbers

Tuesday, April 22nd, 2008

Forum member Allmec has posted a cool example of how to create waterfall charts in Numbers. You can check out his post on the Numbers Template Forums.

Template: Household Monthly Budget

Friday, April 11th, 2008

I found this detailed, single page, household budget template for Numbers on the iwork templates blog. The author states that it was converted from an Excel file, so it doesn't display a lot of the Numbers formating flash. Still, if you are looking for a simple budget, this ...

Template: Family Tree

Friday, April 4th, 2008

The Family Tree Template for Numbers allows you to enter up to five generations of ancestry. From Wikipedia: A family tree is a chart representing family relationships in a conventional tree structure form resembling a tree. As normally presented these trees "grow" down from the top, from the oldest generations at ...

Numbers 1.0.2

Friday, February 1st, 2008

Apple released the latest update to Numbers on January 29, version 1.0.2. Apple describes the update thusly: This update addresses compatibility with Mac OSX. Awesome. Also released on January 29: Keynote Update Version: 4.0.2 Pages Update Version 3.0.2 iWeb Update Version 2.0.3

Template: Graph Paper

Sunday, January 20th, 2008

Here's something fun and useful: Graph Paper Templates. Just print a page out as you need it. The zip contains four files: graph-paper-small-grid.numbers: Graph paper template with grids spaced at .17 inches. graph-paper-small-grid.pdf: PDF version of the small grid graph paper template. graph-paper-large-grid.numbers: Graph paper template with grids spaced at .43 inches. graph-paper-large-grid.pdf: PDF ...

iWork ‘08 Has 16% of the Mac Productivity Market

Wednesday, December 12th, 2007

Macworld reports that iWork now has a 16% share of the office productivity software market on the Mac. The article notes that this big gain may be transitory as Microsoft readies it's new version of Office, which is scheduled for release January 15, 2008. Microsoft last updated Mac Office in 2004. ...

MacWorld UK Review of iWork ‘08

Thursday, December 6th, 2007

Neale Monks, writing for MacWorld UK, has written one of the better reviews of iWork, and Numbers in particular, that I have read. He notes the big improvements to Pages and Keynote since the last release, and goes into some depth on the features in Numbers.Here are some highlights: So ...