New content every week on this site and on social media
Recent posts
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 ...
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 ...