Let’s explore these tools (apart from the last one) on a simple problem case example. Scenario Manager – the scenario manager allows you to add several scenarios to a certain problem and then generate a summary comparing how the scenario values impact a selected cell value.

The What If Analysis button in the DATA ribbon tab facilitates generally two useful features: PivotTables are great for exploring data sets and for visualizing data with the help of automatically generated PivotCharts. PivotTables are so versatile a tool that most often no other Data Analysis Tool is needed. See below for a quick look at how to use the Sort and Filter feature in Excel on an example data set: Let’s kick off with the Sort & Filter group. I am not focusing on simple data transformation features like removing duplicates, however, I do encourage that you learn more on these non-mentioned features. 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.

Excel 2010 data analysis tool