How to Use the SUMIF Function
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
The Sum formula is one of the most common formulas that you’ll use in Excel. This formula allows you to add up the
A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.
In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in
In this quick video we take a look at how to improve your workflow around Pivot Tables in Excel. One of the best ways to
In this video we’ll discuss What is a named range? How to create your first one How to use named ranges in a formula
What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than
What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the
Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values