# Dear Analyst #75: How to extract first, last, and multiple middle names into 3 separate columns

In episode 52, I talked about how to extract text from a cell. You might use this formula to extract a certain value from a cell when your database or CSV export contains a bunch of miscellaneous prefix data. This formula relies on finding a certain character in the cell and then using the MID […]

# Count the number of blank values in a range in Excel

If you want to count the number of cells with blank values in them, you may think it’s as simple as using the COUNTBLANK() formula. Usually you do this if you want to know how much data is missing in your data set. Say you have a list of 10 students, and if a student […]

# Still Not Sure About Skillshare’s Intro To Excel Class? Read Reviews from Current Students!

***2018 UPDATE*** New class launched in 2018 called Beyond Excel 1: Productivity Tools for For Lean Startups, Entrepreneurs, and Freelancers. ﻿﻿ I released online Excel class on Skillshare, and the feedback has been pretty positive from students taking the course. The common thread we see through all the comments and reviews is that the pace of the course […]

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