by Oz du Soleil | May 1, 2012 | Case Studies, Data Integrity, Data Management, Tips
Who’s the Data Boss? Anyone? As a Data Mercenary, I’ve seen a lot. One thing that has regularly come up: disconnects in Data Governance which result in a lot of people feeling pain within and outside of the business, and confusion about who’s...
by Oz du Soleil | Apr 30, 2012 | Excel Geekdom, Spreadsheet Tidiness, Tips
Have you written a complex formula or had to understand a long formula that someone else wrote? It can become a jungle of parentheses and commas. One simple tip: Use ALT+ENTER in the Formula Bar to Make Troubleshooting and Validation easier Here’s a...
by Oz du Soleil | Apr 21, 2012 | Case Studies, Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness, Tips
The following isn’t meant to be a “how-to.” This is designed to quickly show how we got over a challenge faced by a client who didn’t think that there was a simple solution. Have a look. Maybe this will inspire you to think about ways that your...
by Oz du Soleil | Apr 17, 2012 | Case Studies, Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips
Converting PDF to Excel. OMG! Several of my clients have needed critical information that was locked in a PDF file. Maybe they wanted to sort thousands of entries by zip code, # of employees, square-footage or by industry. No-can-do in a PDF! There are lots of PDF to...
by Oz du Soleil | Apr 17, 2012 | Data Management, Tips
Crap data is costing you money. Crap data is keeping you from making money. Your needs don’t call for a pre-packaged system with more bells and whistles than you need. Your needs don’t call for an expensive pre-packaged system with more bells and whistles...
by Oz du Soleil | Apr 17, 2012 | Excel Geekdom, Tips
{=sum(- -(b8:b550 < f8:f550))} One more thing I’ll whoop on ya today: Excel’s spooky little double-negative. S’pose you want to know the number of times something was true, and then do math with it COUNTIF won’t help because...
