Working with output Back to academy

Excel

Working with output  |  Filip Podstavec

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:

Protected view Excel

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:

Wrap text removal in Excel

Using wrap text:

Using wrap text in Excel

After wrap text removal:

After wrap text removal in Excel

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.:

Using text filter in Excel

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.

Using number filter in Excel

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:

Chart in Excel

Other tutorials for Microsoft Excel:

Instructions on how to make charts in Excel can be found at:
http://blog.hubspot.com/marketing/how-to-build-excel-graph#sm.0001r0d1h49fkev4ss01cfocetczs

Filip Podstavec

Filip Podstavec

Filip is Marketing Miner CEO. His daily food are innovations and new link building & SEO techniques. As a consultant he has more than 10 years of experience.

You haven’t decided yet?

That’s ok, you can try us easily for free.