Archive for August, 2007
Friday, August 31st, 2007
Quick Post - Two Great Resources for Apple iWork Numbers
Apple Numbers Discussion Forum - This is a great place to get friendly and helpful answers to any question about Numbers.
Apple iWork Numbers Video Tutorials - Apple has created a very helpful set of short videos to help familiarize you ...
Posted in Tips | 2 Comments »
Wednesday, August 29th, 2007
Rob Griffiths has a great tip on Macworld.com for placing images behind cells in a Numbers document.
Here’s the secret: in Numbers, any placed grid also has a fill, and it defaults to filling with white. In essence, each grid contains two layers: the bottom “grid” layer is filled with white, ...
Posted in Hacks, Tips | No Comments »
Wednesday, August 29th, 2007
I found an interesting technique a while back on the Juice Analytics site, that works well in Numbers.
The technique uses the REPT Function, to create neat in-cell graphs.
The Numbers manual defines REPT as:
REPT(text, copies)
text: The text expression to be ...
Posted in Functions, Hacks, Tips | 2 Comments »
Monday, August 27th, 2007
This template allows you to track your automobile mileage.
Usage is pretty straight forward, enter the information, and the sheet will calculate your mileage per gallon (MPG).
Download Fuel Mileage Tracker Template
Posted in Templates | 1 Comment »
Monday, August 27th, 2007
Have you ever needed to type a special character like ©, or ö? Since these are not on your keyboard, you usually have to go digging into a special symbols palate.
No more!
LiquidCity has an excellent reference to almost every special character and their keyboard shortcuts. You can find ...
Posted in Tips | No Comments »
Saturday, August 25th, 2007
Here is a great tip I found on the Apple discussion boards courtesy of Neil Barman.
You can use Numbers to export your address book entries to a comma separated values (csv) file.
Here's how you do it:
Open Address book, then select the entries you wish to export. Drag them into ...
Posted in Hacks, Tips | No Comments »
Thursday, August 23rd, 2007
By request. This is a simple spreadsheet to keep a record of your checking account transactions
Usage:
Enter a beginning balance, and date, in the upper right hand corner of the sheet.
Enter transactions as they occur, the running balance will be calculated for you.
Check the check box for the transactions as ...
Posted in Personal Finance, Templates | 10 Comments »
Wednesday, August 22nd, 2007
Hello everyone, just a quick post tonight, since I am up to my ears trying to deal with Numbers time formats. I'm working on a time sheet template, and the thing is giving me fits. I suppose I should be thankful for all the posting material this is ...
Posted in Tips | 5 Comments »
Tuesday, August 21st, 2007
Numbers user Marcus Wilhoit was the first person that I came across describing using AppleScript’s GUI support for user interface (UI) scripting, to compensate for the lack of AppleScript support in Numbers ’08.
He describes it this post on Apple Discussions forum:
http://discussions.apple.com/thread.jspa?threadID=1090948&tstart=0
Basically, the method allows a user to interact with the ...
Posted in Hacks | 3 Comments »
Sunday, August 19th, 2007
NEW VERSION ADDED 8/23/2007
One of the most glaring missing features of Apple iWork Numbers '08 is the ability to get data into the sheet from outside sources. A very common need is to pull in stock quotes, then manipulate the data. While, I have not found a ...
Posted in Business, Hacks, Personal Finance | 6 Comments »
