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 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 | Jul 25, 2012 | Excel Geekdom
Please don’t hold this against me: I don’t use Excel keyboard shortcuts. Why not? In the world of software CTRL+C and CTRL-V are almost universal for Copy and Paste. Beyond that I just got concerned about overlap and mentally keeping them straight. A key...
by Oz du Soleil | Jun 6, 2012 | Excel Geekdom, Tips
Excel is already exciting, and then you add macros or VBA (Visual Basic for Applications) into the mix and WOAH! When I started using Excel VBA with regularity, it seemed like the right VBA code would allow me to see into the future. I’ve used VBA for...