Mastering Excel. . . . For Beginners: #2 Loan Payment Calculator | Joel Whitmer | Skillshare

Mastering Excel. . . . For Beginners: #2 Loan Payment Calculator

Joel Whitmer, Try New Things. You Just Might Like It.

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
5 Videos (38m)
    • Relative and Absolute

      6:12
    • IF and AND Functions (1)

      9:29
    • IF and AND Functions (2)

      5:28
    • Car Loan Project (1)

      7:34
    • Car Loan Project (1)

      9:17

About This Class

In this class we will learn about the difference between relative and absolute references. We will also learn some new functions like =IF(), =AND(), and =PMT().

The class project will be a loan payment calculator that will tell you your monthly payment depending on different loan amounts. It will also tell you how much is going to interest and principle. This will be a great tool in your home to help you manage and prepare for any loan you might have!

10

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Joel Whitmer

Try New Things. You Just Might Like It.

My name is Joel. I'm a structural engineering living in the wonderful state of Utah! I'm passionate about learning and love to try new things, which is why I'm branching out and learning to teach! I think it's important for everyone to learn new skills in life whether you end up using them or not. They help shape who we are!

Everything deserves to be tried once. . . . . . well. . . . .most things. . . . . actually just a lot of things. (I don't condone trying illegal things.)

<...

See full profile

Report class