Master essential Excel skills for finance and accounting in this comprehensive 57-minute beginner tutorial. Begin with a quick Excel refresher before diving into finance-specific functions like NPV, IRR, and IPMT. 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 streamline your workflow. Apply your new skills to real-world scenarios involving income statements, balance sheets, and cash flow statements. Cover topics ranging from basic data entry and formatting to advanced functions like IF statements, SUMIF, AVERAGEIF, and COUNTIF. Gain practical knowledge on using LEFT, RIGHT, MID functions, and Flash Fill for efficient data manipulation. Perfect for professionals looking to enhance their Excel proficiency in finance and accounting tasks.
Excel for Finance and Accounting - Beginner Tutorial