Microsoft Excel 365 gives us a new function – LET(). It is not available for every Microsoft 365 subscriber though. A few weeks ago my Excel did not have this function, but now I can work with it. I did a few examples when I was learning this feature and want to share them with…Read More LET function in EXCEL 365
I always used VLOOKUP formula, I could do it even with my eyes closed, but now when I have Excel 365 I can use XLOOKUP, which is similar but not the same. When I have learned this new functionality I found out that I also have an option to use dynamic array formulas in a…Read More XLOOKUP function and dynamic array formulas – Excel 365.
While I was preparing to work in the new (for me) Microsoft Office 365, I learned that Excel 365 already has the “built-in” Power Query add-in. It does not appear directly on the ribbon. It is located under the DATA tab. For previous versions of Excel, the Power Query add-in should be downloaded from the…Read More Power Query installation.