Excel For Personal Finance Tutorial

Excel For Personal Finance Tutorial

Learnit Training via YouTube Direct link

Conclusion 1:57:17

20 of 20

20 of 20

Conclusion 1:57:17

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel For Personal Finance Tutorial

Automatically move to the next video in the Classroom when playback concludes

  1. 1 Start 0:00
  2. 2 Introduction 0:09
  3. 3 Adding Expense Tables 1:38
  4. 4 Building a Simple Budget List 12:39
  5. 5 Building a Simple Budget Table 20:50
  6. 6 Linking Expense Tables into a Budget Table 29:34
  7. 7 Tracking Expenses with Drop-downs 38:12
  8. 8 Tracking Projected Costs vs Actual Costs 46:59
  9. 9 Track Percentage of Expenses 54:20
  10. 10 Creating Budget Charts 58:35
  11. 11 Visualizing Daily Expenses 1:08:19
  12. 12 Inserting Pivot Tables from Our Expense Tracker 1:14:04
  13. 13 Inserting Pivot Charts from Pivot Tables 1:20:09
  14. 14 Using the Timeline 1:26:57
  15. 15 Save Your Budget as a Template for Future Use 1:30:13
  16. 16 Calculate the Future Value of an Investment 1:35:49
  17. 17 Calculate Total Deposits and Interest 1:41:42
  18. 18 Calculate Monthly Payments for a Loan 1:45:49
  19. 19 Forecast Monthly Payments Based on Conditions 1:50:57
  20. 20 Conclusion 1:57:17

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.