Excel for Finance and Accounting Full Course
This course covers essential Excel functions, charts, and tools for Finance and Accounting, with real-world exercises on income statements, balance sheets, and cash flow statements to enhance your workflow.
About the Course:
This course is designed to enhance your finance and accounting skills using Excel. It begins with a quick refresher on key Excel functions, then dives into advanced techniques such as NPV, IRR, and IPMT. You’ll also learn how to create various charts, like stock and area charts, to visually represent data. The course covers powerful Excel tools like Pivot Tables to improve efficiency and includes practical exercises on income statements, balance sheets, and cash flow statements to apply your learning to real-world scenarios. Perfect for anyone looking to streamline their financial analysis in Excel.
- Introduction to Excel and basic data entry
- Formatting, conditional formatting, and freeze panes
- Using basic functions, IF statements, and COUNTIF
- Date and time functions, VLOOKUP, INDEX, MATCH, and XLOOKUP
- Goal Seek, Scenario Manager, PV, NPV, and IRR
- Loan schedules, PMT, PPMT, IPMT, and CUMIPMT
- Creating bar, pie, combo, waterfall, and football field charts
- Working with pivot tables, pivot charts, sorting, and filtering
- Regression analysis and stock charts
- Building financial statements, income statements, and balance sheets
- Cash flow statements and capital expenditure management
