by Oz du Soleil | Feb 17, 2014 | How Tos and Q&As
Q: Why does a knight have a lance, armor and a solid horse? A: All of those pieces make it a helluva lot easier to succeed inside the reality of knocking another person off of their horse. The task of unhorsing is fairly simple in concept. But problems arise quickly...
by Oz du Soleil | Sep 3, 2013 | How Tos and Q&As
QUESTION What are the elements of a strong spreadsheet? This question came from Judie Knoerle of Red Cup Presentations. Judy and I attend a networking group and I spoke highly of a friend’s spreadsheet. My friend had asked me to look at her spreadsheet and...
by Oz du Soleil | Jan 4, 2013 | How Tos and Q&As
QUESTION Rowka asked “how do I make this formula smaller?” =IF(AND(E11>=K7,E11<=N7,F11>=K7,F11<=N7,G11>=K7,G11<=N7),”PASS”,”FAIL”) Translation of the Formula: If tests 1 thru 3 are within acceptable ranges, then...
by Oz du Soleil | Dec 17, 2012 | How Tos and Q&As
And here we are at the 5th of the Top 5 Excel Functions to Know! SUMIFS is in the Top 5 because when you’re working with numbers and need to do analysis or summaries, SUMIFS makes it so easy to see details that you need to see. We didn’t always have this....
by Oz du Soleil | Dec 12, 2012 | How Tos and Q&As
#4 in the List of Top 5 Functions: IFERROR Q: What do an acrobat and Excel’s IFERROR function have in common? A: An acrobat and an Excel user who employs IFERROR are both expressing: it’s risky but I know what I’m doing and I do it with elegance...
by Oz du Soleil | Dec 6, 2012 | How Tos and Q&As
# 3 In our Top 5 Excel Functions, the Operators AND & OR Excel AND and OR functions are fairly straightforward. In this post, we see cover details and warnings. And we wrap up with a Thought Exercise rather than examples. So, let’s hit it! If VLOOKUP were a...