Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...

One formula filters, dedupes, and ranks your data into a live list. No more manual sort or remove duplicates.

Do you often stare at a spreadsheet, deal with endless data, and feel like there has to be a better way to get things done?