Excel Roundup 20140915

Are you brave enough to enter the ModelOff competition, that tests your financial modeling skills in Excel?

To help you decide if you’d like to enter, there are workbooks with questions from previous years, available for download. For example, can you find and fix the errors in a workbook?

ModelOff question find errors

There is a discussion on the Mr. Excel forum too, where you can see the questions and solutions, and read what other people suggest as alternatives solutions. Even if you don’t want to compete, you might learn some interesting new tricks there.

To register, go to the ModelOff website, for more details and deadlines

  • Round 1 (online) is Oct. 25th, and Round 2 (online) is Nov. 8th.
  • The Top 16 finalists will compete in New York in December.

Contextures Posts

Here’s what I posted recently:

Other Excel Articles

Here are a few of the Excel articles that I read recently, that you might find useful:

  • Did you know about the data entry shortcut that Gasper Kamensek discovered, while teaching a basic Excel class?  When I checked the survey results, all the respondents had picked “No” (including me).
  • Take a look at the amazing dashboard that Robert Mundigl built, featuring an animated chart.
  • Andrew Wulf shares the lessons that he has learned from a lifetime of programming. My favorite – Never stop learning.
  • Filtering has been enhanced in Power Map, and Custom Maps have been added. You should receive the update soon, if you have an Office 365 subscription that includes Power BI.
  • Jon Peltier pushes Excel to its limits, by creating a Swimmer chart. It shows patient responses to drug treatments, but you could adapt the technique for other uses.
  • Donna Gilliland uses conditional formatting and Sort by Color to group text entries in a worksheet.

Excel Announcements

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

jankarelpieterse

Excel VBA for Financials, 2-day course led by Excel experts, Jan Karel Pieterse and Tony de Jonker

This Dutch course is specifically aimed at the Finance professional. It has no frills, and no technical mumbo-jumbo – just the VBA you need to achieve more success in your daily job.

Date: November 19 and December 3, 2014

Location: Utrecht (Netherlands)

   
Beginning Power BI with Excel 2013, by Dan Clark

"Guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you’ve learned in each chapter."

   
modeloff2014

Registration has opened for this year's ModelOff competition. Test your financial modeling skills against top modelers from around the world. Participants from over 100 countries progress through two Online Qualification Rounds with a Live Finals Event held in New York.

  • Round 1 (online) is Oct. 25th, and Round 2 (online) is Nov. 8th.
  • The Top 16 finalists will compete in New York in December.

Note: A video starts to play automatically on the ModelOff site – turn off your speakers, if you don’t want to alarm your co-workers.

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

101excelformulas   excelfunctionsheld01  

_________________________________

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>