Excel and Data Literacy

DataScopic provides data management, data literacy, workshops and tutoring on maximizing Excel and improving data integrity.   MVP_Logo_Horizontal_Secondary_Blue286_RGB_300ppi

DataScopic’s Focus & Commitment

speaking at IgniteChicago Available for workshops and one-on-one tutoring, Oz du Soleil can help you become more data competent and leverage the power of Excel. As one of 30 Excel MVPs in the U.S., his expertise and knowledge will help you maximize your data.

[maxbutton id=”9″]

legos_thumb.jpg Maximize your data by ensuring it has been acquired, validated, stored, protected and processed correctly in order for it to be accessible, reliable and timely to satisfy your needs.

[maxbutton id=”10″]

Adding Clarity To Your Business Data Hone your ability to read, create and communicate data as information and leverage it in your business.

[maxbutton id=”12″]

My Book Is Now Available

Guerrilla Data Analysis Using Microsoft Excel

Recent Posts

Beware the Octopus Spreadsheet

Beware the Octopus Spreadsheet

So many spreadsheets require basic math, but poor layout makes a spreadsheet unnecessarily complicated and brittle. They don't need sophisticated dashboards, forecasts, statistical analysis, or connections to a database. They just need to perform basic tasks like:...

read more
Intersection Operator and the Good Enough Solution

Intersection Operator and the Good Enough Solution

This video has several layers. The ultimate goal is to create a table of summaries from a dataset that has granular data. One layer is the creation of the named ranges. You'll see that I set up the named ranges and didn't remove the blank rows or do anything to clean...

read more
Why Am I So Passionate About Data & Excel?

Why Am I So Passionate About Data & Excel?

In this video I share my true motivation for working with Excel. The bottom line is: keep Doreen happy. This is reminder that whatever we do with Excel and data, it's all in service to something. There's more than tips and tricks. There are people who have to live...

read more

Your Excel Questions Answered

ask questions Have a burning data or Excel question? Discover tricks, tips, tutorials and more through this Question and Answer archive.

What does it cost to clean my data?
aeneas & cerberusDetermining the depends on a number of factors, including the amount of data, how organized the data is, the number of data sources and, of course, budget. Read more

What are the top 5 Excel functions to know?
SUMIFS the 5th of the Top 5 Excel Functions to KnowThese functions will give you serious mileage in building Excel formulas and allow you the read formulas that someone else built. Read more

How can you data parse in excel, turning a report into useful data?
PhilsMazeLearn how you get from a “report” to a sortable list using these Excel tips. Read more

Videos

Watch select videos about data management and Excel expertise from Oz du Soleil, and check out the YouTube Channel for more.

Contact Oz du Soleil

Would you like to discuss a solution or do you have a simple question?