XLOOKUP: THE GAME CHANGER

THE XLOOKUP FUNCTION Last you on August 29, two new important functions were announced: XLOOKUP and XMATCH. In this article, we will be talking about what the XLOOKUP function is, when and how to [...]

GEOGRAPHY LINKED DATA TYPE

GEOGRAPHY DATA TYPE There were always data types in Excel. But they were traditional data types like text and number. Stocks and Geography data types are unique because they are accepted as [...]

HAVE YOU EVER SORTED WITH A FORMULA?

THE SORT FUNCTION   Hello everyone, No doubt that one of the most frequently used functions in Excel is the Sort function. This feature has 2 constants: A-Z and Z-A i.e. Ascending and [...]

FILTER: NEW GENERATION FUNCTION

THE FILTER FUNCTION Hello everybody, In this article, will talk about the abilities of the FILTER function that is one of the New Dynamic Array functions. As you know, new changes have been [...]

SORT DATA WITH THE SORTBY FUNCTION

THE SORTBY FUNCTION Hello everybody, There are functions about sorting among the newly released dynamic array functions. They are: SORT SORTBY We will be talking about the SORTBY function in this [...]

CREATE A SPEEDOMETER CHART

SPEEDOMETER CHART   Hello everyone, In this article, we will create a Speedometer chart. We will see how to create it simply step by step. Let me tell you this first: Microsoft will add this [...]