The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait.

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.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.