MS Excel - JumpStart to Analyst

Name: MS Excel - JumpStart to Analyst
Rating: 4.6 (327 reviews)

Fastest way from 0 to proficient beginner. No B.S, short, concise tutorial.

Created byJason Zhang

Last updated 6/2016

English

English [Auto],

What you'll 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

Course content

6 sections • 42 lectures • 2h 17m total length

Watch this before you start1:38
This lecture emphasizes practice as the key to mastering Excel, recommending keeping your workbook open, practicing on the right side after demonstrations, and subscribing for exclusive Excel tips via email.
DOWNLOAD WORK FILE HERE0:06
How to join my email list0:11
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.
Excel Learning Road Map and What's covered3:20
1. What do I mean by basic excel or advanced excel, where are you at?

2. How and What you will learn?
Get started with Excel1:57
Navigate through the layout of Excel. Skip this if you have worked with Excel before

Simple Calculations1:03
See how Excel calculates
Relative and Absolute Reference2:11
Autofill2:04
3X your productivity using 3 shortcuts + 1 useful tip3:01
Even if you've been using excel for a while you may not have known that.
Basic Excel Formulas4:15
Learn three methods to compute average and count in Excel: insert function, manual typing, and the equals shortcut. Build a foundation with shortcuts and verify results on the status bar.
When to use which function and how to learn2:06
When to use which function and how to learn

Basic Formatting-From Basic to Best Sequence4:19
Best practice from experience
Group & Freeze Panes - From Basic to Fancy way to use it1:51
Format as Table Basic and Why Use it1:50
Create a cool looking table in Excel quickly with format as table, using Ctrl+T, presets, and a total row, and convert the table back to a range when needed.
Filter in table and in range, Pros&Cons1:47
Conditional Formatting - From Basic to Fancy3:58
INCLUDE ONE BONUS
Format Painter- the Right Way1:08
Comment- Best Practice2:19
Data Validation - Creative Way for Data Entry1:59
Creative way to entry data
Check in with you1:43

Analyst most favorite: IF formula4:17
Master the if formula in Excel, using a logical test to categorize transactions and label them as large, median, or small, including nested scenarios.
SUMIF(s) This is more important than you think2:51
Learn to use sumif and sumifs in Excel to total amounts by multiple criteria. Understand text criteria with quotes, numeric criteria, and the roles of criteria and sum ranges.
COUNTIF(s)1:19
How to add labels based on conditions: LOOKUP4:05
Learn how the lookup formula replaces nested ifs by searching the left column and returning the right-hand value, with array and vector modes.
Upgrade from LOOKUP: VLOOKUP5:41
Upgrade from look up to vlookup to fetch names and amounts by invoice number in a table. Use column index and range lookup, and prefer exact match over approximate.
How to make a Dynamic Table in 2 min0:33
HLOOKUP to the rescue2:52
Explore how hlookup performs horizontal lookups to retrieve invoice numbers and amounts from a table, using row index numbers, exact matches, and data validation to build a dynamic table.
Upgrade from VLOOKUP: INDEX&MATCH6:34
Learn how to replace vlookup with index and match in Excel to overcome leftmost-column limits, using index, match inputs, exact match, and practical examples to retrieve invoice numbers and amounts.
How to stop making mistakes in Excel2:59

Pivot Table mystery revealed6:54
Discover how pivot tables reveal insights by rearranging data: drag fields into rows, columns, and values; compare region, size, and invoice amounts, and compute averages.
Subtotal in Pivot Table3:37
Explore subtotals in pivot tables by region, using design options and field settings to show bottom subtotals and switch among sum, average, and maximum with formatting.
Calculated Column Part 15:44
Calculated Column Part 22:23
Slicer and Timeline5:27
Learn how slicers and timelines filter pivot tables in Excel 2010 and later, and how to insert, format, and use timelines for date-based dashboards.
Dashboard Design Principals2:27
Apply simple dashboard design principles to make every graph tell a clear story in seconds; tailor charts to your boss’s needs, using pivot charts and concise pie data.
Dashboard using Pivot Table4:30

Sensitivity Analysis7:11
Explore sensitivity analysis in Excel by building one- and two-variable data tables to see how net present value changes with varying discount rates, using what-if analysis and practical steps.
How to interpret sensitivity analysis2:53
Explore sensitivity analysis by reading the table to see how net present value varies with interest rate and first year payback, highlighting best and worst project scenarios.
Sensitivity Analysis Table5:07
Learn to build a two-variable sensitivity analysis table in Excel, linking input cells to the net present value using a data table and what-if analysis.
Scenario Analysis9:52
Goal Seek4:27
Closing Remarks2:31

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 this course is for:

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

MS Excel - JumpStart to Analyst

What you'll learn

Explore related topics

Course content

Course Overview5 lectures • 7min

Excel formula hack6 lectures • 15min

Excel Functions Hack9 lectures • 21min

8 Formulas Analysts must MASTER9 lectures • 31min

Mysterious Pivot Table7 lectures • 31min

BONUS: Data Analysis Series6 lectures • 32min

Requirements

Description

Who this course is for: