Flash Sale🎉|70% discount on Courses!
1day 4hours left!

Financial Analysis & Modelling with Microsoft Excel – Complete Course – AQskill
Get Started
Register
Home
Certificate Verification New
About Us
Explore Courses
Become an Instructor
Support Us
Course Bundles New
Contact Us
Join Our Developer
Create Bundle New
Blog
Privacy Policy
Home
Explore Courses
Course Bundles New
Certificate Verification New
Create Bundle New
Become an Instructor
Blog
Join Our Developer
Contact Us
About Us
Support Us
Privacy Policy
Video Intro

Financial Analysis & Modelling with Microsoft Excel – Complete Course

A course by Awesome Emmanuel, Finance

English
Reviews 99% Positive Reviews (20)
Students 2449 Students

This course teaches how to use Ms. Excel to evaluate businesses, projects, budgets, and other finance-related transactions to determine their performance and ...

Video Intro

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.

Expand all
Lesson Video Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions)
16 lectures
Lesson Video Financial Analysis & Modelling Part 2 (Advance Analytical Functions)
7 lectures
Lesson Video Financial Analysis & Modelling Part 3 (Financial Functions & Analysis)
6 lectures
Lesson Video Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards)
4 lectures
--

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.

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

Admin bar avatar
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 👏👏👏

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.

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

Admin bar avatar
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 👏👏👏

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.

₦4,200 NGN
70% Disc. ₦13,900

1day 4hours left

Course features

  • Video 64 Lessons(7 Hours)
  • Access Lifetime access to course
  • Students 2449 Students
  • Skill level Skill level : All Levels
  • Certificate Certificate : Yes
  • Rated 4.8 Rated: 4.8
Author image
Awesome Emmanuel
Finance
| Rating StarStarStarStarStar
See Other courses from the instructor
Certificate preview

1day 4hours left

4,200 13,900

Get latest Updates & News

These are pillars that trusted and support our vision and mission

Select your currency