Главная
Study mode:
on
1
Start
2
Introduction
3
Date and Time Functions
4
Data Validation
5
VLOOKUP
6
INDEX and MATCH
7
XLOOKUP
8
Goal Seek and Scenario Manager
9
PV and FV
10
NPV
11
XNOV
12
IRR
13
Loan Schedule with PMT
14
PPMT
15
IPMT
16
CUMIPMT
17
Loan Schedule Templates
18
Conclusion
Description:
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.

Excel for Finance and Accounting - Intermediate Tutorial

Learnit Training
Add to list
0:00 / 0:00