One common question I'm asked is how to download Excel -- and, just as important, how much will it cost?Good news: you can get Excel for free!Microsoft has done a good job at making Office more …
The Guide to PivotTables
I call PivotTables the “WD-40 of Excel” because they allow you to loosen up and extract meaning and trends out of your data.Introductory SlideShare:Here are a few of my top posts …
The Guide to VLOOKUP
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) →