Excel for Finance and Accounting: Expert Tutorial

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