MS Excel - JumpStart to Analyst

Fastest way from 0 to proficient beginner. No B.S, short, concise tutorial.
4.4 (196 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.
4,997 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 42
  • Length 2.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 8/2015 English

Course Description

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.

What are the requirements?

  • Have Microsoft Excel 2007 or above installed

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Course Overview
Watch this before you start
Preview
01:38
DOWNLOAD WORK FILE HERE
Preview
Article
Article

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

03:20

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

2. How and What you will learn?

01:57

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

Section 2: Excel formula hack
01:03

See how Excel calculates

Relative and Absolute Reference
02:11
Autofill
02:04
03:01

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

Basic Excel Formulas
04:15
02:06

When to use which function and how to learn

Section 3: Excel Functions Hack
04:19

Best practice from experience

Group & Freeze Panes - From Basic to Fancy way to use it
Preview
01:51
Format as Table Basic and Why Use it
Preview
01:50
Filter in table and in range, Pros&Cons
01:47
03:58

INCLUDE ONE BONUS

Format Painter- the Right Way
Preview
01:08
Comment- Best Practice
Preview
02:19
01:59

Creative way to entry data

Check in with you
01:43
Section 4: 8 Formulas Analysts must MASTER
Analyst most favorite: IF formula
04:17
SUMIF(s) This is more important than you think
02:51
COUNTIF(s)
01:19
How to add labels based on conditions: LOOKUP
04:05
Upgrade from LOOKUP: VLOOKUP
05:41
How to make a Dynamic Table in 2 min
00:33
HLOOKUP to the rescue
02:52
Upgrade from VLOOKUP: INDEX&MATCH
06:34
How to stop making mistakes in Excel
Preview
Article
Section 5: Mysterious Pivot Table
Pivot Table mystery revealed
06:54
Subtotal in Pivot Table
03:37
Calculated Column Part 1
05:44
Calculated Column Part 2
02:23
Slicer and Timeline
05:27
Dashboard Design Principals
02:27
Dashboard using Pivot Table
04:30
Section 6: BONUS: Data Analysis Series
Sensitivity Analysis
07:11
How to interpret sensitivity analysis
02:53
Sensitivity Analysis Table
05:07
Scenario Analysis
09:52
Goal Seek
04:27
Closing Remarks
Preview
02:31

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Jason Zhang, 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.

Ready to start learning?
Take This Course