MAP is used as an auxiliary function, in combination with the LAMBDA function, it is dynamic in nature and returns all those data range values that meet the specified condition. It reminds a little of other functions for working with dynamic arrays, but instead of values, it returns those that were calculated within a given expression. The LAMBDA function is in charge of the calculation.
LAMBDA is a new Excel function that allows easy creation of formulas, for one or more parameters. It works similarly to the LET function, but offers significantly greater capabilities. This feature was announced 2 years ago and only today it was included in the Microsoft365 update, so I’m looking forward to finally sharing with you the knowledge of how to use it. Let’s get to know the LAMBDA function!
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.
Do you like Visio? It is an application that essentially belongs to the Microsoft Office, but is purchased separately. I used it to draw diagrams, but the number of objects it offers indicates that it is applicable in many activities where some type of design is performed. Recently, there is an add-on that allows you to easily create Visio diagrams within an Excel document. It’s called Data Visualizer. Let’s see how it is used!