# 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

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

Read More

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

| June 21, 2022 |

Looking for some advanced Excel tips to help you become a spreadsheet pro? We’re sharing 8 tips that will take your skills to the next level!

Read More

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

Read More

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

Read More

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

Read More

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

Read More

## What Excel Skills are Employers Looking For in 2022?

| March 1, 2022 |

Need Excel skills for work? Save time job searching by finding out exactly what Excel skills employers are looking for.

Read More

## Mapping Table without a Helper Column

| September 7, 2021 |

A mapping table is a handy way to automatically translate labels between systems and reports. As with just about anything in Excel, there are many ways to implement a mapping table. For example, we could create a helper column to store the amounts with the SUMIFS function as I discussed in this Journal of Accountancy…

Read More

## Treasure Maps 1

| October 13, 2020 |

This is the first post in the Treasure Maps series, where we’ll be discussing the treasure (efficiency) that can be achieved by using mapping tables. Let’s review the big picture before jumping into the mechanics. Let’s say we export some data from a system, and it looks something like this (we’ll call this Point A):…

Read More

## FILTER vs VLOOKUP, INDEX/MATCH, XLOOKUP, SUMIFS

| October 8, 2020 |

In this video, which is part of Microsoft’s Modern Excel webcast series, we’ll cover the basic syntax of FILTER and then see how it compares to VLOOKUP, INDEX/MATCH, XLOOKUP, and SUMIFS. The question is: can FILTER accomplish the tasks we typically associate with these powerful Excel functions? Note: not all versions of Excel contain the…

Read More

### Learn by Email

###### Subscribe to Blog (free)
Something went wrong. Please check your entries and try again.