Excel formulas – As with the different versions of Windows , which were previously tested by the Microsoft Insider team, Office also has its subscribed testers. This what allows us is to be able to know first-hand the news that will soon arrive in programs such as Word or Excel.
As with the Windows Insider program , with this test plan everyone wins, both the testers themselves and the Redmond firm. On the one hand, the former have access to all the long-awaited news that will be implemented in the productivity suite. But at the same time and on the other hand, Microsoft has, almost free of charge, a large group of people in charge of locating the flaws in their project. So, as it is easy to imagine, they have the opportunity to solve them before the official launch.
Also Read : 5 Free alternatives to Microsoft Excel
Microsoft Excel does not stop improving and growing
Once we know this, in these lines we want to focus on a novelty that will reach an application of the importance of Excel. This is part, together with Word or PowerPoint , of the Office 365 office suite that we have spoken about. This is specifically the one that focuses on working with numerical data, which is why it is used in both domestic and more corporate environments.
As it could not be otherwise, in order to get the most out of the program, we are the users who have to enter the corresponding data. Later, Excel puts at our disposal a series of functions to be able to work with this data, in the most efficient way possible. All this will help greatly to improve our productivity, especially when working with numbers.
LET, the new function that optimizes the use of formulas
And it is that at the same time we must bear in mind that the use of functions and formulas in Excel is key to be able to take advantage of its potential. There are many formulas at this time in Excel, and now the function called LET will be added .
At first this is going to be of great help to save time when using certain formulas that repeat the same operation several times. This is quite common in this application, but not entirely stable or practical. This is precisely where the use of the new LET function will come in. Broadly speaking, what this will allow us is that every time we have to use a formula that repeats the same calculation over and over again, LET will allow us to assign the different results obtained to variables that we are defining.
This will help us to optimize the work with some complex formulas of the program, at the same time that we save ourselves having to repeat that same operation. It will also allow us to control more effectively the error messages that certain operations return to us in these repetitions of operations that we discussed. It is evident that all this is mainly focused on advanced program users who will be able to test LET shortly.
It is worth mentioning that in these moments, as we mentioned before, LET is available in the Insider version of Excel for Office 365, specifically for the fast ring.
Also Read : Macros in Excel: What they are and how to create a Macro
