MS Excel - JumpStart to Analyst
4.3 (220 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,023 students enrolled
Wishlisted Wishlist

Please confirm that you want to add MS Excel - JumpStart to Analyst to your Wishlist.

Add to Wishlist

MS Excel - JumpStart to Analyst

Fastest way from 0 to proficient beginner. No B.S, short, concise tutorial.
4.3 (220 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
5,023 students enrolled
Created by Jason Zhang
Last updated 6/2016
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 3 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Use Excel functions and formulas proficiently like a professional analyst
  • Perform better in the workplace using not only Excel technical skills, but also correct mindset
View Curriculum
  • Have Microsoft Excel 2007 or above installed

If you want a career change to more analytical role, if you want to be an analyst, this course is the fastest way for you to learn Excel. 

Here in this course, I only teach things that you will apply in your work as an analyst. There are thousands of functions in Excel, what analyst use on daily basis is within 20. Among thousands of shortcuts in Excel. What an analyst need is under 30. I am going to save your time and only teach the things that are important, from the start. That's why it's a jump-start.

The analysts I am referring to are financial analysts, budget analysts,and research analysts. Because I've been working in all of these positions from start-up to Fortune 500 companies. I know at this point your job is somewhat about digging in numbers and impress your boss with what you find. I am here to help you to impress your boss, get promoted, get hired, and become one of the best.

Who is the target audience?
  • Entry level analyst who wants to improve Excel skills quickly
  • People who are looking for analyst jobs
  • Having been using Excel for a while but wondering if there is better way to do certain things
  • Switching to Analyst position from other jobs
Students Who Viewed This Course Also Viewed
Curriculum For This Course
42 Lectures
Course Overview
5 Lectures 07:15

Join email list to get exclusive contents, career tips, Excel tips for free! Here is the link: I don't bother you very often, but when I do, I hope you can benefit from it the next day.

How to join my email list

1. What do I mean by basic excel or advanced excel, where are you at?

2. How and What you will learn?

Preview 03:20

Navigate through the layout of Excel. Skip this if you have worked with Excel before

Get started with Excel
Excel formula hack
6 Lectures 14:40

See how Excel calculates

Preview 01:03

Relative and Absolute Reference


Even if you've been using excel for a while you may not have known that.

3X your productivity using 3 shortcuts + 1 useful tip

Basic Excel Formulas

When to use which function and how to learn

Preview 02:06
Excel Functions Hack
9 Lectures 20:54

Best practice from experience

Basic Formatting-From Basic to Best Sequence

Filter in table and in range, Pros&Cons


Conditional Formatting - From Basic to Fancy

Creative way to entry data

Data Validation - Creative Way for Data Entry

Check in with you
8 Formulas Analysts must MASTER
9 Lectures 31:22
Analyst most favorite: IF formula

SUMIF(s) This is more important than you think


How to add labels based on conditions: LOOKUP

Upgrade from LOOKUP: VLOOKUP

How to make a Dynamic Table in 2 min

HLOOKUP to the rescue


Mysterious Pivot Table
7 Lectures 31:02
Pivot Table mystery revealed

Subtotal in Pivot Table

Calculated Column Part 1

Calculated Column Part 2

Slicer and Timeline

Dashboard Design Principals

Dashboard using Pivot Table
BONUS: Data Analysis Series
6 Lectures 32:01
Sensitivity Analysis

How to interpret sensitivity analysis

Sensitivity Analysis Table

Scenario Analysis

Goal Seek

About the Instructor
Jason Zhang
4.4 Average rating
1,032 Reviews
12,021 Students
2 Courses
Financial Analyst

Jason has worked as a financial analyst, business analyst, and research analyst from start-up to fortune 500 companies. He holds a Master Degree in Finance from the Johns Hopkins University. He passed CFA level 3 exam.

Jason dedicates his time to help analysts get promoted, get better job and better life, starting from having outstanding Excel skills.

Excel is a powerful tool. It's like golf. You can learn it within several hours, but improve it for the rest of your life. There are tons of free materials out there. But you need structured lectures to build a good mindset in order to reach your goal, which is getting the job done beautifully. So that you can ask for raise, for promotion, even your dream job.