Excel Roundup 20140519

Inquire add-in

This month, TechNet posted a video that demonstrates the spreadsheet management features that are available in Office 2013. This includes Inquire, and Spreadsheet Compare.

Here’s a screen shot of the worksheet relationships in one of my sample Excel files, using the Inquire add-in.

worksheet relationship in Inquire add-in

The video is 30 minutes long, and you can find a list of articles on their website, if you’d rather read than watch.

Contextures Posts

Here’s what I posted last week:

  • 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:

  • The Frankens Team show how to create a new kind of chart in Excel – a stacked column flow chart. If you’re not a fan of the movie Young Frankenstein, you can just skip past the quote at the beginning.
  • Chandoo created a timer, to keep track of the time it takes him to solve a Rubik’s Cube puzzle. You could use it for work-related tasks too.
  • In the New York Times, Paul, who builds custom conference tables, wonders if it’s time to replace his Excel pricing workbook with something that can do a better job of estimating. Maybe we can get one that does estimates for building Excel workbooks too!

Excel Resources

Here are some upcoming events, courses and recently published books, related to Excel.

Quantitative Finance: A Simulation-Based Introduction Using Excel, by Matt Davison
532 pages, published May 8, 2014
“The book gives learning-friendly and clear instructions for using Excel spreadsheets to solve financial problems, ranging from basic net present value to highly sophisticated options pricing. The advanced material introduces the toolkit for quantitative analysis of finance, emphasizing intuition rather than mathematical rigor.”

Share Your Events and Articles

If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!
________________________________________

0 thoughts on “Excel Roundup 20140519”

Leave a Reply

Your email address will not be published.

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