When working with pivot tables, you will sometimes use filters to change how the data is presented in report based on the selected criteria. Using filters or using slicers are completely legitimate methods. But what if you want to create a separate report for each criterion you used in the filter. Excel has a simple option that allows you to do this…
A few years ago, Excel, which comes as part of a Microsoft 365 subscription, got the Ideas option. Now this option has been improved and is called Analyze Data. It enables, with the help of artificial intelligence, simple and fast data analysis to generate tables, pivot tables or charts according to user questions, which help user to visualize data in appropriate business reports.
For several years now, Power BI and Excel have been developing side by side with the idea that analysts do not save all their tables exclusively on a local computer, OneDrive or SharePoint repositories, but that they can also download them from Power BI reports that are published on the company’s tenant. If you use a Microsoft365 subscription that is connected to a company account, you can easily retrieve such tables.
How to replace zeros with empty cells? Although this question seems simple, you may find yourself in a situation where you need something like this, and you will not have the right answer. When it comes to data in Pivot tables, it is logical to define this in the options. But they allow you to determine how to treat empty values, not zeros. Zero is not an empty value. You will find out how to replace zeros, regardless of the type of table, in the “recipe” that follows…
In the previous texts, you could learn about several ways to consolidate data, and here we will deal with consolidation using a pivot table. To be able to achieve this we will use the Pivot Table and Chart Wizard. This is a hidden option that you can’t find in any of the ribbons (you can add it yourself, if you wish, by adjusting the layout of the ribbon), and it makes it easier to create pivot tables and charts …