Learning Excel By Building

Learning Excel By Building

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...
More Excel Videos in 2016

More Excel Videos in 2016

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...
Excel, Rap, Music Education and Cole Mize

Excel, Rap, Music Education and Cole Mize

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

Excel Date Format is Inconsistent

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 issue by just going...