Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding
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