by Oz du Soleil | Mar 3, 2014 | Data Integrity, Spreadsheet Development, Tips
A while ago I wrote a blogpost that attracted some hostility. One commenter even called it “stupid.” 6 Reasons Not To Use VBA (Or Be Careful) was meant to be a fun warning and an invitation to BE CAREFUL. Ah! But a few folks took it as a swearing off of...
by Oz du Soleil | Feb 6, 2013 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness
Quick & dirty update! AWW WOW! Excel 2013 allows the addition of a timeline into Pivot Charts! (not included with Excel for Mac) Let’s say you have a lot of dates and want to see graphic summaries grouped by month or year. Before 2013, that called for a...
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 | 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,...