Excel for Finance and Accounting - Intermediate Tutorial

Dive into an intermediate-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 key Excel tools such as Pivot Tables to enhance productivity, and apply newly acquired skills to real-world scenarios involving income statements, balance sheets, and cash flow statements. Cover topics ranging from date and time functions, data validation, and lookup functions to goal seek, scenario manager, and loan schedule calculations. Gain practical knowledge to improve day-to-day workflow and efficiently handle financial data in Excel.

Start
Introduction
Date and Time Functions
Data Validation
VLOOKUP
INDEX and MATCH
XLOOKUP
Goal Seek and Scenario Manager
PV and FV
NPV
XNOV
IRR
Loan Schedule with PMT
PPMT
IPMT
CUMIPMT
Loan Schedule Templates
Conclusion