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

4 Ways To Avoid Krampus & Crap Data in 2013

by Oz du Soleil | Dec 29, 2012 | Data Integrity, Data Management, Spreadsheet Development, Spreadsheet Tidiness

Krampus torments a business owner who ran a business on crap data in 2012 high bounce rates on e-newsletters vital data sprinkled across multiple sources commission payments were wrong mail sent to out-of-state clients for local events unable to follow-up with major...

Pivot Tables: You’ve heard of ’em but, so what?

by Oz du Soleil | Sep 4, 2012 | Data Integrity, Data Management, Excel Geekdom, Spreadsheet Tidiness

What Are Pivot Tables Used For? What Are Pivot Tables Good For?   Many of you have heard of Pivot Tables and aren’t sure what they are. I’ll leave you to Google how to mechanically get one working but if you’re like me, teaching the mechanics...

Taming Dataville: Data Generators & Bogus Data

by Oz du Soleil | Jul 11, 2012 | Data Management, Excel Geekdom, Spreadsheet Tidiness, Tips

So, a client delivers a lot of data to me. They need it scrubbed or, reorganized or, an application built around their to automate tasks … or some combination of the three. Guess what? Most projects involve something that I don’t know how to do (yet). And...

The Seven Deadly Sins of Data Entry (or how NOT to use Excel)

by Oz du Soleil | Jul 3, 2012 | Data Integrity, Excel Geekdom, Guest Blogger, Spreadsheet Development, Spreadsheet Tidiness, Tips

This post will describe bad habits in Excel to do with cell formatting and formulas and how to avoid them. If you share spreadsheets in a team, the data will only be as strong as the weakest link in the team. For the first time ever, a Guest Blogpost on DataScopic.net...

Screencast #2: Excel User Form & Birthday Notification

by Oz du Soleil | Jun 18, 2012 | Case Studies, Data Integrity, Excel Geekdom, Screencast, Spreadsheet Tidiness, Tips

This project has a lot of pieces and resulted in something fun and challenging for me but also something quite valuable for the client. A key piece in the success was an Excel User form. Here’s a photo of me in actual battle with the Exceltopus that we roused...

Troubleshooting Complicated Formulae

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