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 […]
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 […]
***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 […]
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, […]
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 […]
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 […]
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 for the Real World I studentVery nice course! Everything has been explained super clearly and I learned some very handy things.
Emerald Green Cover for Mac Excel $24.99 
Hot Pink Cover for Mac Excel $24.99 
Cool Blue Cover for Mac Excel $24.99 
