Excel for Finance and Accounting - Beginner Tutorial

Overview

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.

Syllabus

Start
Introduction
Introduction to Excel
Data Entry Basics
Rows and Columns
Open, Save, and Print
Formatting Basics
Formatting in Cells
Conditional Formatting
Freeze Panes and Split Screen
Quick Access Toolbar and Keyboard Shortcuts
Basic Functions
IF Statements
SUMIF and AVERAGEIF
LEFT, RIGHT, MID, and Flash Fill
COUNTIF and COUNTIFS
Conclusion