Slideshare: “VLOOKUP: The Duct Tape of Excel”

Here is an introductory Slideshare to my Guide to VLOOKUP. It’s one thing to know the mechanics, another to understand WHY we need to know it. VLOOKUP’s importance lies in the disperse nature of data.  Rarely does it come pre-packaged, for as much of a push as there is for “data warehouses” and “data lakes.” […]

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 Mechanics An even better Vlookup: IFERROR #Vlookupproblems: The Zoolander Problem #VlookupProblems: Cells Formatted as Text A Better Vlookup: Anchored […]

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, the series covers what analysts do to why many use Excel to how to find a job.  Let me know […]

Vlookup Culture: Lingo for Aspiring Analysts

    This is a preview of my course, “Hired with Excel: What Every Analyst Needs to Know.” Get started here. 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 […]

No More Blast Invites! LinkedIn for Aspiring Analysts

  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 years to help those looking to move into a data-driven position. If you’ve got chops and nobody knows, do you […]