Blog #Marcin Urbański

Sales managers in order to optimize their teams, often compare the work of their representatives. One of the primary metrics are the results sprzeaży. Very often this is average, but whether it is a fair measure?

Working with large and very large data sets, you may find that an error will creep into your calculations. To avoid the tedious scanning of thousands of records for verification before sending a report or analysis to your supervisor, I will describe to you how you can avoid it. Do you know array formulas?

Empty rows excel can cause us many problems, especially if it is their very much. Here with the help of came to us macro written in VBA but fortunately there are a few solutions to this problem.

Excel 2010-tabular data with 3D effect (Excel 2010)

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.

File protection in Excel password

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.