Microsoft Excel for Financial Analysts

Focused View

Joseph Okon

2:10:10

26 View

1. Introduction to Financial Analysis

1. What is Financial Analysis.mp4

01:11

2. Role of Microsoft Excel as a Tool for Financial Analysis.mp4

10:29

2. Essential Excel Functions for Financial Analysis

1.1 Excel Functions 1.xlsx

1. Excel Functions for Financial Analysis (Part 1).mp4

19:11

2.1 Part 2.xlsx

2. Excel Functions for Financial Analysis (Part 2).mp4

28:13

3.1 Assignment 1.xlsx

3. Assignment 1.mp4

02:07

3. Pivot Tables for Financial Analysis

1.1 Pivot Table for Financial Analysis.xlsx

1. Preparing Profit and Loss Statement with Pivot Tables.mp4

14:19

2.1 Assignment 2.xlsx

2. Assignment 2.mp4

01:13

3.1 Balanced Sheet with Pivot Tables.xlsx

3. Preparing a Balance Sheet with Pivot Tables.mp4

11:37

4. Introduction to Financial Modeling

1. What is Financial Modeling.mp4

02:04

2.1 Revenue Forecast Modeling.xlsx

2. How to Create a Revenue Forecast Model.mp4

05:03

5. What-if Analysis for Building Financial Models

1.1 Scenario Analysis 1.xlsx

1. Creating a Sales Forecast Model with Scenario Analysis.mp4

09:02

2. Goal Seek for Financial Analysis.mp4

04:29

3. Data Table.mp4

03:07

4.1 Assignment 3.xlsx

4. Assignment 3.mp4

01:20

6. Time Value of Money (TVM) Analysis

1. Time Value of Money Analysis.mp4

04:05

2.1 Present Value.xlsx

2. Calculating Present Value (PV).mp4

06:33

3.1 Future Value.xlsx

3. Calculating Future Value.mp4

06:07

Description

Learn How to Perform Financial Modeling and Analysis using Microsoft Excel

What You'll Learn?

How to Perform Financial Analysis with Microsoft Excel
How to Prepare Financial Report
Create Excel Model for Financial Report
Become Proficient in Microsoft Excel for Financial Analysis
Finance Functions in Excel

Who is this for?

Financial Analysts

Anyone Who Wants to Master Microsoft Excel for Financial Analysis

Accountants

What You Need to Know?

Microsoft Excel 2016, 2021 and 365 package on your PC

Basic Knowledge of Financial Reports

More details

Description
If you are trying to prepare for a career in finance, then this course is for you. This Excel course is specifically for those who want to learn how to perform professional Financial Analysis and Financial Modeling using Microsoft Excel.
In this course, you will learn key skills that are required by Financial Accountants and Analysts when working with business data. Ever wondered how financial wizards decode complex numbers? This course unveils the magic behind financial analysis, giving you the skills to dissect data like a pro using Microsoft Excel.
This course starts with the basics and quickly progresses to a level where even experts will learn something new. Take your Excel skills to the next level by mastering financial modeling. It's the secret sauce used by financial accountants and analysts worldwide.
Here's what you are getting in this course;
How to Perform Financial Analysis and Modeling with Microsoft Excel
Create Excel Model for Financial Report
How to Prepare Financial Report
Concept of Time Value of Money
Excel Finance Functions in Excel
How to Prepare Profit and Loss Statement with Pivot Tables
How to Create a Revenue Forecast Model
Goal Seek for Financial Analysis
Preparing Balance Sheet with Pivot Tables
And much more!
I don't believe in theory without practice. Get ready to roll up your sleeves and dive into real-world scenarios. You'll tackle business data head-on, just like the pros. This course comes with lots of assignment to practice with.
If youâ€™re ready to take your financial modeling and business analysis skills to the next level, this course is for you.

See you on the other side!
Who this course is for:
Financial Analysts
Anyone Who Wants to Master Microsoft Excel for Financial Analysis
Accountants

User Reviews

Rating

average 0

Total votes0

Focused display

Joseph Okon is a Data Analyst with years of experience. He is a mentor and a coach. He has trained more than 500 students in the field of Data Analysis.He also share video tutorials and guides on how to use Microsoft Excel and SQL for data analysis via his YouTube channel.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.