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
A spin button in Excel is a great way to create an interactive and dynamic scrolling range for reports, dashboards, or data analysis. In this tutorial, we’ll walk through how to insert a spin button, link it to a cell, and use it to scroll through data by days, weeks, months, quarters, and years. Let’s…
Read More
Removing duplicates in Excel is a common task, but what if you want more control than the Remove Duplicates command provides? Maybe you need a formula to handle duplicates dynamically. In this guide, we’ll cover how to remove duplicates from a single column, handle multiple columns, and use formulas for various scenarios like summing, finding…
Read More
In this post, we’ll dive into the following Excel question: How do you sum positive values between two dates? Using the SUMIFS function, we’ll walk through three exercises to build a solution step by step. By the end, you’ll have a clear understanding of how to sum data based on multiple conditions. Let’s get started!…
Read More
Today, I’ll tackle a question I received recently about checkboxes. The question was essentially about how to add two values in Excel when a checkbox is checked. I’ll walk though the answer with you in this short post. Let’s jump right in! Video Step-by-Step Guide Exercise 1: Getting Started with Checkboxes To get started, we…
Read More
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.
Read More
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…
Read More
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…
Read More
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
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
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