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...
by Oz du Soleil | Sep 7, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Development, Tips
Crossfooting is the Word of the Day. I woke up today and read a forum post about spreadsheet errors. Smart spreadsheet users include crossfooting to check the integrity of their spreadsheets and results. So: what is crossfooting? Crossfooting: calculating a...
by Oz du Soleil | Sep 6, 2012 | Data Management, Spreadsheet Development, Tips
What Are Pivot Tables Used For? What Are Pivot Tables Good For? My last post described spreadsheet Pivot Tables and tonight I was talking with my good friend Patrick Richards. He commented that he wasn’t left with a clear sense of what a Pivot Table is....
by Oz du Soleil | Sep 4, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Tidiness
What Are Pivot Tables Used For? What Are Pivot Tables Good For? Many of you have heard of Pivot Tables and aren’t sure what they are. I’ll leave you to Google how to mechanically get one working but if you’re like me, teaching the mechanics...
by Oz du Soleil | Aug 20, 2012 | Data Management, Excel Geekdom, Tips
The Data Marshall returns to tell you about a feature in the forthcoming Excel 15. It’s going to be invaluable in Taming Dataville. There isn’t an official release date for Office 15 but there are previews and lots to be excited about. Check out this video...
