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

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

Real Data Management Is Managing People Who Don’t Like The Results

by Oz du Soleil | Aug 13, 2013 | Data Management

Once again, let’s get out of the spreadsheet and discuss other things that we need to manage this world with reliable data. Today, we look at what it takes to fully own a data-driven role. Many of us are shocked when we take on a new position and discover how...

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

Wear Your Underwear Over Your Pants! Create Excel Data Models

by Oz du Soleil | Jul 5, 2013 | Data Management, Excel Geekdom

WARNING: Excel 2013 Content Ahead Chandoo, the Excel Master of Excel Masters and is a blessing for many of us in the Excel world. His humor and Excel knowledge keep us Excel geeks on top of our game. Today, I borrow from both his humor and his reminder of an Excel...

Excel Tip of the Month: Close the Frikken Spreadsheet

by Oz du Soleil | Jun 21, 2013 | Data Management, Excel Geekdom, Tips

Let’s add this to an earlier post about the 6 Quiet Habits for Working with Excel & Data. In that post I listed several best practices that won’t ever end up in a “Make Excel Your Friend” manual. Yet, they are just as helpful as a nested IF...
« 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