Microsoft Excel's XLOOKUP function is best known for retrieving a value from a certain row or column in a dataset. However, you can also use this powerful tool to perform two-way lookups ...

The DGET function in Excel is a Database function that extracts asingle record from a database. Learn how to use the DGET function in Excel.

If you'd like to isolate cells in a Microsoft Excel data sheet based on criteria that has a partial cell match, this can be done through the use of a MATCH function. When applied, the MATCH function ...

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.

Learning how to perform statistical data analysis in Microsoft Excel can help you improve your analytics and reporting. This guide takes you ...

If you need to perform an exponential calculation of numbers in a range of cells in Excel, this tutorial will show you how to do it in a few easy steps.

Microsoft Excel is a powerful spreadsheet program that can be used for a variety of tasks, including basic math. Here's how to use Excel as a calculator to perform basic arithmetic operations such ...