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 [...]
Mac Excel function keys
September 12th, 2008 · No Comments · Geek
Tags: Excel·Excel Function·F1·F12·Flexibility·Function Keys·Keyboard Shortcuts·Keyboard Tab·Launch System·Mac·Simple Steps·System Preferences·Unofficial Apple Weblog
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 [...]
Tags: Column Shift·Compatibility Mode·Excel·Keystroke Shortcuts·Keystrokes·Last Time·Mac Office·Microsoft·Office Mac·Pc Mac·Poor Man·Right Arrow·Validation·Windows Office
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 [...]
Tags: Circular References·Excel·Formulae·Loan Amounts·Loan Calculations·Loans·Mean Time·Microsoft·Private Equity·Sad Statement·Software Quality·Value Error·Wow·Xirr