In the “recipe” Simple sales analysis, you could learn how to get to the value that is in the intersection of the row and column of the sales report. On that occasion, we used the INDEX and MATCH functions. The new XLOOKUP function allows this analysis to be performed in a much simpler way, by combining two instances of this function. Let’s see how it’s done!
Filtering affects the appearance of a report by setting certain criteria. If we create a pivot chart, it will be formed based on the data from the pivot table. If we change something in it, the chart will also change. Is this possible to do in traditional Excel reports? Yes, if you have an Office 2021 or Office 365 subscription, with the new XLOOKUP function. This is a simple method by which you can get effective reports.