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 | 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 | May 1, 2013 | Data Management, Excel Geekdom
2 years ago I was converting my life over to Apple. Their users boast of the Mac processing speed and resistance to malware. I’d spent enough time and money cleaning up my PCs in spite of the firewalls, ad-blockers, malware detectors, and other counter-measures....
by Oz du Soleil | Apr 29, 2013 | Case Studies, Data Management, Data Management for Nonprofits, Spreadsheet Development
NONPROFIT FUNDRAISING: PART 2 In my previous blogpost, Nonprofit Fundraising: The Cost of $1, we looked at a fundraising campaign that generated $2026.02 after laying out $1099 in expenses for a net gain of $927.02; and we determined that it cost 54¢ to raise every...
by Oz du Soleil | Apr 26, 2013 | Data Management, Data Management for Nonprofits, Spreadsheet Development, Tips
Nonprofits, by their definition, are primarily funded by the public. That means they’re always fundraising. It helps a nonprofit to know: How much did it cost to raise $1? Nonprofit fundraising can get complex, time-consuming and expensive, sometimes...
by Oz du Soleil | Apr 16, 2013 | Case Studies, Data Integrity, Data Management, Data Management for Nonprofits
Steve, the nonprofit Volunteer Coordinator, has a meeting with the Executive Director and a major donor in 3 hours, and Steve needs data! The canned reports in the cloud-based CRM aren’t formatted for details on volunteers, but Steve believes he can manually...
