Q:

# What are some useful advanced formulas for Excel?

A:

VLOOKUP allows you to browse a table for a particular cell value, and copy the contents of the cell a given number of columns beside it, explains Excel Easy. PMT allows you to calculate periodical payments, given a rate, amount of months to pay, starting value and future value.

## Keep Learning

There are various look up and reference functions in excel, but VLOOKUP, or vertical look up, allows you to search the leftmost column of a table for a specified value, returning a value in the same row, but a given number of columns to the right, explains Excel Easy. Variations include HLOOKUP, or horizontal look up, MATCH, INDEX and CHOOSE.

Similarly, PMT has various functions enabling you to calculate the parameters needed, such as RATE, NPER, PV and FV. PMT returns a calculated periodical payment based on the parameters specified above. RATE calculates the rate parameter of this function, given the others. NPER calculates the amount of months needed to pay off the PV, or present value, given the other parameters. PV calculates the initial amount to be paid with the other parameters. FV calculates the end value after the specified amount of payments, given the other parameters.

Sources:

## Related Questions

• A: Create an Excel template for monthly expenses by using the rows to list and tally expenses and the columns for each month of the year. The document require... Full Answer >
Filed Under:
• A: To merge columns in Microsoft Excel, utilize the CONCATENATE function, and create a merging formula. Add the designations of the cells that contain the des... Full Answer >
Filed Under:
• A: To freeze panes in Excel, select the rows or columns that you want to freeze, navigate to the View tab, click Freeze Panes, and choose Freeze Top Row, Free... Full Answer >
Filed Under:
• A: To unhide columns in Excel, open an existing worksheet, select a column adjacent to the hidden one, navigate to the Format menu, point to Hide & Unhide und... Full Answer >
Filed Under:
PEOPLE SEARCH FOR