Microsoft Excel comes with a lot of built-in functionality that doesn't restrict you to comparing data in two columns using only one method.

If you need to reconcile batches of records in Microsoft Excel, this simple VLOOKUP() solution offers a quick and easy way to find records in one batch that are missing from another.

How to Compare Values of One Workbook to Another in Excel. In Microsoft Excel you can use a formula to compare two similar documents in different workbooks. For example, if a small business has ...

If you intend to obtain a list of all dates or data between two given dates in Excel, then you can Use the Fill handle or use a Formula. Learn how.

Custom ListsMS Excel definition – sort or fill in a user-defined order. Every Excel user has had to type in the same list over and over at some point.

Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

In this post, I will show you how to create an efficient to-do list with all the relevant details and turn your chaotic task management into a solid and productive system.