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 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 3, 2012 | Data Integrity, Excel Geekdom, Guest Blogger, Spreadsheet Development, Spreadsheet Tidiness, Tips
This post will describe bad habits in Excel to do with cell formatting and formulas and how to avoid them. If you share spreadsheets in a team, the data will only be as strong as the weakest link in the team. For the first time ever, a Guest Blogpost on DataScopic.net...
by Oz du Soleil | Jun 18, 2012 | Case Studies, Data Integrity, Excel Geekdom, Screencast, Spreadsheet Tidiness, Tips
This project has a lot of pieces and resulted in something fun and challenging for me but also something quite valuable for the client. A key piece in the success was an Excel User form. Here’s a photo of me in actual battle with the Exceltopus that we roused...
by Oz du Soleil | May 1, 2012 | Case Studies, Data Integrity, Data Management, Tips
Who’s the Data Boss? Anyone? As a Data Mercenary, I’ve seen a lot. One thing that has regularly come up: disconnects in Data Governance which result in a lot of people feeling pain within and outside of the business, and confusion about who’s...
by Oz du Soleil | Apr 21, 2012 | Case Studies, Data Integrity, Data Management
One challenge in Data Governance is ensuring that business rules are accurately reflected in your processes, reports, queries and spreadsheet formulae. A critical element is anticipation of the strange things that might happen that would cause false positives and...
