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.