Teaching analytics with modern Excel
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 →
You’re Finally Hired....Congratulations!Now what?First of all, know that with these skills you are going to impress your boss. Your coworkers will appreciate you, too. Good spreadsheet analysts are …
Continue Reading about Hired with Excel: You’re Hired! Now What? →
If you follow my blog, you'll know I write a lot about data analysis, Microsoft Excel, and other related topics. It's my goal to catalog everything I've learned as an analyst over the past few …
Continue Reading about No More Blast Invites! LinkedIn for Aspiring Analysts →
You probably didn’t expect etymology in this book, but it here goes. When I probably should have been learning Excel in high school, I took a Greek class instead.I haven’t used my Greek a lot, but one …
There is nothing wrong with the average vlookup. But do you really want to be average? The coveted analyst needs exceptional Excel skills. How can we make Vlookup even more accurate and …
This is a common problem that interns and coworkers often approach me with."Can you take a look at my vlookup? I'm doing everything right but getting errors."The culprit: incorrectly formatted …
Continue Reading about #VlookupProblems: Cells Formatted as Text →
