Power BI visualizations often have a Tooltip section with which is a feature that enables focus on specific attributes. For example, if you hover an item shown in the report, you can see information about the manufacturer, number of brands, average price, etc. Something like this does not exist in Excel, but if we can mark items in some way, it is possible, with a little improvisation, affect the display of attributes. To do this, we will use the Checkbox option…
Arranging data sets in Excel reports can sometimes get complicated, for example when you are editing a list of visitors to your stand at a business fair or congress. Then we usually manually copy the lists, merge them, and further remove duplicates. Excel has some new functions that allow you to literally do this procedure in a couple of steps, and in the following “recipe” you will find out how to apply them in practice.
Imagine this scenario: you register customers in an Excel spreadsheet, specifying their ID and then the products they use. Which customer uses which products? One way to get this answer is to create a pivot table, and then display customers, products and the number of products. The disadvantage of this report is that pivot tables always aggregate data. What if we only need a table with customer ID in one column and a consolidated list of products in another?
How to add an empty row after each row of data in a table? This procedure is often necessary so that we can comment on reports that need to be printed. It can be achieved in several ways and one of the simplest is by usint the Sort option. In this text, you will learn how to perform this action.
SORT is a new Excel function that generates a dynamic array of sorted values based on specified criteria. It allows us to specify the range of values to be sorted, to select columns, sorting order as well as how the data is being recorded, i.e. whether the sorting is done according to the data contained in the rows or according to those contained in the columns.