Excel Spreadsheets Help

The 2019 holiday season is officially upon us here in the United States which means it’s time for my annual gift giving guide. I used to pa...

Did you know there is a term for the two letters that follow the number of a date? You know, the "st" in 1st; the "nd" ...

The 2019 college football season is here! Sorry, I had some trouble with the macro I setup to automatically help in the creation of this sp...

Sorry this took a bit longer than I was expecting it to but now available to download is the 2019 NFL helmet schedule spreadsheet. You’ll s...

I recently received a question about how to hide or collapse a row if a checkbox in that row wasn’t checked. There are a lot of good lesson...

One of my most popular articles is where I showed how to create a hyperlink in an Excel spreadsheet that when clicked composes an email mes...

Today I'm going to show you how to use the OFFSET function combined with Index and Match to find the values of diagonal cells in a tab...