Thoughtful, detailed coverage of the Mac, iPhone, and iPad, plus the best-selling Take Control ebooks.

 

 

Pick an apple! 
 
Data Tables in Microsoft Excel 2008

Data Tables let you see how the results of a formula change as its underlying variables change. After entering data, select the entire table and choose Data > Table. Then tell Excel which row input cell and column input cells you want the table to use. Finally, click OK. Excel will crunch the numbers and present a new Data Table.

Visit Microsoft Mac Mojo blog

Submitted by
Microsoft MacBU

 

 

Related Articles

 

 

Quicken 7 Investments Alert

Send Article to a Friend

Steve Becker <maceeze@aol.com> writes:

While testing Quicken 7 for an upcoming review, I found some anomalous behavior in the Investment Module that Quicken 7 users should be aware of. In the Portfolio Window, the Return On Investment (ROI) performance calculation is based on the adjusted basis of your investment (for example, your initial investment plus any reinvestments), not the actual amount initially invested. This is likely to reduce the reported ROI for the security. When running the Investment Report for the ROI, however, Quicken bases the calculation on the more standard method of treating all reinvested income from the security as a return on the initial, unadjusted investment.

This is a critical point because if you base an investment decision on the performance reported in the Portfolio Window, you might mistakenly conclude your investment is under-performing a security whose performance is reported from some other source. This is particularly true for mutual funds, which generally report performance based on a dollar amount initially invested at the beginning of the reporting period.

In addition, some other information presented in the Portfolio Window is affected by closed positions, potentially creating confusion when trying to interpret this data. I have discussed these issues with Intuit and expect an update to Quicken 7 will address these issues.

 

New for iOS 8: TextExpander 3 with custom keyboard.
Set up short abbreviations which expand to larger bits of text,
such as “Tx” for “TextExpander”. With the new custom keyboard,
you can expand abbreviations in any app, including Safari and
Mail. <http://smle.us/tetouch3-tb>