An Excel Trick To Quickly Increment Dates For Each Row

You’ve probably found yourself in a position at some point or another where you needed to create a bunch or rows with dates that increased/decreased by a fixed amount for each row. You could spend your valuable time entering them manually or use this oldie but goodie click-and-drag trick to fill in those dates in seconds. Make sure your column is formatted for dates and enter the increment you need to use. In this example, I want each row to decrease by one day. Highlight both cells and look for a tiny … Read more

A Quick Solution To The Problem Of Missing Credit Card Receipts

We’ve all been there, on one end of the conversation or the other: it’s the end of the month and the finance team is missing receipts for charges on company credit cards. Cardholders get a list of undocumented purchases and begin the scavenger hunt. Some are easier to find and forward to bookkeeping, such as online purchases that had an email receipt. Perhaps it was a recurring charge for some software or other subscription; that too should have either an email receipt or documentation available for download from the provider’s website. Some … Read more

A Smarter Way To Crumble Browser Cookies

Clearing browser cookies is just one of those things you need to do every now and then but clearing them out in bulk can be a serious hassle, such as losing all of your saved login info. 🤬 Fortunately, there’s been a multi-step trick to use for clearing cookies on a per-URL basis but after years of consistency, the most recent Google Chrome update has changed the process (for the better). This is so useful, I recommend keeping it at the top of your bookmark list and if you use a bookmark … Read more