Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel for Finance and Accounting: Expert Tutorial

Learnit Training via YouTube

Overview

Dive into an expert-level tutorial on Excel for finance and accounting professionals. Master essential functions like NPV, IRR, and IPMT, and learn to create various charts including stock, area, and football field charts to visually represent financial data. Explore the power of Pivot Tables to streamline workflows, and apply these skills to real-world scenarios involving income statements, balance sheets, and cash flow statements. Enhance your Excel proficiency with practical exercises and comprehensive examples tailored for financial analysis and reporting.

Syllabus

Start
Introduction
Building Data Rates
Calculating HPR Rates of Return
Statement Model
Income Statements
Operating Costs
Operating Expenses and Interest
Taxes
Net Income
Capital Expenditure and Depreciation Schedule
Setting Up Balance Sheets
Balance Sheet Forecasts
Cash Flow Statements
Statement Model Check
Conclusion

Taught by

Learnit Training

Reviews

Start your review of Excel for Finance and Accounting: Expert Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.