Excel 2019: Discover New Functions by Using fx
July 18, 2019 - by Bill Jelen
There are 400+ functions in Excel. Instead of taking 450 pages to describe every function, I am going to teach you how to find the function that you need.
The Excel 2007 formulas tab introduced a huge fx Insert Function icon. But you don’t need to use the one on the Formulas tab; the same icon has been to the left of the formula bar ever since I can remember.
If you are trying to figure out how to calculate a loan payment, the Insert Function dialog will help. Click the icon next to the formula bar. In the Search for a Function box, type what you are trying to do. Click Go. The Select a Function box shows functions related to your search term. Click on a function in that box to see the description at the bottom of the dialog.