Thursday, August 23, 2007

Numbers Rocks

Mac Thought Crime:

There’s a generous helping of functions, and for obvious reasons, they have the same syntax as in Excel. Not nearly all of Excel’s functions are present, though. Worse, I’ve been relying heavily on Excel’s extensive help system when constructing a function: as you type, it displays the syntax for you, and mousing over each part will show you additional details. It’s very easy to get specific help for each function. Not so in Numbers: you’re pretty much on your own, and help is awkward. Functions are probably also considered an advanced feature that relatively few users would be interested in. Hopefully, Apple will beef up this part of Numbers for the next version.

There is one very useful feature, though, that immediately made me a fan (that is, if one can get fanatic about spreadsheets). Select a few cells in Excel, and the application will display the sum of all the numbers in them. Numbers takes this concept a step further: not only does it display their sum, count, average, minimum and maximum, but also lets you drag these to your table, as a really quick and easy way to create a summary field. Well done, that one!

Comments RSS · Twitter

Leave a Comment