Excel Roundup 20131125

Forget that old-fashioned mouse! Now you can control Excel during a presentation, by using your phone. Well, assuming that you have Excel 2013, and a Windows phone.

There is a link to the Office Remote app download page in the Excel Articles section below.

Contextures Posts

Here’s what I posted last week:

1. Use MAX and IF with multiple criteria, to find the latest date that a product price was changed, for a specific customer.
2. Set up a pivot table so it shows missing items, and add temporary data, if necessary.
3. No, it’s not the best way to present data, but if you have to make a pie chart, keep it simple and easy to read.
4. Finally, for a humorous peek at what other people are saying about Excel, read this week’s collection of Excel tweets, on my Excel Theatre blog.

Other Excel Articles

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

1. The IT Faculty of the Institute of Chartered Accountants in England & Wales has posted a draft version of their Twenty Principles for Good Spreadsheet Practice, and they would like your feedback.
2. Microsoft Research just released its Office Remote application, which lets you use your Windows phone to navigate through an Excel 2013 workbook during a presentation.
3. On the Visual.ly blog, someone shared their map of Australia and a column chart, both created by colouring worksheet cells.
4. It doesn’t have to be complicated! Learn an easy way to make bullet charts and boxplots in Excel, on the Excel Charts Blog
5. If you’re using APIs to pull data for Excel apps, be sure to format the numbers correctly. The Office Developer Team shares some sample code.
6. Instead of using macros, add a hyperlink to a shape, for workbook navigation. Mynda Treacy shows the steps.
7. When you’re programming an Excel file, it’s nice to have a quick way to open the workbook, with everything unlocked and ready to edit. Scott Lyerly shares his trick for adding a back door to your Excel files
8. Do you love pivot tables? Data journalist, Nassos Stylianou loves them too, and shares a few tips on the Digitally Focused blog.
9. If you need to calculate the last day of any month, you can use Chandoo’s simple formula.

What Did You Read?

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.

___________________