I call VLOOKUP the "duct tape of Excel" because it can mend and join practically any sets of data.Introductory Slideshare:Here are a few of my top posts on VLOOKUP:Why Vlookup?Vlookup: the …
Hired with Excel: The Essential Guide to Interviews
I am currently working on a new course entitled, "Hired with Excel: The Essential Guide to Interviews."This is meant to serve as a companion course to "Hired with Excel: What Every Analyst Needs to …
Continue Reading about Hired with Excel: The Essential Guide to Interviews →
Setting cells to phone number format in Excel
I don't know about you, but I'm always impressed when I'm filling out a contact form online, enter in my phone number 5551238776 and see it transformed to (555) 123-8776.It's not much, but it shows …
Continue Reading about Setting cells to phone number format in Excel →
How learning Excel can make you happier (slides)
Cool, wet, grass. A pitcher of sweet tea. And a big ol' spreadsheet. Which is unlike the others?It's probably not the first thing you think when happiness comes to mind, but I believe learning Excel …
Continue Reading about How learning Excel can make you happier (slides) →
Will Not Learning Excel Leave You Homeless?
My favorite blog has to be Seth Godin's. I love that he can write something concise and meaningful every day about topics ranging from pricing strategy to digital entrepreneurship.Today Seth launched …
Continue Reading about Will Not Learning Excel Leave You Homeless? →
Data Illiterates and the Glenn Gould of Excel
I just finished reading Data Fluency: Empowering Your Organization with Effective Data Communication by Zach and Chris Gemignani.Of all people, this book got me thinking of Glenn Gould. Yes, the …
Continue Reading about Data Illiterates and the Glenn Gould of Excel →