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
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.
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.
In the first lesson, I will define what it means to be an analyst and why learning Excel helps.
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.
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.
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.
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.
Disclaimer: This course is presented for information purposes only. Not all individual situations are the same and individual results will vary. Thus no guarantees can be made.
Microsoft Excel is a registered trademark of Microsoft Corporation.
I believe this is the best course on Excel for job seekers on the market. But if you are not satisfied with the product, I will gladly offer a refund within 30 days of purchase. Please contact me at email@example.com for more information.
Armed with a liberal arts degree and a master’s from a leading business school, I set out into the world to become an amazing analyst.
Over the past few years I have worked on projects ranging from Canadian retailing to neurosurgeon compensation. Through this experience, I’ve noticed patterns of what makes a good analyst.
Specifically, I’ve seen the best and worst in Microsoft Excel and data analysis. My online training is meant as a resource for recent grads and others who want to advance their career through Microsoft Excel, data analytics, and business economics.
I've been featured on Excel TV, the Smart Data Collective, Brazen Careerist, and other blogs about business analytics and career development.
Find me at firstname.lastname@example.org for any questions about the course.