# Convert Text to Columns With Multiple Lines

You’ve probably had to convert text to columns before in Excel. Usually in one cell, you’ll have a long line of text that is separated by commas, semicolons, or some other delimiter and all you’re trying to do is get each value into its own column. Something along the lines of this: This is probably […]

# Calculate Average Trends in Excel

Helping some students at Columbia with an Excel exercise and though I’d post the exercise here since it brings up some interesting concepts around calculate trends and changes in values. This specific exercise is on how to calculate average trends in Excel and how to project future values based on these trends. So assume you […]

# 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. […]