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 …
New Course — Hired with Excel: The Essential Guide to Interviews
Course DescriptionSo you found the dream job. Only one problem -- it requires proficiency in Microsoft Excel. What to do?This course is a gameplan for learning Excel -- and acing your job interview …
Continue Reading about New Course — Hired with Excel: The Essential Guide to Interviews →
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 →