Excel Book Author Oz du Soleil – Excel Expert Interviews

This episode’s special guest is an Excel expert, consultant, blogger and book author. Yes, our very own Oz du Soleil. He discusses the progress on a book he’s writing on Excel and his upcoming online show on Excel.

So, let’s get to it!

1 – Full Contact Data Management

You guessed it right! His new book is named “Full Contact Data Management: Excel Methods for Exposing, Handling and Preventing Bad Data”. Business decisions mainly rely on simple analysis of data, yet we see disruptions and bad decisions are not as uncommon as they should be. This is almost entirely attributable to bad data! The central idea in this book is therefore on integrating Excel with various business processes to control company data. It is about getting more out of Excel and looking at everything that working with data entails.

2 – Outsourcing

Oz wanted to show the ‘true picture’ of various processes around obtaining data and deriving output from it. But such an endeavor comes with a challenge of depicting the nasty, real world side of things in an aesthetically pleasing way. Hence, he turned to Indiegogo to hire a professional illustrator for the task.

The criteria Oz used is something worth discussing. With the pressure of writing a manuscript, he did not want to deal with additional frustration of project management. So, he needed someone who would take charge of the work and make life easy for him. For example, Oz shouldn’t have to worry about giving ideas for illustration with are not consistent with previous work done for the book. The freelancer should be keeping track of that. Sometimes you don’t need someone you will have to micromanage to get things done.

3 – Excel TV Show

Oz described his professional work as something which has always revolved around small businesses and non-finance or non-enterprise people. Unsurprisingly, some of these hated Excel but could not get away from it. His vision for the show is to bring out ‘Excel in the wild’ to its audience, to show how people are deploying this great tool to run businesses, deliver services or do something unusual.

He gave example of a rapper who uses spreadsheets, and what he calls a bar chart, to write lyrics and ensure the rhyming scheme is as he wants. Another example Oz mentioned was around choosing a massager by comparing various products across five dimensions like power and cost, where the decision-maker can rank dimensions according to his or her preferences.

What’s next?

Leave your thoughts in the comments section below. And do not forget to share this with other Excel enthusiasts and experts.

Jamani Arsalan


You may also like

August 5, 2014

14: Jon Acampora, Excel MVP
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.