Completed
XLOOKUP
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel for Finance and Accounting - Full Course Tutorial
Automatically move to the next video in the Classroom when playback concludes
- 1 Start
- 2 Introduction
- 3 Introduction to Excel
- 4 Data Entry Basics
- 5 Rows and Columns
- 6 Open, Save, and Print
- 7 Formatting Basics
- 8 Formatting in Cells
- 9 Conditional Formatting
- 10 Freeze Panes and Split Screen
- 11 Quick Access Toolbar and Keyboard Shortcuts
- 12 Basic Functions
- 13 IF Statements
- 14 SUMIF and AVERAGEIF
- 15 LEFT, RIGHT, MID, and Flash Fill
- 16 COUNTIF and COUNTIFS
- 17 Conclusion
- 18 Introduction
- 19 Date and Time Functions
- 20 Data Validation
- 21 VLOOKUP
- 22 INDEX and MATCH
- 23 XLOOKUP
- 24 Goal Seek and Scenario Manager
- 25 PV and FV
- 26 NPV
- 27 XNOV
- 28 IRR
- 29 Loan Schedule with PMT
- 30 PPMT
- 31 IPMT
- 32 CUMIPMT
- 33 Loan Schedule Templates
- 34 Conclusion
- 35 Introduction
- 36 Bar Charts
- 37 Area Charts
- 38 Pie and Donut Charts
- 39 Combo Charts
- 40 Waterfall Charts
- 41 Football Field Charts
- 42 Sparklines
- 43 Pivot Tables
- 44 Pivot Charts
- 45 Sorting and Filtering
- 46 Regression Analysis
- 47 Analyze Data
- 48 Stock Charts
- 49 Purchase Price Variance
- 50 Conclusion
- 51 Introduction
- 52 Building Data Rates
- 53 Calculating HPR Rates of Return
- 54 Statement Model
- 55 Income Statements
- 56 Operating Costs
- 57 Operating Expenses and Interest
- 58 Taxes
- 59 Net Income
- 60 Capital Expenditure and Depreciation Schedule
- 61 Setting Up Balance Sheets
- 62 Balance Sheet Forecasts
- 63 Cash Flow Statements
- 64 Statement Model Check
- 65 Conclusion
