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