OzLive Action HatDataScopic is dedicated to Data Management and Excel as a tool for helping you get what you need from your data.
  • Oz is a business intelligence consultant, trainer and developer specializing in Excel solutions.
  • He's leading author on the revised version of Guerrilla Data Analysis, a book originally written by Mr. Excel, Bill Jelen in 2002. Version 2 will be available in Spring 2015.
  • Co-host of ExcelTV along with Rick Grantham and Jordan Goldmeier.

If you would like Excel training for your team (on site or online) or personal tutoring, click here or call: 773-746-5405.

New Book, co-authored with Mr Excel

GDA Cover

Courses That Can Be Delivered To Your Team At Your Location Or Online

pivot tables 3 features formulas nonprofits input controls
DataScopic Blog
5 Most Recent Blogposts
 

The Anti-VLOOKUP Crowd Is Out In The Streets Again!

The Anti-VLOOKUP Crowd Is Out In The Streets Again!

Today we explore this ongoing debate over VLOOKUP vs. INDEX/MATCH. I say it’s a false dichotomy and unnecessary confusion.

The Pinocchio Theory & 3 Basics Where Excel Whoops Google

The Pinocchio Theory & 3 Basics Where Excel Whoops Google

THE PINOCCHIO THEORY In 1977 Bootsy Collins released the hit song Pinocchio Theory. Its main […]

5 Suggestions for: “HELP! Teach Me Excel”

5 Suggestions for: "HELP! Teach Me Excel"

“Teach me Excel” is a hard request to satisfy. Here is why and 5 suggestion on how to get started learning Excel.

Excel, Christmas, Krampus & Kids

Excel, Christmas, Krampus & Kids

Mynda Treacy’s recent blogpost at MyOnlineTrainingHub is a hot one! Excel Custom Validation to Limit Entries poses […]

Getting to the Sexy Data

Getting to the Sexy Data

We all want to get to the sexy data and none of us are immune to the pain of cleaning data before it’s useful. Today we look deeper into this problem.

Follow

Get every new post delivered to your Inbox

Join other followers: