HowtoExcel.net
cropped-h2e100x100.png

HowtoExcel.net

Analytics. Automation. Process Improvement.

  • Home
  • Blog
  • Templates
  • Tools & Calculators
    • Average Down Calculator
    • Compounded Annual Growth Rate Calculator
    • Inflation Calculator
    • Investment Growth Calculator
    • Live T-Account Template
    • Minimum Payment Calculator
    • Money Spent Calculator
    • Mortgage Payment Calculator
    • Mortgage Payment Calculator — Interest Rate Sensitivity
    • Mortgage Payment Sensitivity Calculator
    • Price-to-Earnings P/E Calculator
    • Stock Average Calculator
    • Time Spent Calculator
  • Shop
  • Cart
  • Contact Me

Home

All posts by : howtoexcel

maxresdefault (1)

How to Do a Lookup in Excel With Multiple Criteria

September 30, 2025
by howtoexcel

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 could use helper columns to try and achieve that, but there's another way you can do so, ...

Read More
MLB Playoff Template in Excel.

Free 2025 MLB Playoff Template for Excel

September 27, 2025
by howtoexcel

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 of today's date, Sept. 26. However, I will update them at the end of the season and make an ...

Read More
maxresdefault

Create Google Sheets Conditional Formatting Rules Based on Another Cell

September 23, 2025
by howtoexcel

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 to update, maintain, and see what conditional rules you have setup. This avoids having to s ...

Read More
The conditional formatting menu in Excel.

How to Create Conditional Formatting Rules in Excel: The Ultimate Guide

September 11, 2025
by howtoexcel

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 rows of numbers or text, conditional formatting automatically highlights the most importa ...

Read More
RevPAR

How to Calculate RevPAR in Excel Using a Formula

September 9, 2025
by howtoexcel

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 property is generating revenue from its available rooms. Whether you manage a small motel or ...

Read More
Advanced Conditional Formatting Rules

How to Setup Advanced Conditional Formatting Rules in Excel Using Formulas

September 5, 2025
by howtoexcel

Conditional formatting rules can help highlight values and identify when certain criteria is met. You can also create advanced rules that include formulas. And I'll walk you through how to to do so in a way where it's easy to test your logic and ens ...

Read More
NFLTemplate4

NFL Schedule and Prediction Template in Excel (Free)

August 21, 2025
by howtoexcel

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 make predictions and compete against your friends and colleagues. Here's a look at how the ...

Read More
ParetoChart

How to Make a Pareto Chart in Excel

August 12, 2025
by howtoexcel

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—which suggests that roughly 80% of outcomes come from 20% of causes. While that may not always ...

Read More
EPL Template

English Premier League Prediction Template in Excel and Google Sheets (Free Download)

August 5, 2025
by howtoexcel

UPDATE: 8/20: Scores Will Now Update Periodically Are you looking for a free English Premier League Prediction Template to track matches, make weekly predictions, and see how your forecasts stack up against your friends'? This all-in-one spreadsh ...

Read More
H2EThumbnail AltmanZScore

How to Calculate the Altman Z Score in Excel

July 29, 2025
by howtoexcel

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 terms, it produces a single number (“Z-score”) that helps predict the probability that a comp ...

Read More
cropped-h2e100x100.png

HowtoExcel.net

Analytics. Automation. Process Improvement.

© 2019 Company. All rights reserved.  Powered by  Phlox Theme

Shopping Basket
Contact me for help!

HowtoExcel.net

  • Home
  • Blog
  • Templates
  • Tools & Calculators
    • Average Down Calculator
    • Compounded Annual Growth Rate Calculator
    • Inflation Calculator
    • Investment Growth Calculator
    • Live T-Account Template
    • Minimum Payment Calculator
    • Money Spent Calculator
    • Mortgage Payment Calculator
    • Mortgage Payment Calculator — Interest Rate Sensitivity
    • Mortgage Payment Sensitivity Calculator
    • Price-to-Earnings P/E Calculator
    • Stock Average Calculator
    • Time Spent Calculator
  • Shop
  • Cart
  • Contact Me