Here's a nice keyboard shortcut I recently picked up. …
Continue Reading about Keyboard Shortcut: Rename Worksheet in Excel →
The “Hired with Excel” Resource Page
Data-savvy analysts are in demand. Want to get started? Learn Excel. This series of posts is everything I wish I knew when applying for my first analyst job. Focusing on two commonly used Excel tools, …
Continue Reading about The “Hired with Excel” Resource Page →
Hired with Excel: You’re Hired! Now What?
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? →
Why PivotTables?
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 …
Anchors Away! A Better VLOOKUP
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 …
#VlookupProblems: Cells Formatted as Text
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 →