# 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.

# SUMIFS

## Conditional Summing Tricks

| March 19, 2024 |

Learn how to handle conditional summing in Excel with these amazing but easy-to-understand tricks. These effective strategies will level-up your understanding and management of Excel functionalities.

## Excel How to Sum Values Between Dates

| October 24, 2023 |

This tutorial shows how to use the SUMIFS function to sum the amounts for records that fall between two dates. By the end of this tutorial, you will be able to enter the desired date range into two input cells, and have Excel immediately sum the values that fall between these dates, even if the…

## Excel How To Compare Two Columns (3 ways)

| July 18, 2023 |

Using Microsoft Excel to compare two columns is a great way to look for discrepancies or similarities between two different sets of data. This post provides 3 different ways to accomplish this so that you can use the one that is most appropriate for your data and workbook. Video Step-by-step guide Let’s work through each…

## Excel SUMIF Function

| April 18, 2023 |

In this post, we’re going to dive into one of the most useful techniques in Excel … conditional summing. We will discuss the SUMIF function, what it does, what its arguments are, and how it compares to SUMIFS, VLOOKUP, and COUNTIF. Video What the SUMIF Function Does So, what is SUMIF in Excel? SUMIF is…

## Even Pros Could Learn a Thing or Two From These 8 Advanced Excel Tips

| June 21, 2022 |

## 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.

## These Top Excel Skills are Surprisingly Easy to Learn

| May 24, 2022 |

You don’t need to be a spreadsheet pro to master these top Excel skills! See our list of easy-to-learn Excel skills with hands-on tutorials.

## 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…

## These Are the Top 9 Most Useful Advanced Excel Functions

| March 15, 2022 |

Looking to make work easier? Instead of trying to do it all, focus on learning these nine useful advanced Excel functions.