by Oz du Soleil | Jul 19, 2012 | News
Exciting news! Just launched the announcement of 2 Excel Training sessions. They aren’t available to the public but this could be the opening of such a possibility.
by Oz du Soleil | Jul 11, 2012 | Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips
So, a client delivers a lot of data to me. They need it scrubbed or, reorganized or, an application built around their to automate tasks … or some combination of the three. Guess what? Most projects involve something that I don’t know how to do (yet). And...
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 19, 2012 | Case Studies
Recently, I posted details about the challenges the client was facing, and how we arrived at a solution. Below is a screencast demo of the final product showing the Excel form, the data collection and Birthday tickler. See the blog: Excel User Form & Birthday...
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...
