Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group. Continue reading
Requirement: Identify all items within a group if any of the items in that group meet a condition.
Solution: I use functions VLOOKUP, AND to identify rows if a condition is met within the same group. Continue reading →
Learn how to add numbers in Microsoft Excel using these functions: SUM, SUMIF, SUMIFS. Continue reading →
Use Excel’s data validation feature to restrict values that can be entered into cells.
Data validation can save you hours of data cleanup work! Continue reading →
A hyperlink is an easy way to jump from one location to another location. The destination could be to the same workbook, an external workbook or a website.
There are two ways to create a hyperlink in Microsoft Excel: Continue reading →
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.
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 group a column of dates by Year & Month and sum another field.
Excel’s pivot table ‘Group’ feature only takes a few clicks of the mouse and can save so much time! Continue reading →
Learn how to exclude data from a pivot by using a report filter. Continue reading →