This post is part of a series on one of Excel's best functions, VLOOKUP. Check out the entire series here. Then, subscribe to my newsletter for the latest. Vlookup is the duct tape of Excel Go back …
Hired with Excel: The Pareto Handyman
This is part of the "Hired with Excel" series. Read the previous posts on the good and the bad in Excel.This series will give you actionable tips on the two most commonly used Excel tools. …
Continue Reading about Hired with Excel: The Pareto Handyman →
Hired with Excel: The Bad
This will be you as an analyst -- headphones on, baffled by some spreadsheet your coworker just sent.This post is part of the Hired with Excel series. Read the previous post on the advantages of Excel …
Hired with Excel: Why Excel?
This is part of the "Hired with Excel" series. Read the previous post here. Business is all about solving other people’s problems. As an analyst, you want to solve your boss’s problems by …
Hired with Excel: Why You Must Train Yourself
This is part of the "Hired with Excel" blog. Read the last post here. I have drilled home the point that you cannot rely on your employer to train you. I want to elaborate on this point a little more …
Continue Reading about Hired with Excel: Why You Must Train Yourself →
How to learn Excel from scratch
You’ve found the perfect job. Only one problem: you need to know Excel. It’s in the job description. And you know the hiring manager is going to ask you about it -- or worse yet, test you on …