Select Page

#2 of the Top 5 Excel Functions: VLOOKUP

#2 of my Top 5 Excel Functions: VLOOKUP If VLOOKUP was a song, this would be it, I Like it Like That!   VLOOKUP can turn a 2-day ordeal into a 5-minute task.   Reasons to use VLOOKUP List of 400 addresses each needing to be assigned one of 9 Regions Master list of the...

#1 of the Top 5 Functions: Excel IF Function

The Excel IF function is like a nice pair of black shoes: they’re fundamental and fly under the radar. When asked about a list of Top Excel Formulas, I immediately thought of the almighty VLOOKUP. But Wait! My #1 is IF and #2 is VLOOKUP. IF is fundamental like...

Control data in a cell: Wrap Text & Alt+Enter

QUESTION Too much text and not enough space Nicole wonders how to control data in a single cell. Specifically, how can you get all the text to show without getting clipped off or making the font really small AND without making the column wider? In this image we see...

Top 5 Excel Functions

Here’s the answer to a question about THE Excel Functions To Know. The request was for the top 10 but 10 is too many. After 3 or 4 functions, they get difficult to rank because they fall into areas of infrequent use or exclusive use. Things like INDIRECT, INDEX,...

Excel Percents, IFERROR, Helper Columns & Tidiness

QUESTION Nicole wanted to clean up a spreadsheet. She already had an answer to the math: Problem: She was doing it in more than one step and was sure things could be more tidy. Yes. This has a fairly easy solution but small things like this can irritate an Excel user...

Excel, Music and Songwriting

QUESTION Brother Henning asked about the relationship between bass playing and Excel skill. Part of the answer is in a previous blogpost where I surmise that there’s a relationship between Data Managers and people who play bass and drums. There’s a mindset...