Watch this video to learn how to combine the offset function with a combo box.  This will make it easy to retrieve the desired value from your data.

Continue reading →

Learn how to retrieve a value or several values using Microsoft Excel’s offset function. Offset is one of my favorite functions due to it’s flexibility. Continue reading →

What’s the difference between Compound Interest and Simple Interest?

I know that there’s a difference but I often forget the details so I created this video for you and for me! Continue reading →

Calculate the future value of your money in Microsoft Excel using the Future Value function. Continue reading →

Learn how to use Excel’s various count functions to count numbers, blanks, non blanks and how to conditionally count (count if a condition is met). Continue reading →

Excel’s vlookup function is the most common lookup function. It’s often used in job interviews as bare minimum proof of Excel knowledge.

Are you using vlookup correctly?
Continue reading →

Advanced uses of the SUMPRODUCT function including how to incorporate “this or that” logic. Continue reading →