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

Spreadsheet Manipulation: Inserting Rows in a Pattern

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...
What is a Data Hygienist?

What is a Data Hygienist?

by Oz du Soleil | Apr 17, 2012 | Data Integrity, Excel Geekdom, Spreadsheet Tidiness

Think about that person who comes in before the dentist? They look around, take x-rays, and get everything clean and set up for the dentist. In some ways a Data Hygienist is similar: come in before the Analyst; before the Accountant, before the Database Architect;...

Good News/Bad News: Converting PDF to Excel Format

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

COUNTIF you have errors

by Oz du Soleil | Feb 23, 2012 | Data Integrity, Spreadsheet Development, Spreadsheet Tidiness, Tips

Let’s say you have 600 rows of data and you’re looking at a final number from column W telling you that you are owed a total of $17,384. Can you trust it? Suggestion: Create a formula that looks for any cells in column W that show the error: #NA....

Hide all of those Zeros that are cluttering your spreadsheet

by Oz du Soleil | Feb 22, 2012 | Excel Geekdom, Spreadsheet Development, Spreadsheet Tidiness, Tips

A handy feature in Excel: hide formulas that result in 0. You’ve set up a spreadsheet in anticipation of the future. All of the formulas are in place and the vast majority = 0. Of course they do. It’s only February. None of your product lines have sales...
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