### 15 Features That Make Excel “Excel”

15 Features That Make Excel “Excel”   Hello everybody, Here we are with another long article again. As you know, Excel has been an indispensable part of our office life for a [...]

### 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 [...]

### WRITING MACROS WITHOUT KNOWING HOW TO CODE!?

DO YOU REALIZE THAT YOU CAN WRITE MACROS WITHOUT KNOWING HOW TO CODE?   That is an interesting title, isn’t it? Just like touching the clouds. We want it a lot, but unfortunate we just [...]

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 [...]

### EXCEL’S HISTORY (EXCEL FROM PAST TO TODAY)

EXCEL’S HISTORY (Excel from Past to Today)   Hello everyone, I received a lot of questions like “Who found Excel, how was it created? It develops all the time, I wonder how the [...]

### 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 [...]

### GET RID OF DUPLICATE RECORDS WITH THE UNIQUE FUNCTION

THE UNIQUE FUNCTION   Hello everybody, In this article I will be talking about one of the The Dynamic Array Functions -the UNIQUE function. Before this function, we had to write a long [...]

### 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 [...]

page 1 of 4