The CONCATENATE function

The Concatenate function concatenates texts in different cells and allows you to write them in one single cell. Texts can be edited in a very flexible way with the Concatenate formula. In this [...]

Explore the skills of Go To Special!

The function that allows you to detect all cells that contain special data like comments, formula, space, and data validation in your Excel list is the Go To Special function. With this formula, [...]

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

Power Apps DateAdd Function

Power Apps is a product that allows you to develop mobile apps based on your company’s needs. While developing your mobile app, you add and manage each one of the items on your screen one [...]

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