Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data. In Excel, functions are simple formulas you ...

There are many ways to find and retrieve data from a table or range based on a lookup value. In fact, because Microsoft often comes up with new, modernized alternatives, there are too many ways! So, ...

If you would like to follow along in using these functions, you can download this Excel workbook and view the video at the end of this item. Let’s do some examples to see how these functions work. We ...