by Oz du Soleil | Jan 4, 2015 | Spreadsheet Development, Spreadsheet Tidiness
My friend Mike asked, “is Excel for the common man?” The answer is yes, but I had to find a good example for someone who’s recently retired and has no workplace need for Excel. But, wherever there’s data, there’s opportunity to use Excel....
by Oz du Soleil | Oct 28, 2014 | Data Management, Excel Geekdom
THE PINOCCHIO THEORY In 1977 Bootsy Collins released the hit song Pinocchio Theory. Its main warning is: If you fake the funk, your nose will grow There are a lot of long noses in the data world–specifically with folks who continually bash Excel and write its...
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...
by Oz du Soleil | Oct 9, 2012 | Data Management, Excel Geekdom
UPDATE (2DEC13): ExcelWebApp continues to improve. They’ve added key validation features that didn’t exist when I originally published this blogpost in October 2012. See: App Development in Excel and Break-Even Calculator ♦♦♦ This was an unplanned blog...
by Oz du Soleil | Oct 2, 2012 | Excel Geekdom, Spreadsheet Development
Live Data For Your Exploration of Excel Interactive View Hop in and Let’s Go! The table below is random Data for 66 people whom I created with a Data Generator to display Excel Interactive View (click here for Excel Interactive View Part 1). With Excel...