4.96 out of 5
4.96
82 reviews on Udemy

Microsoft Excel for Financial Analysts

Learn How to Perform Financial Modeling and Analysis using Microsoft Excel
Instructor:
Joseph Okon
122 students enrolled
English [Auto]
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

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!

Introduction to Financial Analysis

1
What is Financial Analysis
2
Role of Microsoft Excel as a Tool for Financial Analysis

Essential Excel Functions for Financial Analysis

1
Excel Functions for Financial Analysis (Part 1)
2
Excel Functions for Financial Analysis (Part 2)
3
Assignment 1

Pivot Tables for Financial Analysis

1
Preparing Profit and Loss Statement with Pivot Tables
2
Assignment 2
3
Preparing a Balance Sheet with Pivot Tables

Introduction to Financial Modeling

1
What is Financial Modeling
2
How to Create a Revenue Forecast Model

What-if Analysis for Building Financial Models

1
Creating a Sales Forecast Model with Scenario Analysis
2
Goal Seek for Financial Analysis
3
Data Table
4
Assignment 3

Time Value of Money (TVM) Analysis

1
Time Value of Money Analysis
2
Calculating Present Value (PV)
3
Calculating Future Value
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
5
5 out of 5
82 Ratings

Detailed Rating

Stars 5
78
Stars 4
2
Stars 3
1
Stars 2
0
Stars 1
0