Archive for May, 2008
Friday, May 16th, 2008
Macworld is reporting that the next version of Office for the Mac will have Visual Basic for Applications (VBA) support. Microsoft caught a lot of flack for it's decision not to include VBA support in Office 2008, but apparently it would have put them too far behind schedule ...
Posted in Office | No Comments »
Thursday, May 15th, 2008
Macworld has an article detailing Service Pack 1 for Mac Office 2008. This service pack is supposed to improve performance and stability, as well fixing other small bugs. Specific improvements to Excel include: . . . restores chart formatting options available in previous versions of Office and improves ...
Posted in Office | No Comments »
Wednesday, May 14th, 2008
Spotlight is awesome, especially under Leopard. Kirk McElhearn, writing for Macworld, has written a nice tutorial on how to get better results from your spotlight queries. Highly recommended. Create good queries in Spotlight
Posted in Miscellaneous | No Comments »
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 ...
Posted in News | No Comments »
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!
Posted in Tips | No Comments »
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 ...
Posted in Tips | No Comments »
