After years of experience as an analyst, I am developing my own Microsoft Excel training course. This is everything I wish I’d known out of school. I’ve put in my 10,000 hours of practice and am distilling this knowledge into an online course.
Interested? Join my email list and be the first to know of updates. Here’s a course preview. Details subject to change.
Hired with Excel: What Every Analyst Needs to Know
How to get a great-paying job with Microsoft Excel
Highlights of this course:
In-depth coverage of the two Excel concepts every analyst needs to know
Focus on both Excel skills and professional development
Over two hours of video training
Why get hired with Excel?
Excel is an essential skill for today’s professional, no matter what industry or role.
Be truly great at Excel and you will never go unemployed.
McKinsey has estimated that the U.S. workplace alone faces a shortage of 1.5 million analysts and managers with the knowledge to use data in business decisions.
If you want to get more comfortable working with data, Microsoft Excel is the best place to start. Its use is universal across companies and industries. And its data analysis tools are powerful.
But if you have great Excel skills and nobody knows, do you really have great Excel skills?
In this course, I won’t just show teach you the most important features of Excel for analysts. I will show you how to turn these skills into a great job.
First I will cover what analysts do and why it’s never been better to work with data. I’ll also cover the important role of Excel in business analytics.
Then I will cover two specific Excel features: VLOOKUP and PivotTables. I call these the duct tape and WD-40 of Excel. You can fix a majority of problems with these two tools.
I will go in-depth with these tools, showing you how to make the most of these functions, and helping you avoid common problems.
Then I will show you how to turn these Excel skills into better career prospects. I will show you how to find the right job. We’ll go over how to stand out from the hundreds of other job applications.
I’ll also show you how to ace your interview and sound like a real analyst.
This course will equip you with the most important Excel features and help you turn them into a great job.
Who should try this course?
This course is best for
– Recent grads looking for their first job in a data-heavy position, such as financial analyst
– Current workers who want to improve their Excel skills and career
– Career counselors and teachers who want to equip current students to work with data
– Senior managers who want a better understanding of business analysis in Excel
There will be five lessons to the course.
Lesson 1 – Introduction
In the first lesson, I will define what it means to be an analyst and why learning Excel helps.
Lesson 2 – Vlookup: the Duct Tape of Excel
VLOOKUP is one of Excel’s most powerful tools, allowing you to merge sets of data — much like a roll of duct tape! We will cover VLOOKUP, related functions, and tips and tricks to make the most of this tool.
Lesson 3 – PivotTables: the WD-40 of Excel.
Another analyst favorite, PivotTables allow you to “slice and dice” your data. It gets your data flowing like a shot of WD-40 to rusty bearings! I will show you the PivotTable tricks I’ve acquired over years of experience.
Lesson 4 – Join the Vlookup Culture
This mastery of Vlookup and PivotTables puts you ahead of the majority of analysts already. But what’s the point of knowing Excel if it can’t help you at work? In this lesson, I will show you the best ways to search for Excel-heavy jobs. We’ll also cover how to interview like an Excel geek. This is your VIP pass to the Vlookup Culture.
Lesson 5 – Conclusion
You’re an Excel genius — now what? In this lesson we will cover how to keep your Excel skills sharp and stay the best analyst in a rapidly changing workforce.
I hope to see you in class!