New content every week on this site and on social media
Recent posts
How to Use the TRIMRANGE Function in Excel
Microsoft Excel has recently rolled out a new function, TRIMRANGE. And as its name suggests, it will help you trim a range, to ensure that your formula is effi ...
Free Google Sheets Calendar Template to Track Bills and Events
Want to track events, bills, and tasks easily? Rather than using different apps, you can do all of that right within Google Sheets. Whether you're using your h ...
How to Create Dynamic Min-Max Range Charts in Excel
A good chart in Excel can display a lot of useful information in one visual. In this example, I'm going to show you how to display minimum and maximum values, ...
How to Create a Word Cloud in Excel With Python
In Microsoft 365, you can now use python to help you analyze and summarize data. And one of the cool things you can do is to create a word cloud. A word cloud ...
Highlight the Largest Values in Excel With Conditional Formatting
Microsoft Excel can help you analyze data, even without having to do any computations. By simply setting up conditional formatting rules, you can easily visual ...
2025 Stock Trading Template
If you want to track your investments and stay on top stocks in a watchlist, I've created a template which will make that easy to do. My 2025 Stock Trading Tem ...
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 ...