Tongfamily Website

Tips, Tricks and Traps from the Tong’s

Tongfamily Website header image 4

Mac Excel function keys

September 12th, 2008 · No Comments · Geek

Mac 101: Reclaim your function keys – The Unofficial Apple Weblog (TUAW)
The folks at Bitbox have described the simple steps needed to get some of that old flexibility back. First, launch system preferences and click the “Keyboard” tab. Next, select the “Use all F1, F2 etc. keys as standard function keys” option.
For Excel lovers, this [...]

[Read more →]

Tags: ············

PC Office Compatibility mode for Mac Office

September 12th, 2008 · No Comments · Geek

One of the maddening things about the Mac Office 2004/2008 line is that it is not keystroke compatible with Windows Office. I don’t know why they don’t have a compatibility mode so that for instance Ctrl-+ works (this is insert) or Ctrl—(this is delete) or Shift-Space which is select row, but they don’t. The same [...]

[Read more →]

Tags: ·············

Excel 2008 bugs make it useless for loans and private equity

August 27th, 2008 · No Comments · Geek

Wow, I can’t believe Microsoft would ship a product like this. Beware, Excel 2008 won’t recalc XIRR correctly and in fact any sheet that has an intentional reference where loan amounts have fees that are dependent. This has worked in versions of Excel for the last 20 years. So sad, it means that Excel 2008 [...]

[Read more →]

Tags: ·············