by Oz du Soleil | Feb 2, 2016 | Being a Good Analyst
One night I was up late, thinking about Excel, data and the many conversations around the different tools that we use to get our data to tell us something useful. But I was reminded of many years ago and why I have remained so passionate about data: it’s the...
by Oz du Soleil | Jan 10, 2016 | Being a Good Analyst, Excel Management
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...
by Oz du Soleil | Jan 10, 2016 | Being a Good Analyst
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...
by Oz du Soleil | Aug 23, 2015 | Being a Good Analyst, Data Integrity, Data Management, Excel Geekdom
The PASS Business Analytics Conference 2015 was April 20 to 22 and it was an honor to be a speaker, sharing knowledge and getting to know people in the Business Intelligence realm who are outside of Excel. PASS is primarily a SQL community but they recently started to...
by Oz du Soleil | Aug 6, 2015 | Being a Good Analyst, Data Integrity, Excel Geekdom
As we develop tools in Excel, it’s nice to be at a place where everything is automated. One change in a cell cascades through the spreadsheet and updates everything that’s impacted by the single change. However, there are times when we need to override a...
by Oz du Soleil | May 31, 2015 | Being a Good Analyst, Data Integrity, Data Management for Nonprofits
I found this blog a few months ago: NonProfit With Balls (NWB). The blogger is Vu Le and this guy loves data as much as I do. He says that if data were syrup, he’d put it on his soy ice cream. If you know me, I’d say that capsaicin is the edible form of...
