Excel provides over 16 dozen geometric shapes that you can size and manipulate to your specific needs, plus hundreds of special effects.

In this tutorial, I’ll show you how to populate a dropdown with data on another sheet. I’m using Microsoft 365 desktop on a Windows 10 64-bit system, but you can use older .xlsx versions.

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.