Excel Roundup 20131111
Here are a few of the Excel articles that I read last week, that you might find useful:
- 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.
- 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.
- 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.
- 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.