by Oz du Soleil | Feb 4, 2016 | Excel Management
Every day someone new is thrown into a data-driven/Excel situation and they don’t know where to start. So, they flail, panic, curse, pray and beg, and either figure it out or they don’t figure it out. I wondered, “what might a better...
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 31, 2016 | Excel Management
As we move forward in 2016 you will see a lot more video from me and fewer long-form blogposts. As 2015 closed there was a stretch where I’d uploaded 5 videos over 2 weeks. That level of production has never happened over the 5-ish years of this blog. One thing...
by Oz du Soleil | Jan 31, 2016 | Data Integrity
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...
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...