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!
One of the earlier “recipes” was about the INDIRECT function. It serves to forward a range as a parameter of SUM, AVERAGE, MAX, MIN or, for example, some other aggregation function. A range is defined as string that is contained in another cell. Let’s show, in one simple example, how this works.
Sales volume in relation to a given target can be shown by a goal achievement chart. There is another way to do this, and that is to display real sales values instead of moving the intersections of the x and y axes, using a Combo chart in which the target would be a horizontal line based on the data in the table. Also, by adding the Spin Button control, we will be able to change a goal easily, which leads to the dynamic chart.
When we make charts in most cases we’ll use text labels, numbers, dates, percentages etc. to display categories on the x axis. Sometimes descriptions are too long, so we have to work in different ways to display them in an adequate manner. Could we use something that describes them more closely such as a currency symbol, an envelope, a smiley face? In this “recipe” you will learn how to add different symbols to a table or chart.
The definition of fractals is quite extensive, so I will reduce it to a short interpretation that they represent images, created from repetitive patterns, and their representation is calculated by applying certain mathematical equations. Since I make an Excel greeting card almost every year and create a “recipe for drawing a Christmas tree” I will not deviate from tradition. We will “draw” the Christmas tree with the help of one simple fractal.