Get Started
Become an Instructor
Become an Instructor
Financial Analysis & Modelling with Microsoft Excel – Complete Course
A course by Awesome Emmanuel, Finance
Popular Course
English
99% Positive Reviews (22)
2480 Students
This course teaches how to use Ms. Excel to evaluate businesses, projects, budgets, and other finance-related transactions to determine their performance and ...
What you'll learn
-
Understand the fundamentals of Microsoft Excel in Financial Analysis
-
Format spreadsheets professionally
-
Perform routine financial tasks with basic & advance Ms Excel Functions
-
Create professional charts in Microsoft Excel
-
Design an interactive financial dashboard
-
Build a company’s P&L from scratch
-
Create a company’s balance sheet and cash flow statement
-
Perform 3 statements financial analysis
-
Understand the dynamics of the Time Value of Money (PV, FV, PMT)
-
Carry out Financial Ratio Analysis
-
Perform Trend Analysis, Comparative Analysis, What-If Analysis and Forecasting
-
Calculate a complete amortization table (loan schedule)
-
Design an interactive financial model
Description
Course Content
Reviews
To be alive, every business organization needs the service of a Financial Analyst to help glean insight from the company’s financial information and to make profitable result-driven decisions. 💡
Similarly, companies seek Financial Modelers whose jobs are to design financial models that describe the performance of an investment like a financial asset, which in turn helps the organization find new market opportunities, forecast, and quantify risk. 📊📈📉🔍
Understanding the dynamics and knowledge of the skills needed to prepare and interpret financial records like balance sheets, cash flow statements, income statements, statements of shareholder’s equity, and designed interactive financial models is of tremendous value to anyone seeking a space in the financial and business environment.
This course Financial Analysis & Modelling is therefore structured to equip you with the analytical and practical skills needed to become a competent financial analyst and a financial modeler. 💪
KEY QUESTIONS:
What are the course requirements?
Access to a laptop or computer.
Will certificate be issued?
Yes, a certificate of completion will be issued at the end of the course.
Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions)
16 lectures
1 minute
12 minutes
8 minutes
8 minutes
5 minutes
3 minutes
11 minutes
6 minutes
9 minutes
5 minutes
3 minutes
2 minutes
3 minutes
3 minutes
6 minutes
Financial Analysis & Modelling Part 2 (Advance Analytical Functions)
7 lectures
1 minute
6 minutes
3 minutes
12 minutes
17 minutes
5 minutes
7 minutes
Financial Analysis & Modelling Part 3 (Financial Functions & Analysis)
6 lectures
1 minute
6 minutes
7 minutes
4 minutes
12 minutes
Financial Analysis & Modelling Part 4 (Financial Statements & Model)
8 lectures
1 minute
14 minutes
10 minutes
22 minutes
9 minutes
22 minutes
19 minutes
Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards)
4 lectures
1 minute
19 minutes
18 minutes
Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting)
9 lectures
1 minute
14 minutes
18 minutes
16 minutes
10 minutes
7 minutes
8 minutes
9 minutes
Financial Analysis & Modelling Part 7 (Financial Modelling)
14 lectures
5 minutes
15 minutes
16 minutes
--
Recent reviews
Empower and fuel your creativity and passion for learning, read testimonials
Obed Worwornyo
Rating |
elaborate explanation and easy to understand.
Colson Turamye
Rating |
Insightful
ADEKUNLE AKINTOMIDE MICHAEL
Rating |
IMPACTFUL
Kikelomo Ayanfe
Rating |
Thank you the material was helpful
Chinedu Obiora
Rating |
Great explanations and practical knowledge
PEACE ANTHONY UKACHUKWU
Rating |
The course is quite interesting
Edward Mhango
Rating |
Great stuff
Nkhonde Mwale
Rating |
I'm loving the lessons from this course. It has helped me understand a lot about financial modelling.
Daphine Moraa Omwega
Rating |
Very detailed
Salawu Oluwakemi Elizabeth
Rating |
This course is very educative and helpful, i am glad i subscribe to this, it really worth it. Thank you
Frequently Asked Questions (FAQ)
Are the videos downloadable ?
The videos are efficiently compressed for quick downloads at any time.
How do I access the course videos and materials?
Once your payment is complete, you will have full access to the course lessons and materials. You can download and watch them at your convenience, and our team will provide full support and assistance throughout your learning journey.
How can I obtain my certificate after completing the course?
Once you have completed the course, you can easily download your certificate directly from your dashboard.
See course top reviews
Empower and fuel your creativity and passion for learning, read testimonials
Obed Worwornyo
Rating |
elaborate explanation and easy to understand.
Colson Turamye
Rating |
Insightful
ADEKUNLE AKINTOMIDE MICHAEL
Rating |
IMPACTFUL
Kikelomo Ayanfe
Rating |
Thank you the material was helpful
Chinedu Obiora
Rating |
Great explanations and practical knowledge
PEACE ANTHONY UKACHUKWU
Rating |
The course is quite interesting
Edward Mhango
Rating |
Great stuff
Nkhonde Mwale
Rating |
I'm loving the lessons from this course. It has helped me understand a lot about financial modelling.
Daphine Moraa Omwega
Rating |
Very detailed
Salawu Oluwakemi Elizabeth
Rating |
This course is very educative and helpful, i am glad i subscribe to this, it really worth it. Thank you
₦4,200
NGN
70% Disc.
₦13,900
6minutes left
Course features
-
64 Lessons(7 Hours)
-
Lifetime access to course
-
2480 Students
-
Skill level : All Levels
-
Certificate : Yes
-
Rated: 4.8
Certificate preview
You may also like
Choose from variety of courses and learning path
4.8
Smartphone Photography, Video Editing, Graphic Design, Whiteboard Animation, Motion Design, ...
Mobile Skill Acquisition Course 
812
₦13,300
₦4,000
6minutes left
₦4,200
₦13,900
Get latest Updates & News
These are pillars that trusted and support our vision and mission
