Hired with Excel: What Every Analyst Needs to Know

taught by George Mount Watch Intro Video

Course description


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

Exercise files

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

Topics covered

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.

Refund policy

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 george@georgejmount.com for more information.

George Mount
George Mount
PhD student, Excel enthusiast

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 george@georgejmount.com for any questions about the course.

Course Curriculum

Introduction
35:31
1. What is an analyst?
2. Course Prereqs and Features
3. Why learn Excel as an analyst?
4. What analysts really do
5. My Excel journey
6. Course framing and themes
7. Caveats, Observations FREE
Discussion
Resources
8. The Art of Fixing Bad Spreadsheets FREE
Show Content
VLOOKUP: The Duct Tape of Excel
56:27
1. Writing the Basic VLOOKUP
2. Including Relative and Absolute References
3. Using VLOOKUP with Excel Tables
4. Including IFERROR
5. Handling Cells Formatted as Text
6. Handling Lefthand Lookups
7. Going Sideways with HLOOKUP
8. Finding Approximate Matches with TRUE
9. Putting it all together
Fix That Spreadsheet! VLOOKUP Challenge 1
Fix That Spreadsheet! VLOOKUP Solution 1
Fix That Spreadsheet! VLOOKUP Challenge 2
Fix That Spreadsheet! VLOOKUP Solution 2
Discussion
Resources
Appendix: Spotting Hard-Coded Cells (And What to do Next) FREE
Show Content
PivotTables: The WD-40 of Excel
43:53
1. PivotTable Data Prep
2. Anatomy of a PivotTable
3. Source Tables and Refreshing
4. Using Classic Display
5. Handling GETPIVOTDATA
6. Adding Calculated Fields
7. Putting it all together
Fix That Spreadsheet! PivotTable Challenge 1
Fix That Spreadsheet! PivotTable Solution 1
Fix That Spreadsheet! PivotTable Challenge 2
Fix That Spreadsheet! PivotTable Solution 2
Discussion
Resources
Show Content
Rounding Out Your Toolbox
Show Content
Get Hired with Excel
47:34
1. Job searching like JFK
2. Using LinkedIn to find the right job
3. Converting applications to interviews
4. Interviewing like an Excel geek
5. You can't hear a good analyst...
6. Selling on benefits, not features
7. Answering the question: "Why Should I Hire You?"
8. Answering the question: "Where do you go for help?"
9. "Rate your Excel skills..."
10. Handling other curveballs
Discussion
Resources
Show Content
Conclusion
08:27
1. Conclusion: Stretch and Excel
Discussion
Resources
Show Content