Excel Roundup 20131111

Here are a few of the Excel articles that I read last week, that you might find useful:

  1. Microsoft has improved the Office Web Apps, and you can read the details on the Excel Team's blog. The feature that looks most interesting to me is the real-time collaboration in Excel files -- you can't do that in the desktop version.
  2. On his Excel Charts blog, Jorge Camoe post a classification of chart types. He says that a chart should either compare data or reduce data, so take a look, and see if you agree.
  3. If you use the MOD operator in Excel VBA, you could run into problems with large numbers. Chip Pearson suggests some alternative formulas and code that you can use.
  4. Dick Kusleika ran into some problems while running code on a pivot table that has calculated items.

If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.

Please include a brief description, and a link to the article.


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.