Finance Training for Financial Analysts
4.3 (730 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,483 students enrolled

Finance Training for Financial Analysts

The comprehensive course in Excel, Accounting, Financial Analysis, Forecasting, Business Valuation and PowerPoint.
4.3 (729 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,483 students enrolled
Created by Ashish Agarwal
Last updated 5/2020
English
English
Current price: $100.99 Original price: $144.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 9.5 hours on-demand video
  • 23 articles
  • 21 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Undertake data analysis and manipulation in Excel
  • Make flexible and dynamic financial models
  • Create data visualization charts in Excel
  • Prepare the accounting statements of any company
  • Create income statement, balance sheet and cash flows statement from scratch
  • Perform ratio analysis on company financials
  • Compare the performance of different companies using a framework
  • Create a forward looking integrated financial model
  • Extrapolate and forecast forward looking financial ratios
  • Apply the Discounted Cash Flows valuation technique on a real company
  • Apply the Multiples valuation technique on a real company
  • Use PowerPoint for creating business presentations
Requirements
  • Absolutely none. We will teach everything from scratch.
Description

Hey, welcome to our best-selling Finance Training for Financial Analysts course.

We are glad to see you visit this course. 

If only we could shake hands!

What is this course about?

In this course, we will teach you the comprehensive skills needed to be a Financial Analyst.

We will illustrate the following broad content topics in great detail in this course:

1) Excel

2) Accounting

3) Financial statement analysis

4) Forecasting financial statements

5) Business valuation

6) PowerPoint

It is a very comprehensive course that will teach you the complete skills of a Financial Analyst.

How is this course useful for YOUR purpose?

Hey, did you watch the promo video? If not, please do. 

If you are looking to be a Financial Analyst, then this course will prepare you for the job.

Look, the Financial Analyst jobs are high paying ones. 

So your employer will want you to be on ready to work on a real project on Day 1!

Our course does exactly that - we make you job ready for your professional work.

The course provides all the practical training of a Financial Analyst.

You can crack your upcoming interviews easily with the learning from this course.

You have lifetime access to the course once you enroll. 

So even if you don't plan to start now, you can still enroll and come back anytime later.

What makes this course different than others?

This course content is unique!

You will learn exactly what you are required to do in your daily work.

You get access to practical real life illustrations of all key skills to be a Financial Analyst.

It is a completely hands-on course.

You need to carry out the illustrations in the course along with the instructor.

We provide you the same set up as the instructor. 

All illustration spreadsheets can be downloaded at your end.

You will feel as if somebody is guiding you step by step in all illustrations.

It is a very practical on the job training for you.

You are going to love our instructor's teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments to test your learning from the course

The Practice Assignments are marked with varying difficulty levels - High, Medium and Low.

You will have unlimited access to our support.

Our support team responds to any course queries within 24 hours of your request. 

There are manually edited hand typed captions added on all lectures of this course. 

Feel free to refer to them in case you feel the need.

And of course, the price is competitive. 

What are other students saying about this course?

Check our our reviews below.

Read what student Rameez Akhtar wrote - 

"THE COURSE COVERS ALMOST EVERYTHING THAT WILL GIVE A YOUNG ASPIRING FINANCIAL ANALYST ALL THE TOOLS TO LAND A SUITABLE JOB IN THIS COMPETITIVE WORLD."

Go to the reviews section below to read more such stories.


What if YOU do not like the course?

Well, we will be very sad to hear that you did not like the course.

But you are well protected.

You have a 30 day money back guarantee in case you are not happy with the course.

No questions asked.

But we sincerely hope, you will definitely like the course!

What  next?

If there are any doubts, don't hesitate to reach out to us.

Start learning now.

See you inside the course.

Who this course is for:
  • Current Financial Analysts
  • Aspiring Financial Analysts
  • Start-up founders
  • Consultants
  • Non finance professionals
Course content
Expand all 143 lectures 09:47:29
+ Module 1: Basic excel functions to analyze large data
17 lectures 01:59:27
Extraction of data: understanding the SUMIF function
08:14
Extraction of data: calculating growth rates
03:58
Extraction of data: understanding the VLOOKUP function
11:40
Extraction of data: understanding the HLOOKUP function
09:31
Extraction of data: understanding the INDEX and MATCH function
13:56
Extraction of data: understanding the IF, COUNTIF and COUNTIFS function
09:09
Presentation of data: understanding the LINE chart
12:33
Presentation of data: understanding the PIE chart
11:45
Presentation of data: understanding the COLUMN chart
13:03
Presentation of data: understanding the STACKED COLUMN chart
10:56
Presentation of data: understanding the CONDITIONAL FORMATTING function
06:58
Practice Assignment 1: DIFFICULTY LEVEL - MEDIUM
00:24
SOLUTION TO PRACTICE ASSIGNMENT 1
00:04

This brings us to the end of module 1 in which we looked at key excel functions to analyze large data.

Lecture 17: End of Module 1
00:02
+ Module 2: Basics of financial accounting statements
18 lectures 31:07
Introduction to Module 2
01:43
What is accounting and why we need it?
04:18
Key financial statements: Income statement
03:30
Key financial statements: Balance sheet
03:14
Illustration for this module
00:49
Illustration of transaction 1
00:40
Illustration of transaction 2
01:03
Illustration of transaction 3
01:35
Illustration of transaction 4
02:21
Illustration of transaction 5
01:55
Illustration of transaction 7
02:07
Illustration of transaction 8
01:52
Illustration of transaction 9
01:34
Illustration of transaction 10
01:54
Practice Assignment #2: DIFFICULTY LEVEL - MEDIUM
00:24
SOLUTION TO PRACTICE ASSIGNMENT #2
00:02

This brings us at the end of the module 2 in which we learnt how to prepare the financial accounting statements of a company.

End of Module 2
00:06
+ Module 3: Financial performance analysis of companies
19 lectures 01:04:17
Introduction to Module 3
01:54
Introduction to financial performance analysis
02:24
Download the excel spreadsheet illustration for this module
00:34
Illustration for this module
05:06
What are the key metrics for measuring performance of companies?
09:27
Calculation of operating metrics for Company 1
05:39
Calculation of operating and financing metrics for Company 2
05:05
Calculation of operating and financing metrics for Company 3 and Company 4
00:43
Calculation of averages for all metrics across companies
06:50
Visual representation of metrics across companies
01:44
Ranking of operating metrics
06:15
Ranking of financing metrics
05:34
Choosing the best company
03:12
Quick recap: What did we learn?
02:14
Practice Assignment #3: DIFFICULTY LEVEL - EASY
00:25
SOLUTION TO PRACTICE ASSIGNMENT #3
00:02
End of Module 3
00:05
+ Module 4: Forecasting an integrated financial model
23 lectures 02:06:15
Introduction to Module 4
02:10
Illustration for this module
01:13
Download the illustration exercise for the course
00:34
Step 1: Capturing historical IS & BS
08:00
Step 2a: Calculating historical IS ratios
12:20
Step 2b: Calculating historical BS ratios
06:39
Step 3a: Extrapolating future IS ratios
10:17
Step 3b: Extrapolating future BS ratios
05:01
Quick recap of what we have do so far
01:27
Step 4a: Forecasting future income statement
12:01
Step 4b: Forecasting future balance sheet - assets side
07:17
Step 4c: Forecasting the future balance sheet - liabilities side
12:56
What are the components of cash flow statement?
06:18
Step 5a: Calculating the cash flow from operations
13:54
Step 5b: Calculating the cash flow from investments
07:34
Step 5c: Calculating the cash flow from financing
07:53
Step 5d: Calculating the cash balance at end of year
03:03
Step 6: Integrating the balance sheet with cash flows statement
02:19
Recap: What did we learn in this module?
01:49
Practice Assignment #4: DIFFICULTY LEVEL - HARD
00:25
SOLUTION TO PRACTICE ASSIGNMENT #4
00:02
End of Module 4
00:06
+ Module 5: Conceptual understanding of Discounted Cash Flow valuation technique
10 lectures 20:34
Introduction to Module 5
01:49
What is valuation?
02:09
What does the Discounted Cash Flow technique estimate?
02:58
Free Cash flows are calculated for the future
01:44
Calculation of the discount rate or WACC?
02:31
Discounting future cash flows to calculate present value
02:19
Calculation of Terminal Value
01:12
Calculation of enterprise value and equity value
00:47
End of Module 5
00:09
+ Module 6: Step by step illustration of DCF valuation technique
20 lectures 01:03:10
5 steps to doing a DCF valuation
01:38
Download the illustration exercise for the module
00:34
Lets look at the data for the illustration in this module
04:55
Step 1a: Calculating EBIT
05:47
Step 1c: Calculating capex
05:50
Step 1d: Calculating operating cash investments
03:10
Step 1e: Calculating Free Cash Flows to Firm (FCFF)
02:52
Step 2a: Calculating WACC
06:15
Understanding the concept of discounting
03:06
Step 2b: Discounting future cash flows to present value terms
04:12
Step 3: Calculating Terminal Value
04:33
Step 4: Calculating Enterprise Value
00:58
Step 5: Calculating equity value and share price
01:40
Sensitivity analysis on share price
07:13
Recap of what we learnt in this module
01:15
Practice Assignment #5: DIFFICULTY LEVEL - EASY
00:25
SOLUTION TO PRACTICE ASSIGNMENT #5
00:02
End of Module 6
00:07
+ Module 7: Conceptual understanding of the multiples based valuation technique
15 lectures 55:18
Introduction to Module 7
02:04
What are the different techniques of equity valuation?
05:11
A very brief overview of Discounted cash flow technique
01:48
Multiples based valuation: what does a multiple denote?
01:32
Multiples based valuation: What are the different types of multiples used?
03:21
Illustration for this module
02:22
Financial statements supplements to the illustration
02:44
Steps to do a multiples based valuation
04:46
step 1: choosing the right peers
06:34
Step 2: Calculating the peer multiples
04:25
Step 3: Calculating the target value
06:18
So what is the best multiple to use?
07:51
Recap: What did we learn in this module?
03:40
End of Module 7
00:07
+ Module 8: Practical application of the multiples based valuation
7 lectures 22:01
Download the illustration exercise for this module
00:34
How to do a sum of the parts valuation using multiples (1/2)
11:53
How to do a sum of the parts valuation using multiples (2/2)
05:27
Practice Assignment #6: DIFFICULTY LEVEL - EASY
00:25
SOLUTION TO PRACTICE ASSIGNMENT #6
00:02
End of Module 8
00:06
+ Module 9: Advanced excel functions to analyze large data
12 lectures 01:16:59

Please download this excel template in this module

Download the excel template for this module
00:34
Understanding the OFFSET function
08:30
Understanding the SUMPRODUCT function
08:24
Understanding the GOAL SEEK function
08:29
Understanding the INDEX-MATCH function
18:54
Understanding the PIVOT function
11:14
Understanding the INDIRECT function
11:31
Practice Assignment #7: DIFFICULTY LEVEL - MEDIUM
00:25
SOLUTION TO PRACTICE ASSIGNMENT #7
00:08
End of Module 9
00:07