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 short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a
Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings
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
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
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste