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