Want to get better at Excel?
This site will help you...
New content every week on this site and on social media
Recent posts
How to Fix a Pivot Table That Is Not Refreshing
Is your pivot table not updating even though you're refreshing the data? If that's the case, that usually means there's a problem with the data that your pivot ...
How to Do a Lookup in Excel With Multiple Criteria
A VLOOKUP function in Excel can be an effective and easy way to pull in a value from a list. But what if you needed to base your lookup on multiple values? You ...
Free 2025 MLB Playoff Template for Excel
The MLB playoffs are approaching and I have created a template for you to track the games and also make predictions. The playoff picture and standings are as o ...
Create Google Sheets Conditional Formatting Rules Based on Another Cell
Do you want to create conditional formatting rules in Google Sheets that are linked to specific cells? Below, I'll show you how to do that, so that it's easy t ...
How to Create Conditional Formatting Rules in Excel: The Ultimate Guide
Conditional formatting in Excel is one of the most powerful tools for making your spreadsheets more insightful and easier to read. Instead of manually scanning ...
How to Calculate RevPAR in Excel Using a Formula
Revenue per Available Room (RevPAR) is one of the most important metrics in the hospitality industry. It tells hotel owners and investors how efficiently a pro ...
How to Setup Advanced Conditional Formatting Rules in Excel Using Formulas
Conditional formatting rules can help highlight values and identify when certain criteria is met. You can also create advanced rules that include formulas. And ...
NFL Schedule and Prediction Template in Excel (Free)
The NFL season is approaching and I have created a free template in Excel that will make it easy to keep track of your favorite teams. You can also use it to m ...