by Oz du Soleil | Jul 21, 2012 | Data Management, Excel Geekdom
With the first glimpses of Excel 2013 (as part of Office 15) being released & reviewed it’s a good time to address two prognostications about Excel’s future. 1. EXCEL IS DEAD, IT HAS NO FUTURE I was on a conference call recently and the premise...
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 8, 2012 | Data Management, Excel Geekdom
If we were to take a poll of people who are both good at Data Management, and are musicians I bet we’d find an unusually high number of bassists and drummers. Why? Any good band must have a solid rhythm section Any good business must have solid Data...
