
In this post I am focusing just on features that allow you to explore data or solve certain analytical problems. Skip to the relevant section of this post to read more. Some of them are AddIn that are installed by default along with MS Office, however, need to be activated manually. The DATA ribbon tabĪs some of you already have noticed MOST (except for the PivotTable for no good reason) of the tools described in this post focus on features available BY DEFAULT within the Excel DATA ribbon tab (see image below). Be sure to read through the Other Tools section below for other honorable mentions.

I mean to explore the basics, as well as the more advanced Data Analysis Excel Tools. Excel is most appreciated for it’s ease of use as a Data Analysis Tool.
