This article is also available in:
Excel table is the basic output of Marketing Miner that is available to a user after completing a report. It always contains an initial list (Report) that summarizes info about collected data, then a general list Data that contains data that were accessible at output for individual lines, and then other lists according to miners that cannot be paired straight into a line.

Design adjustment

After downloading and opening the file, a user gets to the initial list (Report). Some Excel versions ask for permission before manipulating, because it is a file that is downloaded from the internet, comparably to the image below:

To be able to manipulate the file, a user first has to give permission to do so. Excel also often displays output file without wrapping the text, which could look chaotic to a user. To make it more clear for a user, the wrap text function should be removed:

Filter creation

Filter function is used to adjust data display. This function will create a filter range from the top columns, which will allow user to search for rows in columns or to otherwise filter dataset content:

Examples of content filtering

Basic filtering is text filtering. A user types in a part of the text that corresponds with the cells of selected column and after clicking OK, a user gets to the dataset only corresponding with the assignment.

Excel has two basic and most commonly used types of filters:

Text filters

In case there is a text content in the column cells, Excel uses text filters to filter it. These filters work similarly to searching and their functionality is intuitive to its name.:

Number filters

In case there is a numeral content in the column cells, Excel uses number filters to filter it. Those allow user to select a part of the dataset that corresponds with more complex conditions of the range or with the minimum or maximum value of the column cells.

Conditional formatting

Conditional formatting is used to change a color of the cell, based on its value compared to the whole column. An example of the application and the output can be found in the video below:

Making charts

Using output data, a user can then make charts:

Other tutorials for Microsoft Excel:

Instructions on how to make charts in Excel can be found at:
Was this article helpful?
Thank you!