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 | 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 | Sep 19, 2012 | How Tos and Q&As
THREE people in the past 24 hours have had DROPDOWN DRAMA! But there are easy solutions. We just need to relax. QUESTION Cheryl maintains clean data, by using dropdown lists to control data entry. But there’s a problem she describes: “Oh! I hate it when I...
by Oz du Soleil | Sep 13, 2012 | How Tos and Q&As
QUESTION Joy wants to type 2 – 8 into Excel and 8-FEB is what she keeps getting. No. Joy doesn’t want a date, she’s already married. The goal is to offer a range of options, one of them being 2 – 8 2 – 8 Hours 2 – 8 Vehicles 2...
by Oz du Soleil | Sep 12, 2012 | How Tos and Q&As
QUESTION: This question was submitted by Frank. He wants to know: How do we control the x-axis and get the line chart to use the ages 62 to 100-ish on the x-axis? The graph takes our range of 62 – 100 and turns the x-axis into 0 to 100? ANSWER Sometimes we can...