Connect slicer with Data Type

Discover the trick to connect a slicer to change Data Type entries in your dashboards. Follow our tutorial to learn the steps.

Return a result between 2 values

How to return a result between two values? With the XLOOKUP function, you can search in both directions, smaller or larger.

The 10 most useful Excel Functions

What are the 10 most useful Excel functions that you need to know? This article presents them with examples.

Function XLOOKUP in Excel

How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.

How to do a VLOOKUP on 2 columns

There is two techniques to build a research based on 2 columns. One is with VLOOKUP and the other, the easiest, with XLOOKUP

Transform List to Double-entry Table

How to convert a list of data to a double-entry table? Only one function is needed to do the job. See the technique in this article