Excel Roundup 20140210

The ModelOff Live Final for the 2013 Financial Modeling World Championships were held last December, in New York City, and Hilary Smart, from London, was the winner.

The organizer have just published an infographic about the competition, and you can see the full image on their blog.

modeloff2013

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:

  • Ken Puls is in the design stage of a new reporting system for his company. He’d like to know how you start designing software, so leave a comment on his blog post.
  • On the Daily Dose of Excel blog, Jeff Weir shows how you can add leader lines to non-pie charts, in Excel 2010 and earlier. If you have Excel 2013, this feature is now built-in.
  • It’s not just Excel that changes its format occasionally, causing compatibility problems with older versions. John Thysell explains the pain of maintaining spreadsheets in OpenOffice / LibreOffice.
  • Do you have a favourite Excel book? Chandoo shared his top picks, and you can see other people’s choices in the comments. Add your own list of favourites to the discussion.
  • Mike Alexander shows how to use Power Query to combine data from multiple Excel files into one table. It’s an amazing way to clean up your data, and you can see a demo in the End-to-End Power BI webinar (see the 24 Hour PASS Replays link below)

Online Courses

  • Last week, there were free Business Analytics courses online, in promotion of the upcoming PASS conference. If you missed them, the replays are available: 24 Hour PASS Replays
  • Chandoo has just re-opened his Power Pivot online course, and you can get the course info and registration details here: Power Pivot Course

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

0 thoughts on “Excel Roundup 20140210”

  1. I’ll admit I don’t know much about financial modeling, but if it involves visualizations, the organizer would surely lose based off that infographic. Using the people icons is cutesy, but there are several occasions where it’s downright confusing. Take the snipped you posted, for example. It looks like the 7 green people are from 2013, but if you do the math, all 30 people must be from 2013. Similarly, it’s not the 14 gray people that are from 2012, it’s the 20 from the bottom two lines.

Leave a Reply

Your email address will not be published.

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