From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Insert Function for learning about unfamiliar functions

Insert Function for learning about unfamiliar functions

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

Insert Function for learning about unfamiliar functions

“

- Imagine that you're about to borrow some money, $25,000. The interest rate is 3.50%. You want to pay off the loan. 48 payments, four years. And we need to use a function here unless you know the complicated mathematics behind calculating the answer here, and let's say that you've already discovered by way of the Financial tab that the function you need is PMT. Now, the description here gives you some information. Tell me more will activate the help system. Doesn't quite take us to where we want to. We could in the search panel here type in PMT, enter, and get some help. We still have to go a bit further here to hone in on this particular function, and we could print this too. This works for some people. It might provide you with just the information you need, but sometimes that's not good enough. Another approach here is the Insert Function button, and you'll see this on the extreme left side of the Formulas tab up in the ribbon, and you'll also see it right here next to the formula…

Contents