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
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 →
Learn how to hide rows using Excel’s FILTER feature. 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 →
Watch this video to learn how Microsoft Excel handles dates and times.
Also, learn how to find errors in your date values. Continue reading →