Structured tables (Data tables) or, as we call them, named ranges represent a group of cells that have been given a name and a filter to make it easier to view and work with the data they contain. If these tables start from the first cell in the worksheet, you can set the cell header to appear instead of the worksheet header. To be more precise, instead name of the columns they contain.
Conditional formatting is an Excel functionality that is often used, and allows you to emphasize certain parts of the report. Typically, conditional formatting is used within the same column, but how do we display “traffic lights“, icons that indicate a change in business, within another column? This is a very simple procedure, and if you want to find out how this is done, you have it in this “recipe”.
Pivot tables often store data in the cache, and some of that data is also that about slicer elements. Slicers take values from the source table. If we add some of them and then delete them, it may happen that the slicers show phantom values. They are shown in pale color, as if there is no data. And indeed, if we pick such a value, we will get an empty pivot table report. How can slicer elements always be up to date?
Structured tables (Tables) make it much easier for us to work with data. When we convert a range of data into a table and then give it a suitable name, we can easily access each column by specifying its name or a combination of table and column names. By entering a formula in the first cell, it is automatically updated in remaining cells within the column. And what if we don’t want that? What should we do if we need to use the current row value?
When analyzing sales, we will often come across data series that would be convenient to display using a Stacked Column or Stacked Bar chart, but due to their nature this is not a good solution. For example, if we have a production cost and a sales price, we need to calculate the price difference in order to show the production price and the price difference as two complementary series on the chart; their sum is, it is easy to see, the sales price. Can we create such chart without additional calculation?