New Excel Scan Function Explained One of the most significant advantages of the SCAN function lies in its ability to auto-update as new data is incorporated into the designated range.

This tutorial shows the steps to use Automatic Data Type in Microsoft Excel. It allows you to insert details of cities, food items, music, animals, persons, etc, automatically.

The best new tool from Microsoft Excel is undoubtedly the SCAN function. Here's how to use it to calculate running totals. Find the full guide at Spreadsheet Point.