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
27
Sep
Pivot Tables (Video)
A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.
Tips for Better Pivot Tables with a Large Data Set (Video)
In this tutorial we discuss creating a pivot table for a data set containing 3,000 rows. We cover which values should go in
How to Make a Combo Chart in 2 Minutes
In this short tutorial we’ll learn how to quickly make a combo chart in Excel to better visualize data coming to a
Learn the LEFT, RIGHT, and MID Functions in Excel
Here’s a quick intro the functions LEFT, RIGHT, and MID. These are very important if parsing data from larger strings
Improve Your Pivot Table Workflow in Excel
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
Dates in Excel – Part 1
Excel is very good when it comes to dealing with dates. To simplify the math on its end, it calculates a date as “the
30
Sep
How to use Paste Special in Excel
Paste special is a very good tool to have for a variety of reasons. Let’s cover the most common use cases: Paste Values
30
Sep
Using AUTOFILL in Excel – Part 2
(click here for Part 1) Paste Formulas Another way that you can autofill a formula across multiple cells is to Paste
27
Sep