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 (19)
2444 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
Nasiru Muhammed
Rating |
This is fantastic. Though, from the academic environment, I found the presentation educative and practical, adding to my knowledge. The presentation of the modelling is smart, simple and straight forward. In fact, this knowledge will be used in teaching my student practically and for my private development. Thanks alot
Alfred Lungu
Rating |
Excellent stuff!!! I will want to see how we can help the Small Scale farmers i.e. show them how to present their business in financial terms & how they can monitor their business. Such financial literacy would take the farmers to another level & improve on access to finance.
Suleiman Tambaya
Rating |
You are such good teacher, how you know how to breakdown complex Excel issues into simple and learnable bits and pieces say a lot about your person. But most importantly, learning everything here for the amount which the course was purchased is actually a huge dash.
Misozi Nyirenda
Rating |
I want to recommend this course to everyone who is in finance and who wants to have know-how in finance. I have had a very good experience and I've learnt alot and I'll make sure to put use of these skills. Thank u so much Awesome.
Gabriel Otieno
Rating |
So far the course is excellent and I am learning a bunch of stuff. The instructor, Awesome Emmanuel, is simplifying the materials in a manner that is easy to grasp. Kudos to him and the team :)
CHIPANGO KASOSELA
Rating |
the course is just more than my expectations, well explained structured. so far so good, am enjoying getting to see how the accounting am learning is being done practically.
Ajayi Timothy Oluwatimilehin
Rating |
I Will recommend this course for anyone with or without knowledge of finance and for those that want to improve their skill in finance. Great job by the instructor
Kalaluka Mutumba
Rating |
This is a very wonderful course. I definitely recommend this for anyone who wants to go into Finance but also every entrepreneur out there. Great work Emmanuel 👏👏👏
NWOSU FRANCISCA LOTACHUKWU
Rating |
Very interesting. Seriously i have learn a lot from this course, especially basic excel formulars. I didn't regret registering for the course.
Edward Kaitibie
Rating |
This course gave me a different view about excel and has increase my knowledge in data analysis from a financial standpoint.
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
Nasiru Muhammed
Rating |
This is fantastic. Though, from the academic environment, I found the presentation educative and practical, adding to my knowledge. The presentation of the modelling is smart, simple and straight forward. In fact, this knowledge will be used in teaching my student practically and for my private development. Thanks alot
Alfred Lungu
Rating |
Excellent stuff!!! I will want to see how we can help the Small Scale farmers i.e. show them how to present their business in financial terms & how they can monitor their business. Such financial literacy would take the farmers to another level & improve on access to finance.
Suleiman Tambaya
Rating |
You are such good teacher, how you know how to breakdown complex Excel issues into simple and learnable bits and pieces say a lot about your person. But most importantly, learning everything here for the amount which the course was purchased is actually a huge dash.
Misozi Nyirenda
Rating |
I want to recommend this course to everyone who is in finance and who wants to have know-how in finance. I have had a very good experience and I've learnt alot and I'll make sure to put use of these skills. Thank u so much Awesome.
Gabriel Otieno
Rating |
So far the course is excellent and I am learning a bunch of stuff. The instructor, Awesome Emmanuel, is simplifying the materials in a manner that is easy to grasp. Kudos to him and the team :)
CHIPANGO KASOSELA
Rating |
the course is just more than my expectations, well explained structured. so far so good, am enjoying getting to see how the accounting am learning is being done practically.
Ajayi Timothy Oluwatimilehin
Rating |
I Will recommend this course for anyone with or without knowledge of finance and for those that want to improve their skill in finance. Great job by the instructor
Kalaluka Mutumba
Rating |
This is a very wonderful course. I definitely recommend this for anyone who wants to go into Finance but also every entrepreneur out there. Great work Emmanuel 👏👏👏
NWOSU FRANCISCA LOTACHUKWU
Rating |
Very interesting. Seriously i have learn a lot from this course, especially basic excel formulars. I didn't regret registering for the course.
Edward Kaitibie
Rating |
This course gave me a different view about excel and has increase my knowledge in data analysis from a financial standpoint.
₦4,200
NGN
70% Disc.
₦13,900
1hour left
Course features
-
64 Lessons(7 Hours)
-
Lifetime access to course
-
2444 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.9
Smartphone Photography, Video Editing, Graphic Design, Whiteboard Animation, Motion Design, ...
Mobile Skill Acquisition Course 
228
₦13,300
₦4,000
1hour left
₦4,200
₦13,900
Get latest Updates & News
These are pillars that trusted and support our vision and mission
