New content every week on this site and on social media
Recent posts
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 ...
How to Make a Pareto Chart in Excel
A Pareto chart is a useful tool for identifying the most significant factors in a dataset. It’s based on the Pareto principle—also known as the 80/20 rule—whic ...
English Premier League Prediction Template in Excel and Google Sheets (Free Download)
UPDATE: 8/20: Scores Will Now Update Periodically Are you looking for a free English Premier League Prediction Template to track matches, make weekly predic ...
How to Calculate the Altman Z Score in Excel
The Altman Z Score is a financial formula that evaluates a company’s financial health by analyzing key balance sheet and income statement ratios. In simple ter ...
How to Do an 80/20 Sales Analysis in Excel
Marketers know that typically 80% of sales come from just 20% of customers, and by focusing on that group, you can gain valuable insights into your data. With ...