It’s a common scenario. You’re looking for your first job out of school. Or, you want to move up the ranks at work. Regardless — those mysterious words appear on the description for your dream job — “Requires proficiency in Microsoft Excel.”
Subscribe to the newsletter for my “Beginner’s Guide to Getting Hired with Excel,” yours free.
What the heck does that mean?
Data analysis is becoming the engine of business, and Microsoft Excel is the starting-point. You want to show your employer you’re comfortable with data, and demonstrating solid Excel proficiency is a great start.
“But how do I learn Excel?”
Well, I am glad that you asked…
First off, focus in on what you really need to learn in Excel. You will not learn everything. Excel is too vast. That’s why my course focuses on two functions alone — it’s based on what I saw were the most lacking Excel skills for most new analysts.
“But what do I need to know?”
Everyone’s got an opinion here! A few favorites:
At Chandoo.org, “Top 10 Formulas for Aspiring Analysts”
PoliceAnalyst.com on “30 Excel Functions Every Analyst Should Know”
Exceldemy.com on the “Top 20 Advanced Essential Excel Skills You Should Know”
“Okay, where do I go for those?”
So, you are getting a sense of what you need to learn as an analyst. Well, where should you train?
Check out my guide on learning Excel from scratch for training ideas that fit every schedule and budget.
Please also peruse my own Excel blog page!
So, you are feeling confident with your command of Excel. It’s time to start sending resumes and interviewing. How can you put your best foot forward as an Excel-savvy analyst?
A few links and tips:
Other resources from around the web:
At Chandoo.org, “What are the Best Excel Interview Questions?”
DeskBright has an excellent guide to the “Top 10 Excel Interview Questions for Job Seekers”
And some thoughts from Oz du Soleil:
From CareerGuru.com, the “Top 25 Microsoft Excel Interview Questions & Answers”
At ListenData.com, some “Data Analyst Interview Questions”
Looking for a job in marketing? SEO is a critical skill. This guide from Acuity Training will get you ready for an interview in SEO with its Search Engine Optimisers Guide to Excel.