Blog

A very popular feature that allows us to aggregating the values of only when the condition is met if. You want to know how to take advantage of it-go and check

Looking for tips about how to search the find function of the text in a cell-this is the right place. In an easy and simple way you will find a description of this feature. Read more ...

According to me one of the most useful features in Excel, which allows us to combine data sets-the "VLOOKUP"

For some unspecified reason, the data.difference function is not automatically suggested. Especially for you, I present how to use it :-). Since it is a "ghost" function you will not find it anywhere - neither on the function list nor in the Excel documentation, and you have to enter it completely yourself.

A very popular feature that allows us to aggregating the values of only when the condition is met if.

The "basics" should be used when we want to replace a string, but we cannot determine its location (one place) in the text.

A very useful function for human resources and Payroll-Payroll (of course not only) when you want the settlement of workers, and we need to enumerate the number of days worked (free of holidays and weekends).