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.
Or watch on YouTube: Spreadsheet Controls in Office
Here’s what I posted last week:
- Show data validation items in a List Box, instead of a drop down; you can change the font size, list length and width
- Group dates to compare monthly totals, year over year, in a pivot chart.
- Change all the pivot tables on the active worksheet, by making a selection in a cell drop down list.
- 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.
- Ed Bott shares six tricks for getting the most of the free cloud storage that comes with Microsoft One Drive.
- 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.
- Doug Glancy experimented with pivot table circular references, and it’s a miracle that his workbook didn’t disappear into a black hole.
- 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!
- Instead of linking to tables in shared Excel files, Scott Lyerly found a way to use VBA and ADO to pull data from SharePoint lists.
- Martin Boersema takes a look at a Yamazumi chart that was built in Excel, and shares the link where you can download that chart, and other free Lean and Six Sigma templates.
Here are some upcoming events, courses and recently published books, related to Excel.
- The European Spreadsheet Risks Interest Group – EuSpRIG –has announced the preliminary program for Eursprig 2014. This event will be held in Delft (Netherlands) on July 3, 2014. Read more about it on Patrick O’Beirne’s blog.
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!
Links to Recent Excel Books on Amazon.com