Find the Difference Between Two DateTimes in Excel
Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding
DATE vs. DATEDIF Functions
It’s no surprise that Excel is often used for time based reporting, whether analyzing trends over time, creating a
How to Select and Remove Blank Rows (Video)
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
How to Compare Lists in Excel (Video)
In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH 2. VLOOKUP Both can be effective, but
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.
How to Use Index & Match (Video)
INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place
Common Errors in Excel (Video)
In this video we discuss the most common types of errors in Excel, including the N/A error, Value error, divide by zero