MS Excel - JumpStart to Analyst
4.5 (213 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,015 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.5 (213 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,015 students enrolled
Created by Jason Zhang
Last updated 6/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • Have Microsoft Excel 2007 or above installed
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.

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
Expand All 42 Lectures Collapse All 42 Lectures 02:17:01
+
Course Overview
5 Lectures 07:15


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.

How to join my email list
00:13

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
01:57
+
Excel formula hack
6 Lectures 14:40

See how Excel calculates

Preview 01:03

Relative and Absolute Reference
02:11

Autofill
02:04

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
03:01

Basic Excel Formulas
04:15

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
04:19



Filter in table and in range, Pros&Cons
01:47

INCLUDE ONE BONUS

Conditional Formatting - From Basic to Fancy
03:58



Creative way to entry data

Data Validation - Creative Way for Data Entry
01:59

Check in with you
01:43
+
8 Formulas Analysts must MASTER
9 Lectures 31:22
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

+
Mysterious Pivot Table
7 Lectures 31:02
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
+
BONUS: Data Analysis Series
6 Lectures 32:01
Sensitivity Analysis
07:11

How to interpret sensitivity analysis
02:53

Sensitivity Analysis Table
05:07

Scenario Analysis
09:52

Goal Seek
04:27

About the Instructor
Jason Zhang
4.2 Average rating
843 Reviews
9,856 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.