How to set print area in Excel For the sake of this example, we use a small set of data about employees of a fictitious company. The dataset includes position, division, city, and date of hire.

When this field is used by itself, Analyze Data returns a unique count. Excel’s Analyze Data returns a lot of great information considering how easy it is to implement and use.