Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Among these, the INDEX & MATCH formulas stand out as incredibly versatile tools for data lookup and retrieval. Learn how to use Excel’s INDEX and MATCH formulas to perform advanced lookups and ...

Microsoft’s making Excel’s formulas even easier The company is adding some handy automation features to its web-based spreadsheet software.

Learn about the weighted average cost of capital (WACC) formula in Excel and use it to estimate the average cost of raising funds through debt and equity.

What Is the Relative Strength Index (RSI)? Relative Strength Index Formula How to Calculate a Stock’s Relative Strength Index How to Calculate RSI on a Spreadsheet (Example: Netflix) How to ...

The difference is your overall profit, in this example the formula result would be $17. Input a formula in the final column to calculate the profit margin on the sale.

You can show or hide list of formulas while typing in Excel with the help of a shortcut key. Press Alt+Down arrow or make it invisible.