Slow to Fast 3

This is the final post in the Slow to Fast series, where we are incrementally improving the efficiency of reconciliations.

In the first post, we looked at conditional formatting. This was a great option when the lists were relative shortly, stored on the same worksheet, and only required us to look at a single column.

In the second post, we examined lookup functions. This enabled us to quickly reconcile lists that were on separate sheets and that required us to compare the amount. But, if we perform such a task on a recurring basis, we can consider using Power Query, which is the topic for this post.