# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# COUNTIFS

## How to Count Cells That Contain Specific Text

| October 25, 2022 |

Have you ever wanted to see how many times a certain text string pops up in a set of data? While you can use Ctrl + F to find values, you may need a search feature that’s more discerning and responsive.  Luckily, there are several (much faster!) ways you can count cells that contain specific…

## How to Highlight Duplicates in Excel

| July 26, 2022 |

A duplicate value is a value that shows up more than once in a spreadsheet. These pop up all the time when working with datasets, and they can be tedious to sort through if you don’t know the quick ways to find them. Learn how to highlight duplicates in Excel to make the process take…

## How to Use Excel for Finance: Balancing Your Personal Budget

| June 7, 2022 |

Want to know how to use Excel for finance & budgeting? Here’s how to create a customizable budget that accurately tracks income and expenses.

## Excel Formulas Cheat Sheet for Beginners

| May 17, 2022 |

Excel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help…

## Count Between Dates

| March 4, 2020 |

Let’s say you measure something with a duration that can span multiple days. For example, a hotel guest can check in for multiple days, a patient can be in a hospital for multiple days, a widget can be in a specific manufacturing stage for multiple days, a book can be checked out for multiple days,…

## Sum a Column Based on Values in Another

| May 22, 2019 |

In this post, we’ll learn how to add up a column of numbers based on the values in another column. For example, we are trying to analyze product sales based on average customer rating. That is, customers rate our products on a scale of 1 to 10, and so each product has an average rating…