Oz du Soleil
  • About
  • Tutorials
  • Blog
  • Contact
Select Page

Big Data, Schmig Data. How ‘Bout Some Perspective?

by Oz du Soleil | Nov 22, 2013 | Case Studies, Data Management, Data Management for Nonprofits

Last night I taught the 3rd of a 3-session private workshop in a nonprofit organization. The initial conversation was from the nonprofit’s IT Director, Margo, who requested, “We’re upgrading to Excel 2013 and would like someone to come in and show us...

5 Reasons For Building Apps in Excel

by Oz du Soleil | Aug 23, 2013 | Case Studies, Data Management, Excel Geekdom

Yes yes! This is the spicy part of Excel, right here. Somebody’s out there in the world with an idea or a need for an app that will make them richer, more accurate, happier, smarter or all of those. In many instances an app is as close as a search in Bing,...

Seeing Data Can Be More Helpful Than The Calculations

by Oz du Soleil | Aug 21, 2013 | Case Studies, Data Management

Following is an example of how graphing was a critical part of getting to the bottom of a minor crisis. An agreement had been made based on numerical data and monthly averages. However, in the 3rd month of the agreement the numbers were bizarre and far outside of any...

ExcelWebApp & Sriracha Smackdown Round 2

by Oz du Soleil | Jul 10, 2013 | Case Studies, Data Management, Excel Geekdom

Rachel Esralew and I are leading Sriracha Smackdown Round II: The True Sensation. This will be a Google Hangout where many of us will sample and rate the joyful joy of various brands of sriracha. ♦♦ One night I stumbled across Rachel’s...

Nonprofit Fundraising: Tracking the Details

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...

Nonprofit Data Management & Empowerment

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...
« Older Entries
Next Entries »
Best Microsoft Excel Bloggers

Recent Posts

  • Learning Excel By Building
  • Beyond BI Tools: The Real Life Impact
  • More Excel Videos in 2016

Blog Categories

  • Being a Good Analyst
  • Case Studies
  • Data Integrity
  • Data Management
  • Data Management for Nonprofits
  • Excel Geekdom
  • Excel Management
  • Guest Blogger
  • How Tos and Q&As
  • News
  • Screencast
  • Spreadsheet Development
  • Spreadsheet Tidiness
  • Tips

DataScopic.net

DataScopic is committed to Excel as a tool in service of Data Literacy: competence in collecting, manipulating, interpreting and auditing data. Oz du Soleil provides clients with more than 15 years of expertise to solve their data challenges.

Search

  • About
  • Tutorials
  • Blog
  • Contact
  • Facebook
  • X
  • RSS
Privacy Policy