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...
by Oz du Soleil | Nov 12, 2012 | Case Studies, Data Integrity, Data Management
We can talk all the live-long day about keeping clean data but there will still be corrupt data and human blunders. What happens when it’s our own damned fault? This topic is à propos after a recent chat with a Database Administrator about the realities of...
