Excel for Finance and Accounting - Full Course Tutorial

Excel for Finance and Accounting - Full Course Tutorial

Learnit Training via YouTube Direct link

Setting Up Balance Sheets

61 of 65

61 of 65

Setting Up Balance Sheets

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.