This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint.

For many, the INDEX-XMATCH combination in Excel is the go-to method for retrieving a value from a dataset. However, you can also use this dynamic duo to perform two-way lookups, returning a value ...

While it’s convenient, it does have a limitation: It stops at the first matching value. There’s no way to browse for other matching values in the same column.

The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days.

Thanks -- and Fool on! The article How to Calculate Intrinsic Values of Shares in Excel originally appeared on Fool.com. Try any of our Foolish newsletter services free for 30 days .