by Oz du Soleil | Jul 18, 2013 | Excel Geekdom
Microsoft Excel 2013 itself has such an awesome collection of built-in tools and features that it has beyond any doubt, become one of the most useful tools for so many things. Today’s blogpost by Ryan Dube, 3 Crazy Excel Formulas That Do Amazing Things Microsoft...
by Oz du Soleil | May 17, 2013 | Data Management, Spreadsheet Development, Tips
There are no fancy Excel stunts here. These are 6 simple pointers that escape the Excel tutorials. Like anything that’s done well, there are personal habits that quietly develop to keep you focused or avoid traps. I wasn’t aware of my own habits until I...
by Oz du Soleil | Apr 5, 2013 | Data Integrity, Data Management
Data Cleansing (Data Scrubbing) the process of amending or removing data that is incorrect, incomplete, improperly formatted, or duplicated. WARNINGÂ Hold on to your hat. This can get ugly. The cost of cleaning data is tough to get at. I used to charge $150 to...