Excel for Finance and Accounting Expert Tutorial

Excel for Finance and Accounting Expert Tutorial

Get Ad-Free Training by becoming a member today!

Who it's for: Professionals using Excel to tackle practical tasks around financial data.

What it is: Microsoft’s spreadsheet application used to clean, organize, and present data.

What you'll learn: This course begins with a brief Excel refresher before moving on to a series of Finance and Accounting tips to improve your day-to-day workflow. First, we’ll explore common functions like NPV, IRR, and IPMT. Then, you’ll learn how to create a variety of charts to visually represent your data like stock charts, area charts, and even football field charts. Next, you’ll refamiliarize yourself with some key Excel tools like Pivot Tables to maximize your time in the application. Finally, we’ll show you how all of this works in the real world with comprehensive exercises around income statements, balance sheets, cash flow statements, and much more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:

For Private Group Trainings please visit:

Username: manuals
Password: password

Start 0:00
Introduction 0:09
Building Data Rates 1:20
Calculating HPR Rates of Return 4:23
Statement Model 10:39
Income Statements 12:29
Operating Costs 21:06
Operating Expenses and Interest 24:57
Taxes 26:47
Net Income 28:47
Capital Expenditure and Depreciation Schedule 31:27
Setting Up Balance Sheets 37:11
Balance Sheet Forecasts 40:33
Cash Flow Statements 54:15
Statement Model Check 1:04:21
Conclusion 1:06:22

#excel #exceltutorial #exceltips #exceltricks

(C) 2024 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[saieb]

Top notch courses, especially this one. Thank you!

[Saadat_Khan]

This would be more helpful if you build another financial model from scratch related to food industry like restaurant or a super store etc. In this way we learners will have more in-depth financial skills in more industries or businesses.

[Dhaanikitchen]

Thank you so much for your great service. please teach us about filmora video editing....

[lifequotes]

I followed your exercise, but why are the calculation results not the same when making a summation =SUM(B6:B8)?

[ritikpaswan]

Hey can you upload financial modelling course for free on YouTube?

[QamruddinKhan-hfdn]

How much maths needed to learn Excel? Just basic high school will be sufficient?

[mohdfaisal]

Learnit Training used to be free of cost now why is this paid?

[rathnaofficial]

Lesson about programming languages please 😭🤍