Dive into a comprehensive 4-hour tutorial designed for finance and accounting professionals looking to enhance their Excel skills. Learn essential functions like NPV, IRR, and IPMT, create various charts including stock and football field charts, and master tools such as Pivot Tables to streamline your workflow. Explore practical applications through exercises on income statements, balance sheets, and cash flow statements. Gain proficiency in data analysis, financial modeling, and advanced Excel techniques to boost productivity and effectiveness in handling financial data.
Excel for Finance and Accounting - Full Course Tutorial
Overview
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
Introduction
Date and Time Functions
Data Validation
VLOOKUP
INDEX and MATCH
XLOOKUP
Goal Seek and Scenario Manager
PV and FV
NPV
XNOV
IRR
Loan Schedule with PMT
PPMT
IPMT
CUMIPMT
Loan Schedule Templates
Conclusion
Introduction
Bar Charts
Area Charts
Pie and Donut Charts
Combo Charts
Waterfall Charts
Football Field Charts
Sparklines
Pivot Tables
Pivot Charts
Sorting and Filtering
Regression Analysis
Analyze Data
Stock Charts
Purchase Price Variance
Conclusion
Introduction
Building Data Rates
Calculating HPR Rates of Return
Statement Model
Income Statements
Operating Costs
Operating Expenses and Interest
Taxes
Net Income
Capital Expenditure and Depreciation Schedule
Setting Up Balance Sheets
Balance Sheet Forecasts
Cash Flow Statements
Statement Model Check
Conclusion
Taught by
Learnit Training
