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 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 | Jun 10, 2012 | Excel Geekdom, Screencast, Tips
This was inspired by a friend who asked about automatically populating a range by dragging the formula–based on numbers at the top and along the left side of the range. It’s a bit of a logic puzzle in using relative/absolute cell references, and...
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...
by Oz du Soleil | May 21, 2012 | Excel Geekdom, Spreadsheet Development, Tips
Have you worked with a complex, long, and/or detailed formula, Excel keeps returning #N/A or #NAME and it’s making you crazy? Excel does have a Formula Troubleshooter but it’s not so user-friendly. So, how do you troubleshoot formulae without going...
