by Oz du Soleil | Jun 7, 2013 | Data Integrity, Data Management, Excel Geekdom
I’m getting ready to teach a 2-session workshop on parsing data in Excel. As with other courses, before I teach them for the first time, I have to clarify the mindset to decide who would get the most from the course. Scrubbing data, reorganizing columns, peeling...
by Oz du Soleil | Nov 9, 2012 | How Tos and Q&As
QUESTION Here’s an example an example of Data Parsing in Excel. Phil sent in this challenge. He receives a report and it’s not useful the way it is. Often, these reports are generated for an executive to read. That same report gets turned over to an...
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...