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 learn 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 take 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.
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 firstname.lastname@example.org for more information.
I like helping people manage their data so they can think more creatively.
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.
While I had big ideas about making an impact to the business, I felt drowned and overwhelmed in the data. There was no way to see the forest, because I was stuck in the trees of confusing spreadsheets.
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.
RankedBlogs.com and Feedspot.com have both recognized me as a top online authority on Excel. This mastery forms the basis for posts on business analytics, career management and innovation which have been featured on leading sites like Excel.TV and Brazen.
As featured on:
More about me…
I hold a bachelor’s in economics, magna cum laude, from Hillsdale College and two master’s degrees from Case Western Reserve University’s Weatherhead School of Management, in finance and information systems.
I have also completed a certificate in business analytics from Indiana University’s Kelley School of Business as well as a Certificate of Achievement in Quantitative Methods, also from Weatherhead.
Find me at email@example.com for any questions about the course.