A pivot table is a feature of Microsoft Excel that allows a user to quickly summarize and analyze a large set of data.
INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place
In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero
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
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
Very often in Excel you want to summarize a set of data to pull out insights. The MIN and MAX functions can help you do
In this post I’ll show you a quick excel shortcut for calculating a rate of change. Rate of change is defined as the