by Oz du Soleil | Nov 27, 2012 | How Tos and Q&As
#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 9...
by Oz du Soleil | Nov 24, 2012 | How Tos and Q&As
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...
by Oz du Soleil | Nov 19, 2012 | How Tos and Q&As
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...
by Oz du Soleil | Nov 17, 2012 | How Tos and Q&As
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,...
by Oz du Soleil | Nov 12, 2012 | How Tos and Q&As
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...
by Oz du Soleil | Nov 12, 2012 | How Tos and Q&As
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...