Archive / Excel Formulas

RSS feed for this section

Excel Formula Final Question #4 from Modeloff 2013 Released with Explanation (4 of 4)

The long awaited final question from Modeloff 2013 is here! Sorry for keeping you all waiting so long, KeyCuts has been going through some really awesome developments and we have not had a lot of time to blog. Our goal is to increase our blogging to once a week so expect awesome stories around Excel, analysis, […]

Modeloff 2013 Excel Challenge #3 Follow Up Explanation

Sometimes when an Excel expert provides you with advice, it makes sense to write it down somewhere and share it with people you know will find this advice useful. This is exactly what this post is about. As a follow up to Challenge #3 we posted last week, Dan Mayoh (the creator of the challenge) provided […]

Excel Formula Question #3 from Modeloff 2013 Released with Explanation (3 of 4)

Calling all Excel formula geeks, fans, and enthusiasts out there. It’s that time again! See if you have what it takes to complete the 3rd Excel challenge in this riveting series from the Modeloff 2013 award ceremonies. The 2nd challenge from last week’s post involved using array-entered formulas. Challenge #3 builds off the awesomeness of array-entered […]

Excel Formula Question #2 from Modeloff 2013 Released with Explanation (2 of 4)

Are you ready for another Excel formula challenge from the Modeloff 2013 group challenge? Question #2 requires some knowledge about array formulas and just some flat out formula building creativity. Many thanks to Dan Mayoh for providing the answers to us. Dan recently launched his consulting business called Fintega Pty Ltd; the site is still under construction […]

Excel Formula Challenge – Question #1 from Modeloff 2013 Released (with explanation)

If you read our last blog post, you’ll know we had the privilege of attending the Modeloff 2013 World Financial Modeling awards ceremony in NYC a few weeks ago. During the ceremony, the finalists were organized into teams by region to solve Excel formula building questions competing head-to-head for group prize money and bragging rights. […]