Excel - Entering Functions using the Function Arguments Dialog - Episode 409
1,969 views · Published 5 October 2009 · 3:09 · Indexed 4 November 2026
Channel: MrExcel.com · 2009 · Education
Microsoft Excel Tutorial: Using Function Arguments Dialog for Loan Payments. Welcome to another episode of the MrExcel netcast, where we explore the endless possibilities of Excel. In today's video, we will be diving into the Function Wizard and how it can help us calculate loan payments for a new car or house. So if you're stuck at work on this last day before Christmas, take a break and join me as we discover new functions in Excel. One of the most useful features in Excel is the Function Wizard, located right next to the formula bar. By clicking on the Fx button, you can search for the specific function you need to solve a problem. In our case, we want to calculate a car payment, so we type in our search and Excel suggests a few functions that could work. We choose the PMT function and the Wizard takes us through each step, providing helpful explanations for each argument. For example, the Rate argument is the interest rate per period for the loan. And the Nper argument is the total number of payments for the loan. With the help of the Wizard, we can easily input all the necessary information and get our car payment amount. But what if we want to play the What-If game and see how changing the price, term, or rate affects our payment? Well, Excel has a solution for that too. Before we get into the holiday spirit, here's a bonus tip for you. If you want to immediately back into a certain value, you can use the Goal Seek feature. Simply go to Tools, Goal Seek, and set the cell you want to change and the cell you want to set it to. Excel will then calculate the exact number needed to reach that value. And the best part is, all the formulas are still live, so you can continue to make changes and see the results. So if you're in the market for a new car this holiday season, use this Excel trick to negotiate a better deal. And don't forget to join me again on Wednesday for another netcast. Thank you for watching and happy holidays!" Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction (00:24) Excel's usefulness in financial planning (00:35) Using the Fx button to discover new functions (00:51) Searching for the PMT function (01:05) Step-by-step guide to building the formula (01:30) Understanding the arguments (01:44) Checking the result and using the What-If game (02:07) Bonus tip: Using Goal Seek to back into a desired value (02:36) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Backing into a certain value in Excel Changing numbers in live formulas in Excel Excel car payment calculation Help for Rate argument in Excel Holiday netcast schedule for MrExcel Negotiating a better deal for a new car PMT function in Excel Present value in Excel loan calculation Required and optional arguments in Excel functions Step-by-step formula building in Excel Using Fx button in Excel Using Goal Seek in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152671/ Learn how to use a simple English-language query in order to discover new functions. Episode 409 will show you how to find a function to calculate a monthly car payment. You can also use the Goal Seek function to immediately back into an answer. This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920