Warning: mysql_real_escape_string(): Access denied for user 'dragon99'@'localhost' (using password: NO) in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152

Warning: mysql_real_escape_string(): A link to the server could not be established in /home3/dragon99/public_html/wp-content/plugins/easy-contact-forms/easy-contact-forms-database.php on line 152
Excel Archives - Oz du Soleil
R, Excel and Data in the PDX

R, Excel and Data in the PDX

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

What Made My Trainee Cry?

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

#1 of the Top 5 Functions: Excel IF Function

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

Excel, Music and Songwriting

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