Financial Analysis & Modelling with Microsoft Excel – Complete Course
A course by Awesome Emmanuel, Finance
99% Positive Reviews (39)
3034 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
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)
Financial Analysis & Modelling Part 2 (Advance Analytical Functions)
Financial Analysis & Modelling Part 3 (Financial Functions & Analysis)
Financial Analysis & Modelling Part 4 (Financial Statements & Model)
Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards)
Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting)
Financial Analysis & Modelling Part 7 (Financial Modelling)
Recent reviews
Empower and fuel your creativity and passion for learning, read testimonials
Nasiru Muhammed
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
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
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
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
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
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.
Kalaluka Mutumba
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 👏👏👏
Ajayi Timothy Oluwatimilehin
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
NWOSU FRANCISCA LOTACHUKWU
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
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
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
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
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
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
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
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.
Kalaluka Mutumba
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 👏👏👏
Ajayi Timothy Oluwatimilehin
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
NWOSU FRANCISCA LOTACHUKWU
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
This course gave me a different view about excel and has increase my knowledge in data analysis from a financial standpoint.
3hours left
Course features
-
64 Lessons(7 Hours)
-
3 years access to course
-
3034 Students
-
Skill level : All Levels
-
Certificate : Yes
-
Rated: 4.8
You may also like
Choose from variety of courses and learning path
Finance 
4363 3hours left
ZMW192
ZMW634