Join Aaron Quigley for an in-depth discussion in this video Loan payment calculator, part of Office for Students.
As students, you're not just focused on learning new things in the classroom.…But you're also trying to figure out how to run life outside of the classroom.…Microsoft Excel is a great tool to use both in class as well as out of class.…In this video we're going to talk about…how we can use Microsoft Excel to streamline…some of the financial things that we need to take care of on a daily basis.…The first thing we're going to look at is how…to make a loan calculator inside of Microsoft Excel.…As students, you might be thinking about student loans or…even possibly getting a credit card.…But before you make those decisions it's a great idea…to build a simple loan calculator so that you can figure…out how much you need, how much your payments are going to…be, and what it's ultimately going to cost you in the end.…
Here, I have a loan calculator set up that has three different inputs.…It has the initial loan amount, the interest rate.…As well as the number of months I'm going to repay it.…For example, if I was going to get a student loan that was $20,000.…
Are you a teacher? Try our companion course, Office for Educators.
- Creating assignment templates
- Tracking changes and adding notes
- Creating bibliographies and citations
- Presenting in PowerPoint with SlideShare
- Using Excel to manage data
- Keeping school and personal email organized in Outlook
- Setting up a calendar
- Using SkyDrive to back up papers and assignments