Excel's VLOOKUP function lets you find data in columns in reference to the first column. Learn how to create it manually or build it easily.

The PMT function in Excel is a financial function used to calculate a loan's payment based on payments and interest rates. Learn How to use it.

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

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, data summaries created via PIVOTBY automatically update to reflect ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel.

How to Calculate Depreciation Using Excel. Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function ...

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.