These options are available through the Ribbon, but Quick Analysis lets you see them all in one place, and you can preview each transformation by hovering over it. The Quick Analysis tool in Excel gives you options to help understand your data, right from a range selection. This tutorial will demonstrate how to use the Quick Analysis tool in Excel.
