It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a
In this video we go over how to quickly remove blank rows from an Excel sheet and clean up some free space on our workbook
In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but
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 quick video we take a look at how to improve your workflow around Pivot Tables in Excel. One of the best ways to