Excel Roundup 20140526
Are you using the iPad version of Office? The design team describes some of the design principles they used in creating this new version of the Office package, and customizing it for the iPad.
Here’s what I posted last week:
- Roger Govier shared a couple of techniques for getting a unique count in a regular pivot table.
- See how to group dates by week in a pivot table, and select your own starting date
- Do some troubleshooting with the new SHEET and SHEETS functions in Excel 2013.
- 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:
- No matter how long you’ve used Excel, there’s always a little trick or two that you can learn. Glen Gilchrist finally found the feature that lets you quickly delete blank rows. As he says, “splendiferous!”
- Doug Glancy shows how to use the MOD function, without getting any zeros in the results. So, when grouping things by fours, you’ll get 1,2,3,4 instead of 1,2,3,0.
- They’ve never been disagreeable with me, but in his latest podcast, Chandoo explains that Averages are Mean. And they must be really mean, because there will be a part 2, later this week.
- Robert Mundigl shares his template for making Marimekko charts in Excel. It’s is a combination of a 100% stacked column chart and a 100% stacked bar chart, in one view. He also posted an interactive version of the chart.
- There was an Excel Summit in Amsterdam earlier this month, and you can see a few pictures on the MVP Blog. Looks like everyone had a great time, and learned a few new tricks.
- If you’ve got some really small numbers for a chart, along with a few big ones, The Frankens Team shows how to create a broken line panel chart, to display the results.
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