Excel Roundup 20140519

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.

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.”

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!

_____________________

Links to Recent Excel Books on Amazon.com

__________________________________

5 Responses

1. ikkeman says:

“July 3, 2104”? that’s a long wait for the EUROsprig in lovely Delft

• @ikkeman, these events fill up fast, so sometimes you have to book a seat 90 years in advance.

2. Thanks for mentioning my “Amsterdam Excel SUmmit event in the past weeks, much appreciated.
We had a very succesful event.

3. Doug Glancy says:

Thanks Debra. Now that you mention it, I haven’t seen that workbook for a while …