Financial Analysis & Modelling with Microsoft Excel - Complete Course

Financial Analysis & Modelling with Microsoft Excel – Complete Course

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

4.8

(10 reviews)

2345 students enrolled

Financial Analysis

Awesome Emmanuel

3days 9hours left

₦4,200

70%

~~₦13,900~~

Course Features

64 Lessons(7 Hours)

2345 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: 4.8

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

Rate our course

☆ ☆ ☆ ☆ ☆

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. 💪

FREQUENTLY ASKED QUESTIONS

Are the videos downloadable?

The videos are highly compressed and downloadable.

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.

Reviews

See all

Nasiru Muhammed

Mallam 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

Financial Analysis & Modelling

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

Financial Reporting

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

Financial analysis and modeling

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

Course 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 :)

Course content

Expand all

Financial Analysis & Modelling Part 1 (Introduction & Basic Analytical Functions)

16 lectures

1.0 Introduction & Overview

1 minute

1.1 Introduction to Excel

12 minutes

1.2 Formatting

8 minutes

1.3 Percentage Calculation

8 minutes

1.4 Basic Calculation

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

2.0 Introduction & Overview

1 minute

6 minutes

3 minutes

12 minutes

17 minutes

2.20 Power Query (Transforming 1)

5 minutes

2.21 Power Query (Transforming 2)

7 minutes

Financial Analysis & Modelling Part 3 (Financial Functions & Analysis)

6 lectures

3.0 Introduction & Overview

1 minute

3.22 Present Value (PV)

6 minutes

3.23 Future Value (Compounding Frequencies)

9 minutes

3.24 PMT (Loan Monthly Payment)

7 minutes

3.25 Amortization Table

4 minutes

3.26 Internal Rate of Return

12 minutes

Financial Analysis & Modelling Part 4 (Financial Statements & Model)

8 lectures

4.0 Introduction & Overview

1 minute

4.27 Profit Loss Statement Pt 1

14 minutes

4.28 Profit Loss Statement Pt 2

10 minutes

4.29 Profit Loss Statement Pt 3

22 minutes

4.30 Balance Sheet

9 minutes

4.31 Three Statement Financial Model Pt 1

9 minutes

4.32 Three Statement Financial Model Pt 2

22 minutes

4.33 Financial Ratios

19 minutes

Financial Analysis & Modelling Part 5 (Sales Reporting & Financial Dashboards)

4 lectures

5.0 Introduction & Overview

1 minute

5.34 Sales Reporting (Dashboard) Pt 1

19 minutes

5.35 Sales Reporting (Dashboard) Pt 2

18 minutes

5.36 Sales Reporting (Dashboard) Pt 35.36 Sales Reporting (Dashboard) Pt 3

31 minutes

Financial Analysis & Modelling Part 6 (Financial Analysis and Forecasting)

9 lectures

6.0 Introduction & Overview

1 minute

6.37 Trend Analysis

14 minutes

6.38 Comparative Analysis

18 minutes

6.39 Regression Analysis Pt 1 (Relationship)

16 minutes

6.40 Regression Analysis Pt 2 (Forecasting)

10 minutes

6.41 What If Analysis (Data Table) Pt 1

7 minutes

6.42 What If Analysis (Data Table) Pt 2

8 minutes

6.43 What If Analysis (Scenario Manager n Goal Seek) Pt 3

11 minutes

6.44 Forecasting

9 minutes

Financial Analysis & Modelling Part 7 (Financial Modelling)

14 lectures

7.0 Part 7 Intro (Financial Modelling)

5 minutes

7.45 Financial Modelling pt1 (Facts & Findings)

9 minutes

7.46 Financial Modelling pt2 (Monthly Revenue 1)

13 minutes

7.47 Financial Modelling pt3 (Monthly Revenue 2)

13 minutes

7.48 Financial Modelling pt4 (Monthly Revenue 3)

12 minutes

7.49 Financial Modelling pt5 (Monthly Revenue 4)

16 minutes

7.50 Financial Modelling pt6 (Monthly P&L 1)

7 minutes

7.51 Financial Modelling pt7 (Monthly P&L 2)

15 minutes

7.52 Financial Modelling pt8 (Capital Structure)

5 minutes

7.53 Financial Modelling pt9 (Fixed Asset Schedules)

16 minutes

7.54 Financial Modelling pt10 (Working Capital)

17 minutes

7.55 Financial Modelling pt11 (Annual P&L)

16 minutes

7.56 Financial Modelling pt12 (Cash Flow Statement)

7.57 Financial Modelling pt13 (Balance Sheet)

12 minutes

Student Feedback

4.8

10 reviews

80%

20%

Reviews

Nasiru Muhammed

Mallam Nasiru Muhammed

Alfred Lungu

Financial Analysis & Modelling

Suleiman Tambaya

Financial Reporting

Misozi Nyirenda

Financial analysis and modeling

Gabriel Otieno

Course 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

financial analysis & modelling with Excell

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

Great job

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

Financial Analysis & Modelling with Microsoft Excel - Complete Course

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

Financial Analysis & Modeling

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

Financial Analysis & Modelling

This course gave me a different view about excel and has increase my knowledge in data analysis from a financial standpoint.

3days 9hours left

₦4,200

70%

~~₦13,900~~

Course Features

64 Lessons(7 Hours)

2345 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: 4.8