Blog

Ms Excel, Convert

If you are trading in finance, or maybe you are an accountant or financiers, or maybe as an analyst, you must have swapped the negative values. In the balance sheet, it is customary to use parentheses instead of writing negative values. This article explains how to do it with custom formatting - CHECK

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).