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 | 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 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 | Oct 2, 2015 | Excel Management
I was up at 1am today surfing YouTube and came across a How To Rap channel by ColeMizeStudios. Some of what I saw made me shout out loud because Cole Mize (pictured on the right) is a reminder that EVERYTHING IS DATA! Everything. Cole Mize brilliantly takes music and...
by Oz du Soleil | Sep 23, 2012 | Excel Management
QUESTION Keely is trying to merge 2 lists and the Excel date format is different between the 2 lists. List 1: Date and Time in one cell 3/14/2011 11:20 AM List 2: Date only 3/14/2011 What’s the deal? ANSWER We can solve this formatting...
