Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

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

Functions of Different Categories in Excel. To analyze your company's payroll expenditures, you might create an Excel spreadsheet and use some of the functions in the Financial or Math ...

Excel provides the PRODUCT () function to calculate the original value by the percentage markup. Place your original value or cost into column A and label it with a description. Input the ...

The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell ...

The Excel BESELLI function is an Engineering function, and its purpose is to return the modified Bessel function in(x). Learn how to use it.

The purpose of the Bin2Hex engineering function in Excel is to convert a binary or decimal to hexadecimal. Learn how to use it properly.