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
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
How to Create a Named Range (Video)
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
RANDBETWEEN – Excel Function
What it does: The RANDBETWEEN() Function generates a random number between two integers. Plain English: Rather than
RAND – Excel Function
What it does: The RAND() Function generates a random number between 0 and 1. Plain English: The random function is a brother
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
AVERAGE – Excel Function
The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be
SMALL – Excel Function
What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()