by Oz du Soleil | Jan 20, 2015 | Data Management
Last year I wrote a blogpost describing Excel as the Dennis Rodman of business intelligence tools. In the blogpost I described events where data management and data scientists got together, and Excel skill was welcomed in a very odd way. Like the NBA player, Hall of...
by Oz du Soleil | Jul 10, 2014 | Data Management
On Episode 12 of Excel TV I said a little about a trainee who started crying as I was teaching her the details of her new job. This story comes up in conversations around the challenges of working with data. This particular challenge was a complete data...
by Oz du Soleil | Feb 3, 2013 | Excel Geekdom, Spreadsheet Development
I’m going to clean up a mess I started. I’ve complained about Excel not being easy to integrate into the internet or replicate its complete functionality in the almighty cloud. As I research further it’s clear that bringing anything into the cloud is...
by Oz du Soleil | Nov 24, 2012 | How Tos and Q&As
The Excel IF function is like a nice pair of black shoes: they’re fundamental and fly under the radar. When asked about a list of Top Excel Formulas, I immediately thought of the almighty VLOOKUP. But Wait! My #1 is IF and #2 is VLOOKUP. IF is fundamental like...
by Oz du Soleil | Nov 12, 2012 | How Tos and Q&As
QUESTION Brother Henning asked about the relationship between bass playing and Excel skill. Part of the answer is in a previous blogpost where I surmise that there’s a relationship between Data Managers and people who play bass and drums. There’s a mindset...
