Blog #formuły excel

Determining the Quarter When preparing sales reports, I have often used quarters as units of time. Particularly helpful in joint-stock companies, where a quarterly financial and operating report should be prepared. I will show you how you can ask Excel to provide us with this information.

Ms Excel, Convert

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