New content every week on this site and on social media
Recent posts
Dynamic Conditional Formatting: How to Link Rules to Specific Cells
If you want to create conditional formatting rules but want to easily change the cutoff values for them, you can link your rules to specific cells, to make tha ...
2025 Prepaid Expenses Template
Excel can help you reconcile your accounts and prepaids with ease. And below, I'm going to go over an updated version of my prepaid expenses template. This new ...
Use Excel’s Image Function to Populate Logos
The IMAGE function in Excel is one of the newer ones you can use. And it can make importing images into your spreadsheet a whole lot simpler than saving, uploa ...
How to Create Excel Charts to Visualize Variances in Stock Performance
If you want to compare and contrast between two sets of values, a chart can help you accomplish that. In this post, I'm going to show you how you can compare m ...
How to Create a Stock Heat Map in Google Sheets
Heat maps can help you easily identify high and low values. You'll often find them to display stock prices to show which stocks did well, and which ones didn't ...
Free Calendar and Task Manager Template
It's a new year and with the help of a good calendar, you can ensure you stay on top of not only your deadlines and tasks but goals as well. I have a free temp ...
How to Autofill in Excel: A Step-by-Step Guide
Autofill is one of Excel's most powerful tools, helping you quickly and efficiently populate cells with data, formulas, or patterns. Whether you're entering da ...
How to Fix #N/A Errors in Excel
Excel is a powerful tool, but even the most experienced users encounter errors like #N/A from time to time. This error can be frustrating, but it’s actually Ex ...