VBA: Leveraging VBA to Work with Charts, Stocks, & MS Access

Seeing “proficient in Microsoft Excel” listed on a job description can be confusing, even if you regularly use the Microsoft spreadsheet software. Considering the vast uses for Excel, how can you tell if you’re truly “proficient” enough to be considered for a role?

For starters, read the job description closely. If Excel proficiency is listed as a “required” technical skill, then it’s safe to assume it’s an Excel-heavy role with little room to fake it or learn on the job. But if the job description categorizes it as a “preferred” or “desired” skill, then you might be more qualified than you think.

“What it means to be ‘proficient’ is going to depend on what you need to use Excel for,” explains Ada Morse, Associate Curriculum Developer at Codecademy. For example, a Business Intelligence (B.I.) Analyst might rely on Excel to manage budgets and financial forecasts, while a project manager might use it to build an organized schedule or calendar.

The beauty of Excel is that it’s a powerful but flexible program with tons of potential use cases. “Like with a lot of programming languages, there’s thousands and thousands of functions in Excel for different things — and no one’s going to know them all,” Ada says.

Our course Learn Microsoft Excel for Data Analysis will teach you some key Excel functions, like how to import and manipulate data and create visualizations, so you can confidently claim proficiency. If you’re heading into a job interview or wondering if you have what it takes to apply to a position that involves Excel, here’s what you need to know.